Search results

  1. N

    Trying to create a running total

    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...
  2. N

    Transfer Spreadsheet to Existing Excel Worksheet

    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...
  3. N

    Need Query to display a Zero when no rows are present

    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...
Back
Top Bottom