Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brandys

    Sum Total In a 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...
  2. brandys

    Adding & subtracting values in two diffrent tables

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

    Adding & subtracting values in two diffrent tables

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

    past due billing query

    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?
  5. brandys

    past due billing query

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

    query for past due billing

    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

Part and Inventory Search

Back
Top