Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bmcguirk

    Access Date Issues?

    It works! Everyone had a hand in the solution. The queries over on the ANSI thread just needed #'s around the date. Thanks to everyone who helped. --B
  2. bmcguirk

    Select Problem

    karluk, Don't know if you're still reading this thread, but all of the SQL that you threw at me works. I just got the thing up and running today. Access just needed some #'s around the date I was giving it so see it as a date instead of some long division. Thanks for all of your help! --B
  3. bmcguirk

    Access Date Issues?

    Rick-- I was thinking along your lines too. The database I described on the ANSI thread is actually just a simple model of a database that I'm working on. The problem is I can't get SQL work on this model with 4 records in it! I don't know if Access let's you do the >< operations on a...
  4. bmcguirk

    Access Date Issues?

    Is there anyone out there who can address the issue in the following thread on the ANSI SQL board: http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/220/qid/67598 Is there an issue with Access 97 dates that I am not addressing with my SQL statement? Any other ideas? Thanks! --Brian
  5. bmcguirk

    Select Problem

    karluk, I agree that both solutions look good, I can't for the life of me find my mistake. I'll paste my data and the query that is returning no results. First the data: Patients PatientID LName 5 Joe 6 Steve Visits VisitID PatientID VisitDate 7 5 2/10/1998 8 5...
  6. bmcguirk

    Select Problem

    To be more specific I think I need a statement that performs three steps: 1. Select the PatientNumber and the most recent VisitDate for that PatientNumber from Visits. 2. Select PatientNumber from step 1's results where the most recent VisitDate before 12/31/98 3. Get the PatientName from...
  7. bmcguirk

    Select Problem

    Thanks for both responses, but they both yielded the same result which was to not return any rows. I feel like both of these statements were very close, but one condition is missing. Any other thoughts?
  8. bmcguirk

    Select Problem

    I have two tables that simplified would look like this tblPatients PatientNumber PatientName tblVisits VisitNumber PatientNumber VisitDate I need to do a select that will take the PatientNumber and Name from Patients if they haven't visited since 12/31/98. For...

Part and Inventory Search

Back
Top