date range & addition

[scrappe7]

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.

 

[67peshawar294]

scrappe,
I'll try to give you some help.
1st
Create a new query with the fields you need. In the criteria for your ID field type;
Like[Enter an ID]
(if you just want to enter a partial ID, you can use wildcard *)
In the date field under criteria type;
Between [Begin date] And [End date]
When you open the query a "Enter Parameter Value" box will appear for the ID and for begin date and for end date. You have to enter valid dates, no wildcards.

2nd
Create a query using the query wizard and simple query.
Select the table or query and transfer the fields from the lft to rt side. Click next. and click summary. choose the fields you want summarized.
Hope this is enough to help
jim
Jim