Range Parameter Query ... to give range or all records

[lgvelez]

I have asked this before, but have not been able to get anything to work. In a standard parameter query, created within the query grid, I can make a parameter query that will either match the parameter, or with no input, list all of the records. How do you do the same thing within a parameter range query within the query grid? (Between [First Date] and [Second Date])

Thanks.
Laura Velez
lauravelez@home.com

 

[DougP]

Not sure what you are asking. you are very close

if you just put this
Between [First Date] AND [Second Date]
in your date field it should work

run the query and it will ask for "First Date"
then ask for "Second Date"
key in valid dates and make sure you are keying in dates that are in your Table
then you should get results between those two dates but not including them.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site

http://www.barcodeone.com

 

[lgvelez]

Sorry for not being clear ... but what I want to do is NOT key in any info when requested, but to just press Enter twice, and get ALL the info. So far, I can do that with a single parameter input, but not with a parameter query needing 2 pieces of info.
Laura Velez
lauravelez@home.com

 

[DougP]

I made two finction once so nothing had to be keyed at all.
I put them in the between statements like so

Between LastMonday() And LastFriday()

the functions figured out what Date, Last Monday and Last Friday was based on the system date today
So we got a report of Invoices for last week. DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site

http://www.barcodeone.com