General discussion

Locked

Access

By olufunsho.ayo ·
Please HELP!!!...I am tryin to automate a cumbersome process I do on Access. What I do is that I run a query from two different tables. i then export these queries to an excel worksheet. i sort both queries by the "customer name" field. I then compare the "contract ID "field in one worksheet(query) with the "overall ID" field in the second worksheet (query). then I generate a third worksheet from these comparisons. this new worksheet contains all the "customer ID" for the first query that does not match any of the "overall ID" from the second worksheet

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Access

skip excel, do it all in access. then output to excel if you must to print report.
think of your queries as tables, yes?
you are saying these tables are related by customer name? or is overallid the unique customer identifier?
anyhow, try query new make query wizard find unmatched records.
did you look at changing yuor queiers to 'make table' querys if you find you can't nest the queirs like i think you can...

Collapse -

by olufunsho.ayo In reply to

Poster rated this answer.

Collapse -

by olufunsho.ayo In reply to Access

I am saying the two queries are related via the
"contract Id". however it called "contract id" on one query and called "overall contract id" on the other query. These 2 queries are from 2 different tables!.
Thanks

Collapse -

by PCPapa In reply to Access

This can all be done in VBA. There's no reason to generate the 1st 2 spreadsheets unless you need them for some reason. Instead use two recordsets. You can use the contract ID as your lookup and check for it in the other recordset using the FindFirst or Seek function. Then use the NoMatch property to generate a new table containing the info for those found without matches. Then you can generate a spreadsheet from the new table. Let me know if you need more details.

Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums