Search results

Your function runs fine in my Access 2000 database. What error did you encounter?

In view of the falling of prices, I wonder if one of these days the default A: drive of a computer will be a zip drive instead of a floppy drive.

The answer is Yes. The following example shows the criteria for 3 fields (i.e. 3 combo boxes):- SELECT [Field1], [Field2], [Field3], [Other Fields] FROM [TableName] WHERE ([Field1]=[Forms]![FormName]![combo1] Or [Forms]![FormName]![combo1] is null) And ([Field2]=[Forms]![FormName]![combo2]...

I have a club membership table tblMember containing a JoinDate field and an Active field (a Yes/No field indicating each member's current status) along with some other fields. I have set the above [Enter start date] [Enter end date] criteria for the JoinDate field in a query and it runs fine...

I don't think we can pull the original records from a totals query.

Thank you for the clear explanation. Now I know when an IIF criteria should be placed in the Field row with <>False in the Criteria row. Thanks again.

Very interesting solution, but I just don't understand. Why should the criteria be placed in the Field row instead of the Criteria row? What do the True in the IIF expression and the <>False in the Criteria row do?

EMP I registered to become a member in these forums just to say THANK YOU! The solution you posted has helped me solve an interest rate lookup problem in our office. The interest rate table contains real time interest rates that frequently change. It never occurred to me I could use DLookup...