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 bkrike 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: *

  • Users: mattfox
  • Content: Threads
  • Order by date
  1. mattfox

    Date formula problem

    This is a formula that I created to calculate a date. The problem that I have now is that I do not want this formula to output a date that falls on Saturday or Sunday. Can anyone help? =IIf(((IsNull([Forms]![Imports2]![Pick-up Date])) And ((Date()-[Forms]![Imports2]![Date...
  2. mattfox

    Printing Labels in Access 97

    I setup a query with the info that I wanted on the label. I then went through the labels wizard under reports and set all of that up. Once that was done I went into the printer settings (its a dot matrix) and set the custom paper size to the size of the label in windows and in access. I don't...
  3. mattfox

    IIf Statement problem.

    I am using Access 97 to create a payroll program for our contractors. The problem that I am having is calculating escrow. This is how it works - If the gross is less than or equal to $500 then $50 gets subtracted otherwise gross*0.1. The max amount subtracted for a year is $1250. These are...
  4. mattfox

    A Report Question

    I created a inventory database and I have a total inventory report that shows everything that we have in stock. The way I have it setup is one table with the customer information and item descriptions and a second table with the recieved and shipped data. In the total inventory report I show...
  5. mattfox

    Field Name problem in a query.

    I have two tables setup and in my query I have one field from one table and the rest from the other.&nbsp;&nbsp;I have the relationship setup between the two tables.&nbsp;&nbsp;In the query I prompt for an entry for a field name.&nbsp;&nbsp;When I run it I get this:<br><br>First prompt - table...
  6. mattfox

    Record locked by another user.

    I have database installed and running on one computer with eight other computers accessing it and running it.&nbsp;&nbsp;I have the database setup to allow shared access, but I do not have users setup on it.&nbsp;&nbsp;I get the message stated above in my subject every once in a while on their...
  7. mattfox

    Query Headache

    I am in the process of creating an inventory database.&nbsp;&nbsp;The kicker is that certain things get a certain amount of free time before storage charges begin.&nbsp;&nbsp;I put this expression in the query to show the number of days we have had the item: # of Days...

Part and Inventory Search

Back
Top