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