1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access Database

Discussion in 'Business Applications' started by computerman29642, Sep 18, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Is there a way in an access database to not display data that is older than the data that is being entered?

    For example, I have a database that keeps track of when users become certified. I do not want to get rid of the old information, but I do not want to display the old data on the form.
     
  2. Sponsor

  3. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Need a bit more info on how the db is structured to help. Can you zip and post a dummy file with some fake data in it? (Unlike OBP, I can't just analyze the structure!!!) :)
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,521
    Sorry to tread on your toes Slurpee, but this can easily be achieved by using a Query to supply the form with it's data and use the Current Date as a Criteria Row Filter.
     
  5. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    LOL! Any correction from you OBP, is worth hearing!
    However, computerman says "I have a database that keeps track of when users become certified. I do not want to get rid of the old information, but I do not want to display the old data" - but that wouldn't necessarily be today's date, would it?
    That's why I wanted to see more clearly what he wants - just before today or the most recent date....
     
  6. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I want the item with the most current data to display.
     
  7. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Would a criteria of Maximum show the most recent date?
     
  8. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,521
    Yes it would and you are right, I wrongly interpreted Old as meaning anything older than Current. :eek:
     
  9. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Well, once you hit our age.... ;)
     
  10. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I will test that now. Thanks Slurpee. :)
     
  11. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    When I type the word Maximum in the criteria of the date field of the query, it places quotes around the word maximum. I then get a mismatch error.
     
  12. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,521
    You do not do it using the Criteria, you use "Totals" and Grouping, for the Date you would enter Maximum instead of Group.
     
  13. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Would this be done within the query or the form itself?
     
  14. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,521
    The Query, in design veiw Main Menu>View>Totals
     
  15. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,521
    You might want to use 2 queries, the first to limit the dates and the second, based on that query and the table to provide the rest of the data.
     
  16. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I may have to do that. Now, when I open the form, I get "#Name?" in the date fields.
     
  17. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/751070