default paramater values

V

Vaard

I have a paramater query that asked for a beginning date
and an ending date. Is there anyway to write in a default
date?

My records range from 12/1/01 to current date.

Right now, the date column has a criteria of:
Between [Type beginning date:] And [Type ending date:]

Two parameter boxes appear, first asking for beginning
date, second for ending date.

i would like to have to option of leaving either or both
of the paramater boxes and it will default to a beginning
date of 12/1/01 and an ending date of the current date.

Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top