Is there a shortcut...

N

Neal

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...
 
G

Guest

hi,
i use
=[Start Date] and <=[End Date]
Click to expand...
-----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...
.
Click to expand...
 
N

Neal

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?

[email protected] said:
hi,
i use
=[Start Date] and <=[End Date]
Click to expand...
-----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...
.
Click to expand...
Click to expand...
 
Top