Input Dates for Criteria

[commandolomo]

Hello Everyone

I am designing a database, on which the main sheet is to hold many month's worth of data. I am setting up some queries to run against this, and instead of setting up various queries for each month, is there anyway that when a query is run, two prompt or input boxes appear, where I can input the dates I want to bring back info for, eg Start Date & End Date?

For any BusinessObjects users out there, a bit like when you refresh a report, you can set up Prompt boxes for the two dates to interogate and return data for.

Any ideas?

 

[Len Boorman]

Various ways

One way
In query criteria put

Between(Please enter start date) and ( Please enter end date)

This will cause two dialogue input boxes to appear at the appropriate time to collect start and end dates from user

Len B

 

[commandolomo]

Len

Many many thanks, just what I was after!

Regards