Search results

You are seeing an ugly slice of what is otherwise a well normalized database. The email addresses are no doubt being handled poorly. Ideally they should be in a separate table. It may come to that but it's not yet clear whether this data, which is part of a standalone application we...

Hello, An affiliate sent us a table of email addresses, one per record. We need to find which ones already exist in our master table. Our master table contains an email field but it may contain MULTIPLE email addresses separated by semicolons. How do we create a query (or queries) which tell...

Thanks. I have some questions on using this approach. 1. How do we point the the report to use the LOCAL query as its underlying record source? I ask that with the assumption there will be just ONE version of the report that is located on the SERVER mbd only (otherwise we couldn't modify the...

Hello, I was not sure where best to post this. We have an Access MDB on a single-user workstation and use a VB6 front end to run a report. The database has 200,000+ records which are searched by license plate number. We need to move the MDB to the network so that several users can run the...