Search:

I have another issue. I am trying to create a form based on three tables which are linked. However, I am only allowed to use one table as the Record Source. I tried using the wizard, but it did not...

I reproduced the OverseasVisit and Expenses tables and inserted the fields you mentioned. However, the records are still simultaneously updating.

As for the screenshot, I will be able to change...

This is the URL for the Screenshot:
...

I keyed in the expression again and it worked. Thanks a lot!

But, I still need assistance with the issue mentioned above.

The database contains the following tables:

tblExpenses

Employee Id
Expenses
Allocation Code/Work Order
Rate
OneTimeCost
Duration

That site is currently blocked. So I will send the link later this evening.
But, I am still having problems with the syntax of the expression. Like I mentioned earlier, the query is producing the...

I zipped it, but the file still exceeds the max file size. The compressed size of the file is 125KB.

Since the database I was working on is at work, I created a Sample Database with an Expenses...

I'm using the IIF statements as an expression for the Subtotal field.
I want the subtotal to include [Rate]*[Duration] as well as OneTimeCost where the former is not applicable

The file is 3.0...

I have not created any queries. Would I still be able to view a SQL statement?
The file is still not uploading.

I keyed in the first expression, but I'm getting the same result as before. There is no return for the false part.

The Subtotal field in my Expenses tbl contains the following expression:

IIf([Expenses]="Tuition/Fees" Or "Airfare" Or "Taxi" Or "Ground Transportation" Or "Registration Fee" Or "Miscellaneous" Or...