Complex Searches

D

Danielle Nelson

I have an access database that I need to search certain
fields and then perform calculations with the data. This
is a Customer ID field and I would need to search and
retrieve all entries for several customers and then
calculate the time spent for a group of customers. If I
use the criteria field in a query, is there a limit to the
number of values I can search at one time?

=(10078,12957,13428,14123,15000,16728,17478,18573...)

Can I look for an indefinite number?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
WORD VBA Search and switch to advanced ... 1
ASK Field Formatting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Page numbering with Merged Document and IF statements 1
Searching for Records in a Report 2
Lookup or search using the * character 1
iif exists - too complex? 0

Top