query by date selection

H

hisham

Dear member,
could you correct my syntax for view data only date selected as
Enter your date: example 1/1/2008 to 31/5/2008
I have data from date 1/1/2006 till now.
 
A

Allen Browne

If you want Access to prompt you for 2 dates, try:
Between [Starting date] And [Ending date]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

hisham said:
Dear member,
could you correct my syntax for view data only date selected as
Enter your date: example 1/1/2008 to 31/5/2008
I have data from date 1/1/2006 till now.
=DateSerial([Enter date:],1,1) And <DateSerial([Enter date:]+1,1,1)
Click to expand...
Click to expand...
 
H

hisham

what correct coding?can you write down?

Allen Browne said:
If you want Access to prompt you for 2 dates, try:
Between [Starting date] And [Ending date]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

hisham said:
Dear member,
could you correct my syntax for view data only date selected as
Enter your date: example 1/1/2008 to 31/5/2008
I have data from date 1/1/2006 till now.
=DateSerial([Enter date:],1,1) And <DateSerial([Enter date:]+1,1,1)
Click to expand...
Click to expand...
Click to expand...
 
A

Allen Browne

That's it. In query design, you just type that into the Criteria row
underneath your date field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

hisham said:
what correct coding?can you write down?

Allen Browne said:
If you want Access to prompt you for 2 dates, try:
Between [Starting date] And [Ending date]

hisham said:
Dear member,
could you correct my syntax for view data only date selected as
Enter your date: example 1/1/2008 to 31/5/2008
I have data from date 1/1/2006 till now.

=DateSerial([Enter date:],1,1) And <DateSerial([Enter date:]+1,1,1)
Click to expand...
Click to expand...
Click to expand...
 
Top