date value in access 2003

Hi Experts

I have in the following in my query select

Criteria Fields        Date
Value                 "What do i insert here"

I need to add a value in the above so it pull back all data from to date to year dot....backwards....
route217JuniorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try something like this


<=Date()


that will return all records with dates equal to today and back


<=#9/2/2012#

will return all records with date equal to 9/2/2012 and back

i prefer using this as criteria for date range


between  dateserial(year(date()),month(date()),day(date())) and dateserial(year(date())-1,month(date()),day(date()))


that will give records with date between today and a year ago
0
route217JuniorAuthor Commented:
thanks for the feeeback...

cap1....I tried the first recommendation and go no results. ..I am trying to connect to access via excel 2003 get external data source option. ...

the table in access has data in it...
0
route217JuniorAuthor Commented:
hi cap1

cut a long story short...when I try and look a the select qry..via excel. .it prompt me when a dia logue box saying enter parameter 1....
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Rey Obrero (Capricorn1)Commented:
better upload a copy of the db...
and post the sql of the query you are working on.
0
route217JuniorAuthor Commented:
Hi Cap1

here is the query statement....

SELECT DCData.ID, DCData.Date, DCData.CustomerType, DCData.RollNumber, DCData.Brand, DCData.DemandCategory, DCData.DemandType, DCData.Resolution1, DCData.Resolution2, DCData.Userid, DCData.DateTime, DCData.Site, DCData.Date, DCData.Date, DCData.Date
FROM DCData DCData
WHERE (DCData.Date=?)

Open in new window


I am guess because i have a ? after the equals sign when i need to pull back data that is <= Date()....

is the reason why the paramemter window is popping up all the time when i try to pull back the data into excel...
0
Rey Obrero (Capricorn1)Commented:
try this and see what you will get, copy and paste and run


SELECT DCData.ID, DCData.[Date], DCData.CustomerType, DCData.RollNumber, DCData.Brand, DCData.DemandCategory, DCData.DemandType, DCData.Resolution1, DCData.Resolution2, DCData.Userid, DCData.DateTime, DCData.Site
FROM DCData
WHERE (DCData.[Date] <= Date())
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
route217JuniorAuthor Commented:
works prefectly....superstar..
0
route217JuniorAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.