Adding up a column (office 97)

Topic

New Reply

Hello everyone 2 things

1st-
I would like to make a query where the user could select an ID from a list as well as a begin and an end date to search within. the data from the table would then be extraced with all accounts under that ID for the time period selected. i know i have seen a greater than this date, less than this date feature but have no clue how to implement it. FYI – each row of data for all ID’s have a transaction date that i would be referencing it to. Could someone please provide the details.

2nd

I would also like to make a similar query but instead of only showing all the individual transactions under an ID for the period i want my output to add up the’ transaction cost’ columns for all the data contained. i just need anm addition feature for a column and i can then use a report to display it. thanks a million.

Reply | Quote

Replies

1st-
When creating your query using the design grid, specify something like “Between [Enter Start Date] And [Enter End Date]” for the transaction date criteria and [Enter ID] for the ID criteria (make sure they’re in the same criteria row (causing the AND logic to be used between the two conditions).

2nd-
Similar to the above, but specify a “Totals” query. You then specify “Where” in the “Totals” row of the design grid for the ID and Transaction Date fields and use the same criteria as above. Add the Transaction Cost field to the grid and specify “Sum” in the Totals row.

This is a little sketchy, but will hopefully get you going down the right path. If you need more help, holler!

Reply | Quote