Parameter Query Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Parameter query for a birthdates .mdb and I want to be able
to capture all the birhdates between start date and end date. As it is now I
get only birhtdates from the start date and the end date and none of those in
between.

Here is the SQL

SELECT fbcbc_birthdates.fbcbc_birthdatesID, fbcbc_birthdates.FirstName,
fbcbc_birthdates.LastName, fbcbc_birthdates.Birthdate
FROM fbcbc_birthdates
WHERE (((fbcbc_birthdates.Birthdate)=[start date])) OR
(((fbcbc_birthdates.Birthdate)=[end date]));

Can anyone help?
Thanks
mike_e_ebermed
 
That did it! Thank you

mike_e_ebermed

Allen Browne said:
Try:
WHERE fbcbc_birthdates.Birthdate Between [start date] And [end date]

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

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

eberned said:
I have created a Parameter query for a birthdates .mdb and I want to be
able
to capture all the birhdates between start date and end date. As it is
now I
get only birhtdates from the start date and the end date and none of those
in
between.

Here is the SQL

SELECT fbcbc_birthdates.fbcbc_birthdatesID, fbcbc_birthdates.FirstName,
fbcbc_birthdates.LastName, fbcbc_birthdates.Birthdate
FROM fbcbc_birthdates
WHERE (((fbcbc_birthdates.Birthdate)=[start date])) OR
(((fbcbc_birthdates.Birthdate)=[end date]));

Can anyone help?
Thanks
mike_e_ebermed
Click to expand...
Click to expand...
 
Back
Top