Normalizing excel data import

[BFish via AccessMonster.com]

Hopefully someone can lead me in the right direction. I am importing an
excel spread sheet with the data below along with addtional dollar fields.
Ultimately appending to a invoice table once normalized. My issue is when
grouping I need to update the source field. If an InvNo has a Source of 111
then all records with that particular InvNo need to have the Source updated
to 111, so that the invoices can be grouped together along with totaling the
not showed Invoice dollar total and then appended to the Invoice table.
Example would be Invoice 297171 should all be 111. This spread sheet is of
course listing every line of the invoice and there is no other way refine the
excel sheet.


InvNo Source
297159 100
297159 100
297161 100
297166 100
297166 100
297170 100
297171 100
297171 111
297173 100
297173 100
297173 100
297173 111
297178 111
CM296095 100
CM296095 111
CM296894 100

My problem is writing an updatable query while still using criteria to select
these specific records. Any help would be appreciated.

Bill

 

[Ken Snell MVP]

Use the Group By query as the source for a make-table query; write the
results into a new table. Then use the new table in your update query as the
source of the new values.

 

[BFish via AccessMonster.com]

Use the Group By query as the source for a make-table query; write the
results into a new table. Then use the new table in your update query as the
source of the new values.

Doh! Of course. Something comes to mind. Trees, forest and lack of sight.

Many thanks Ken.

Bill