Search results

I understand relationships and joining tables in my query, however this is not the problem.

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

Don't worry about it anymore. I figured it out!

Actually... This has one little flaw here is the objective: For each part, I need to list the following in a report PartNum description UnitPrice MTD Sales YTD Sales InStock Allocated ReorderPoint I need to group the PartNum field so it only shows each individual part. then adds the total...

Copy of Database for help with Part cost total for YTD and MTD Hopefully this worked...

How do I post it?

Sorry I tried the first suggestion and I got a column with the years listed the second suggestion I got a column with "-1" I need to have the field post the sum of the cost of all parts ordered in the current year and another query with the sum of the cost of all parts ordered for the current...

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