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 TouchToneTommy 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 bburch1

  1. bburch1

    Totals on Report Problem

    I'm trying to sum the Total Packed Field. The problem is that the query returns an ID, Date, Total Packed,Part Number, Defect, and Qty for every line. When the report tries to total the Total Packed field, it total every line. If I have five defects for one day, the Total Packed field will be...
  2. bburch1

    Totals on Report Problem

    I have a simple database for tracking defects. On a given date and part number, I may have 10 different defects. Below are the two tables I have. Header Table Detail Table ID ID Date Defect Type Part Number...
  3. bburch1

    Joining two queries

    Is it possible to perform a union query where two queries use the same date range as parameters?
  4. bburch1

    Duplicate Data in Query

    Thanks for the quick responses. To answer Sarah's questions, a)yes the ID in the header is unique and b)the ID in the detail is not unique. PHV, I'll try to add this to my query.
  5. bburch1

    Duplicate Data in Query

    I've put together a very simple database to collect defect information. It only has two tables that are linked together. The Header table is made up of ID, Motor No, Date, and Total Packed fields. The detail is made up of ID, defect, and Qty fields. They are linked by the ID fields. What...
See more

Part and Inventory Search

Back
Top