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!

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

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?

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

Can you post the exact query you formed, in text and the table structure.

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! :)

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

;)

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.

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

no probs dear

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?

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 :)