Total Records in Table

N

Nylex

I have a table named "RetailM" which is created by an accounting programme
and imported into my Database
It is continually changed in volume and I need to update the latest cost in
to the database tables
The "Products" table has a filed named "Barcode" and "Cost" and so does
RetailM
They are not linked as one table is always altered - the only field they
have in common is the "Barcode" and "Description"
I need to find how many records are in "RetailM" and then check each record
from 1 to ??? and copy the "RetailM Cost" to "Products Cost"
Any help would be appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Creating Summary Reports from Two Tables 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query Error 2
Is this possible? 0
Adding a barcode to a new Record 4
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Summing Multiple Records asigned to one ID 3

Top