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 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 dbourdea

  1. dbourdea

    can you use the content of a single record as criteria for a query

    I need to know if it is possible to use the content of a single record in a table as the criteria for a query. Here's what I got. The database is a reporting database for an older version of remedy. The reporting database is an Access 2000 database. The table containing the data for the...
  2. dbourdea

    Stacking Querys returns all subquerys as null if one is null

    Kyle, Here are those sql statments for the query's: 1. IMAC Query PARAMETERS [Forms]![frmPrintStatisticalReports]![txtFrom] DateTime, [Forms]![frmPrintStatisticalReports]![txtTo] DateTime; SELECT Count([tbl_Make-APL_Service_Request].Status) AS IMAC FROM [tbl_Make-APL_Service_Request] WHERE...
  3. dbourdea

    Stacking Querys returns all subquerys as null if one is null

    I have an Access reporting database that pulls all of its data from a Remedy database. This part works fine. I create 2 tables. The first is a problem managment table, the second is a service request table (moves, adds, changes). In the Problem Management table we have 5 distinct product types...
  4. dbourdea

    Relating forms

    Gary, Would like to see those examples as well. david.bourdeau@bourdeauent.com
  5. dbourdea

    Counting different objects in the same field

    Jerry, Can you give an example of the "grouping" statement?
  6. dbourdea

    Counting fields for Multiple Occurrences of the same information

    I have a maintenance database that has several related tables (Serial Number, Model Number, Technician Name,etc)and a "data" table to store the maintenance data on equipment. Equipment is identified by its Serial via a lookup to the Serial number table. RMA number, sent and recieved...
See more

Part and Inventory Search

Back
Top