Recent content by mattfox

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

I checked in the owner's manual and on the OkiData website and I did not find any instruction on how to "Burn info into the ROM" setting.

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

Nevermind about my last post. It works. The problem is that now with the switch statement after 1250 is taken out of the guy's pay it shows 1250 in that field for the next records. So in my YTD field 1250 is subtracted from the gross instead of nothing. How can I make it show 0?

The switch expression worked, but now my problem is getting Escrow total to work. I get that "#Name" when I use - IIf([Escrow]*12>1250,1250,[Escrow]*12).

Neither of those work. I get "#Name" in the field.

This doesn't work. You have to have a true and a false after the expression in an IIf statement.

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

SELECT DISTINCTROW Customer1.[Customer Name], Customer1.Contact, Customer1.[Item #], Customer1.[Item Description], Inventory1.[Qty Rec], Inventory1.[Qty Shipped], [Inventory1].[Total Qty Rec]-[Inventory1].[Total Qty Shipped] AS [Total Floor Qty], Sum([Inventory1].[Qty Shipped]) AS [Total Qty...

The query figures all of the totals.

Well, I did that and it still gives me the same error.

Okay, this change created another problem. I added my calculations into the query. Now remember that I have two tables setup. The error I now get is: You tried to execute a query that doesn't include the specified expresion "Customer Name" as a part of an aggregate function. Now...

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

I have ten different macros setup, so I cannot have set the form's record source directly to the query.&nbsp;&nbsp;I changed the OutputAllFields property set to Yes snd I got the same result..<br><br><br>

A macro is called, which opens a form after the the prompt.&nbsp;&nbsp;The filter name of the macro is a query which displays a table name (them a period) and the field from a table which I am prompting for data in the second display.&nbsp;&nbsp;The second one is intentional, the first just pops...