Need query to fill in missing data on table

[fgbdrum]

Hi there-

I am using Access 2003. Here's what my table looks like:


Name ID Company Cost
John Smith 1234 Phil's Towing $84
John Smith $94
John Smith $104
John Smith $151


Presumably, I need a make table query that will fill in the ID and Company
data in each row to make it look like this:

Name ID Company Cost
John Smith 1234 Phil's Towing $84
John Smith 1234 Phil's Towing $94
John Smith 1234 Phil's Towing $104
John Smith 1234 Phil's Towing $151

Any help is appreciated. Thanks.

 

[Jeff Boyce]

Check Access HELP for more information about queries.

A "make table" query creates a new table. An "update" query updates values
in an existing table.

Before creating/running a query that changes values, be sure you've made a
backup of the file!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.