Picking records to print

[Maggie23]

Hi - I know what I want to do but don't know where to begin.

I have only one table that I need to get information from. After a user enters new records for the day I want them to be able to open a form that shows the day's (or session's??) first new record ID and the last new record ID entered.

Then I want them to be able to enter a beginning ID number and and ending ID number of records to preview then print. (Which probably will be the same as the day's ID numbers above but sometimes may be different).

Thanks for any and all help.

Mags

 

[KeithB13]

picking records to print

Maggie,

Set up a query that will get grab the date field and other relevant feilds. Type ">Date()-7". This will query out all records with dates less that 7 days old.

To print records with in a certain range try "Between[value 1] and [value 2]" in the criteria feild of your query.

Good luck
Keith

 

[Maggie23]

Keith
Thanks for your help. The between expression was just what I needed for part of my problem. For the other part I see that what I need is more help with a query. I have posted a revised question in that forum.

Mag