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!

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

Recent content by asmith6

  1. asmith6

    Calculating Number in Department

    Hello All, Sorry, this is probably quite a novice question but I just can't figure it out. I work in an emergency department of a hospital and we are trying to write a report to pull back the number of patients in the department at the top of each hour i.e. a snapshot at 13:00:00, 14:00:00...
  2. asmith6

    Simple Query

    Hi, I know there is probably a simple solution to this but i cant seem to find it and now my deadline is running out!! I am trying to add quarterly data to a yearly total table, so for instance i have for the year 2002, 4 seperate tables with the data in for each quarter, how can i add all the...
  3. asmith6

    Find Duplicates Query

    Hi, Yes I already read through that one, however theres a couple of problems, I'm building these queries for someone with a limited knowledge of Access who simply wants a number of queries to run to get the answers, I guess I could maybe run a macro to do this part??? The other problem is I...
  4. asmith6

    Find Duplicates Query

    Hello, I've set up a find duplicates using the wizard without any problems, however now I need to flag the duplicated records in the main table, I've tried a number of ways to do this but I can't seem to get any to work, I'm quite new to Access and was wondering if anyone could help me?? Cheers

Part and Inventory Search

Back
Top