Search results

  1. A

    Null Values in query

    I need to create a query with the MTD field I have created the MTD and it works!!! but now I need it to show all of the PartNum fields even if null. do I need to convert all nulls to zeros? if so how do I go about this? Here are the fields in the query First Field: Field: PartNum Table: Part...
  2. A

    Calculating MTD and YTD Sales for report

    I have been stuck on this one for a while. I have an Access 2003 Database that I need to calculate the MTD sales and the YTD sales of parts ordered Here are the relevant tables and thier attributes Part - PartNum Description UnitPrice OnHand ReorderPoint Orders - OrderNum...
Back
Top Bottom