Odds and Ends

Dear Readers:

Here are yet more answers to miscellaneous questions. Maybe someone has asked me a question to a problem or situation that you were wondering about.

-- Ted

READ MORE >

Client Access Hotspots

Hey, Ted:

I want to display a calendar if a user clicks on a date on the first line of a display. The date field is a ten-character output field in mm/dd/yyyy format.

-- Bill

READ MORE >

Reader Feedback and Insights: Dynamic Result Field in Query/400

In the article "Dynamic Result Field in Query/400", which appeared in Midrange Guru, OS/400 Edition, Bill wrote, "Every month we run a query that reports year-to-date sales. The year-to-date sales field, YTD$, is defined as result field that adds up monthly numeric buckets from a sales detail file. For example, the YTD$ for March will contain the expression Jan+Feb+Mar. However, before we can run this query each month, we have to add the next month to the expression. We would like to avoid having to modify the expression every month. Is there a way to make this query read the expression from a database file?"

-- Bruce