Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

verifying entries between tables in access

Jul 15, 2005 1:37AM PDT

So heres my problem, I am new to access and I know how to verify a perticular single field in access between one table and another. What would I need to do to verify nultiple fields for a single entry? For example I would need customer name, customer number and amount spent to all match then move on to the next. Both tables are not exactly formated the same. Is there an easy way to do this? Any help would be appreciated.

Discussion is locked

- Collapse -
Might I suggest...
Jul 15, 2005 1:57AM PDT

you look for some training on Access? I'm not that knowledgable about Access but i know it's a database program. You shouldn't have to compare one table to another. You enter your info (names, addresses, etc.) into one table & use that info in different ways like in reports & such.

- Collapse -
Thanks for your input but...
Jul 15, 2005 2:16AM PDT

What I have is two databases. One is from the Main headquarters tracking our satalite office. We want to make sure our Main office has all of our records recoded completely. Thats why I am taking their database and comparing it to ours... so there is no way for us to have just one table.... But thanks for your suggestion...

- Collapse -
I didn't realize it was between two different databases.
Jul 15, 2005 3:01AM PDT

In that case, I can't help you. Sorry about that.