Recent content by Nphp0729

I took a look at that thread. He is not looking to achieve the same results. He is looking for a count where I am looking for a total. I need my to seperate it by group but also sum the previous qty with the new qty.

I am trying to create a query that will give me a running total by product grouping and serial number. I currently have these three fields Products, Serial Number and Order Quantity. I've played with IIf and DSum but don't get what I am looking for. This is what I get. Products Serial...

I used a converted Macro and made an adjustment to the code so the Access Table would go to an Existing Worksheet. It runs and works fine once or twice and then I receive an error stating: The Microsoft Jet Database Engine could not find the database ''. Make sure the object exists and you spell...

I tried the above sql code but I still receive no results. I don't know if I'm being clear. My query is set up to always return one row of information. I need the count of the products with the above set criteria. If there is no items that meet this criteria I don't receive any information. I...

I've played with your suggestion but still don't get the desired result. I'm sure I'm doing something wrong. Here is the SQL of the Query as it is now. I need it to display a zero in the COUNT([Product List].Product) Field because when the result of the count =0 I don't receive any information...

I am a beginner to Access and learning more and more as I try. I have a query which gives me a count of Products but I need it to display a zero when there is no data giving me no rows. The query I have set up goes something like this. Name--------------Product--------Brand--------Due...