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!
your query should go like select <fields> from dbo_ticket_responses where <date> between #Start Date# and #End Date# Hope this helps
That's what I was told by someone else to put in, yet I'm getting an invalid bracket error. Any suggestions?
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!
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.
It prompts me for the date now, and it comes back with that error once I specify a date range. Any ideas?
I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! A fellow on utteraccess helped me.. I GOT IT!! Thanks for the help though