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 Westi 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: tx333
  • Order by date
  1. tx333

    Use criteria to filter only select records within a field

    The debugging issue makes sense, I'll go that route. Thanks again for all your help and rapid response. Trey
  2. tx333

    Use criteria to filter only select records within a field

    Right now, the query I built has all the records, and I set the criteria to include only records with New_Money > 0, which is right for 2 of my Prod_Cat types, but excludes other Prod_Cat types that can have 0 in New_Money. I don't want to exclude all of any one Prod_Cat. I thought about...
  3. tx333

    Use criteria to filter only select records within a field

    I don't think that is quite what I'm looking for, I'm not using a form and the filters will not change over time. As I update the source table in the future, I plan to use the same criteria to eliminate the same record combinations. For example: I want all instances of Prod_Cat:1 regardless...
  4. tx333

    Products with Zero Items Sold Not Showing In Report

    Bob, Your SQL works beautifully and now I can switch to design view and the Nz function makes sense as well. Thanks a lot. Trey
  5. tx333

    Use criteria to filter only select records within a field

    I have a table with the following fields and data: Prod_Cat: 1, 2, 3...10 New_Money: 0 through 999 I would like to create a query that excludes records when Prod_Cat = 6 and New_Money is not greater than 0 and Prod_Cat = 9 and New_Money is nor greater than 0. Is there a way to assign...
  6. tx333

    Products with Zero Items Sold Not Showing In Report

    Bob, Here are the specifics Table1: Goals Fields: Branch Text 5, ProductID Text 5, Goal Long Integer Table2: Sales Fields: Branch Text 5, ProductID Text 5, Sales Long Integer The Goals table has a record for each of about 20 ProductIDs and 25 branches (500 total records). The Sales table...

Part and Inventory Search

Back
Top