Search results for query: *

I have built a database that holds information on different wells. I have all the wells with their information in one table and another table holds each sampling event for the wells. (The sampling is donequarterly but over a three week span. Each well record is linked to many records...

Thank you Terry, the IIf statement worked great. It solved my problems. I appreciate your help. Tamara

I am wondering if it is possible to use a If..The.. Else statement in a query to retrieve a calculated field number. I keep getting the error "The expression you have entered contains invalid syntax" " You may have entered an operand without an operator" whenever I try to run...

I have a query that I generated for a report. When I go to print the report I would like a box to come up that I can request several records from the same field. I have built a Laboratory database that holds sample information that is tied to a Chain of custody number. I would like to be able...

Thanks KF for the reply. I wasn't very explicit in my first request. I am actually trying to get the query to make a pop up box that I can type in up to five customer numbers in. I have done this a long time ago, but for the life of me can't remember how.

I am trying to get a query to allow me to type in multiple selections of data for one field when I run it. Any ideas? Eg. to select multiple customers by number to see what they have purchased.