Is there a shortcut...

[Guest]

I am useing this formula in one of my queries:
On the criteria line of that date field write:

Between [Start Date] and [End Date]

I am trying to find out if there is some sort of shortcut to allow all
records to be shown. Almost a bypass shortcut.

Thanks...

 

[Guest]

hi,
i use

=[Start Date] and <=[End Date]

-----Original Message-----
I am useing this formula in one of my queries:
On the criteria line of that date field write:

Between [Start Date] and [End Date]

I am trying to find out if there is some sort of shortcut to allow all
records to be shown. Almost a bypass shortcut.

Thanks...
.

 

[Guest]

The code that you provided gave me a way into the database without entering
dates but it didn't seem to show me any records?

hi,
i use

=[Start Date] and <=[End Date]

-----Original Message-----
I am useing this formula in one of my queries:
On the criteria line of that date field write:

Between [Start Date] and [End Date]

I am trying to find out if there is some sort of shortcut to allow all
records to be shown. Almost a bypass shortcut.

Thanks...
.