Search results for query: *

Hi I sure hope that someone can help me. I have a query that has the following fields: Date, Department Name, Code, Supply Type, Account#,Quantity Delivered, Price Per Item, (calculated)Total Price. These fields are for a end of month report for an inventory database. I need to be able...

I have 2 tables the first is the inventory table that contains the fields: Item# Description Price per Item Price per case Date Total used Total received Total in inventory par level and I will need a begining inventory field for a starting point on the totals that are in the inventory...

I am working on an inventory database. I am needing the values entered in one table to add or subtract from another field in another table. Example: Supplies are requested. The request is entered into the database. Need number of supplies taken out to be reflected in the total inventory...

I tried putting in between date()-60 and date()-30 and it did not pull the records that were 30 days past due. Did i do something wrong again?

I am building a past due billing query that pulls recorda that are 30, 60 or 90 days past due. The problem that I am having is the query for the 30 day is pulling all records for 30 days or more not for just the 30 day. The same for the 60. It pulls records for 60 and above. The criteria for...

I am creating a billing database and would like to be able to query the bill date to determin if the bill is past due 30 days. I have not been working with access long and need all the help that i can get. brandys