getting date out of a table, from a query

jrobertson's Avatar
Light Poster
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's Avatar, Join Date: Aug 2004
Go4Expert Member
your query should go like
select <fields> from dbo_ticket_responses where <date> between #Start Date# and #End Date#
Hope this helps
jrobertson's Avatar
Light Poster


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

Any suggestions?
rahulnaskar's Avatar, Join Date: Aug 2004
Go4Expert Member
Can you post the exact query you formed, in text and the table structure.
jrobertson's Avatar
Light Poster


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's Avatar, Join Date: Aug 2004
Go4Expert Member
jrobertson's Avatar
Light Poster
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's Avatar, Join Date: Aug 2004
Go4Expert Member
no probs dear
jrobertson's Avatar
Light Poster


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

Any ideas?
jrobertson's Avatar
Light Poster
I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


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