How would I do this (without transforming data)?

[andydtaylor]

Hi,

I'm trying to perform a match on a customer name.

* This can appear in a number of fields - registered name, delivery address, payment details etc.
* This can appear in a number of files (system migrations/ customer data in >1 system table)

The issue I have is I realise that what I really want to see is a a simple summary table, with fields such as:

Table name
Match row (ID)
Match field**
Match criteria**
Account number primary
Account number secondary
Account number other

Is there a nice way for me to return a table of this type?

** I'm looking at this thinking I need to capture query parameters. is this right, and is there a feasible way for me to do this? regarding match criteria, I'm always looking for one string (with optional wildcard)

Thanks,

Andy

 

[ranman256]

make a report table to store the results.
in a macro, put in the queries to do this,
query to add data to the Primary Acct
query to add data to the Second Acct
etc
until last query to sum the results of the report table into a single record.

 

[andydtaylor]

I discovered that I can use parameters in Access JET SQL to do this