query by date selection

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

 

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

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)

 

[hisham]

what correct coding?can you write down?

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.

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)

 

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

what correct coding?can you write down?

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

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)