1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

getting date out of a table, from a query

Discussion in 'MS Access' started by jrobertson, Oct 30, 2006.

  1. jrobertson

    jrobertson New Member

    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!
     
  2. rahulnaskar

    rahulnaskar New Member

    your query should go like
    select <fields> from dbo_ticket_responses where <date> between #Start Date# and #End Date#
    Hope this helps
     
  3. jrobertson

    jrobertson New Member

    [​IMG]

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

    Any suggestions?
     
  4. rahulnaskar

    rahulnaskar New Member

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

    jrobertson New Member

    [​IMG]

    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! :)
     
  6. rahulnaskar

    rahulnaskar New Member

  7. jrobertson

    jrobertson New Member

    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.
     
  8. rahulnaskar

    rahulnaskar New Member

    no probs dear
     
  9. jrobertson

    jrobertson New Member

    [​IMG]

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

    Any ideas?
     
  10. jrobertson

    jrobertson New Member

    I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


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

Share This Page