Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   getting date out of a table, from a query (http://www.go4expert.com/forums/getting-date-table-query-t1760/)

jrobertson 31Oct2006 02:18

getting date out of a table, from a query
 
Ok, I am extremely new to Access and am clueless. I don't know anything about it except that I DON'T GET IT.

With a friends help, I've managed to get this far..

I have created a query and it pulls data from 90days from dbo_ticket_responses which is my table. Instead of 90 days, I need it to prompt me on the date range, i.e. I need i to say "between what date?" and "and what date" and then only return those results.
Can someone please help me with this, and maybe help me out with it? Thank you so much!

rahulnaskar 31Oct2006 18:37

Re: getting date out of a table, from a query
 
your query should go like
select <fields> from dbo_ticket_responses where <date> between #Start Date# and #End Date#
Hope this helps

jrobertson 31Oct2006 20:02

Re: getting date out of a table, from a query
 
http://www.dreamscapetech.net/~vups/almost.JPG

That's what I was told by someone else to put in, yet I'm getting an invalid bracket error.

Any suggestions?

rahulnaskar 1Nov2006 12:39

Re: getting date out of a table, from a query
 
Can you post the exact query you formed, in text and the table structure.

jrobertson 1Nov2006 18:31

Re: getting date out of a table, from a query
 
http://www.dreamscapetech.net/~vups/query.JPG

I erased the part that I added yesterday that was giving me the error. This query actually works, it just shows 90 days worth of data. I don't need the entire 90 days, I just need it to prompt for a BEGIN DATE and a END DATE (Between start and end)... I can't figure out how to get it to work.

Thanks for your help! :)

rahulnaskar 1Nov2006 18:48

Re: getting date out of a table, from a query
 
;)

jrobertson 1Nov2006 18:50

Re: getting date out of a table, from a query
 
As soon as I can get this date thing to work, this project will be complete!! lol... Hopefully you or someone else on this forum can maybe help me. I've been working on this forever and it's really stressed me out.

rahulnaskar 1Nov2006 18:52

Re: getting date out of a table, from a query
 
no probs dear

jrobertson 2Nov2006 02:08

Re: getting date out of a table, from a query
 
http://www.dreamscapetech.net/~vups/bleh.JPG

It prompts me for the date now, and it comes back with that error once I specify a date range.

Any ideas?

jrobertson 2Nov2006 02:44

Re: getting date out of a table, from a query
 
I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


A fellow on utteraccess helped me.. I GOT IT!! Thanks for the help though :)


All times are GMT +5.5. The time now is 13:59.