Need sql for this

[rafterman550]

Hello as most of you can tell from my two posts i am new to sql and access and i am trying to learn fast.

i have a piece of code i need help with

where cms.Date_Rec,cms.Date_Req,cms.Date_ret = [enter date] and now()

i want to basically return all records for fields

date_rec, date_req, Date_ret where the date range is [enter date] to current date and system time.

SELECT * from cms
where cms.Date_Rec,cms.Date_Req,cms.Date_ret between [enter date] and now();
order by creator decending;

dont know abody can help with this it be much appreciated

Regards

Daniel

[pbaldy]

Each field needs the complete criteria, separated by AND or OR as appropriate to your needs:

...cms.Date_Req between [enter date] and now() AND cms.Date_ret between [enter date] and now()...

[rafterman550]

Ok cool i see ill give it a try

thankyou for you help

Regards

[pbaldy]

No problemo!

[rafterman550]

Hello pbaldy thank you for you last response,

could you help me with something else please.

i want to be able to select Creator,Quote_No,Date_Rec,Date_Req,Date_Ret
from cms
where (how do i select a date) date = ? or where date = now()

i.e. [Enter a date]


Regards

Daniel

[orange]

select Creator,Quote_No,Date_Rec,Date_Req,Date_Ret
from cms
where Date_Rec Between Between [Enter a Date] And Date()

Date() refers to Today's Date
Now() refers to Today's Date and time

If one of your Date_Rec values is something like Mar 15, 2011 you have to enclose that date in #.
eg. Between [Enter a date] AND #3/15/2011#