Another DATE question...

[dwilliams]

Hi
I had a normal select query that when I ran it offered up two Message Boxxes for the user to enter the start and end date from which the records would be selected.

I lost it!!! Bu99er!

Can anyone help me recreate it - I can't remember whether there were two new fields in the query ( StartDate:[Date] and EndDate[Date]) or something like that or if it was a criteria on the Date Field.

Thanks a lot

David

 

[HiTechCoach]

Hi
I had a normal select query that when I ran it offered up two Message Boxxes for the user to enter the start and end date from which the records would be selected.

I lost it!!! Bu99er!

Can anyone help me recreate it - I can't remember whether there were two new fields in the query ( StartDate:[Date] and EndDate[Date]) or something like that or if it was a criteria on the Date Field.

Thanks a lot

David

David,

Make lots of backups!


If you want to select records by a date range, then yiouy can use criteria for a date field:

Example Criteria:

Between [Enter Start Date ] and [Enter End Date]

I prefer to use a form to collect he data. See the attached example.

 

[dwilliams]

Thanks Coach works fine.

I have been doing backups regularly using the free version of Syncback. I think a setting must have been incorrect as I don't seem to have the latest copies of things. My database was one, .pst file another. I will check that they are working next time instead of just clicking the button.