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 derfloh 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: *

  • Users: CathieF
  • Content: Threads
  • Order by date
  1. CathieF

    Criteria in Agregate Functions

    I have data that needs to be summarized for different time intervals after a particular date . I Created a query that calculates months post the particular date and includes all the data that needs to be summarized. I have a table for the particular time period names : 6 Weeks, 6 months, 1...
  2. CathieF

    filtering reports

    I have created reports that calculate various counts, averages and standard deviations of data. These reports do not have a specific record source. I need to filter this data based on criteria that is not directly related to the calculated fields. Is there a way to do this in general for the...
  3. CathieF

    Primary Keys

    I have a dozen or so tables all linked by a primary key of a patientID and SiteID. I have a table that requires more than one entry for the same patient. It won't let me add more data for that one patient. I am supposing this is becuase the primary key involves the patientID and cannot be...
  4. CathieF

    Selecting specific records when have more than one of each type

    I have a table of information about certain patients for various exams. I have a field that calculates Months postOperation. So There are various entries for different times post op for different patients ex. Automatic Record# patient months post op Other Data 1 1...

Part and Inventory Search

Back
Top