query join problem?

[allie357]

The main table is called tblcommInfo and it does have a primary key
called comminfo_pk. It contains a great deal of commodity data. (Many
of the fields are listed below.)
The buyer table is tblBuyers and it has a pk called buyerid.

The main query I need to work with is limits the data to targeted
commodities and I need to add up all of the central buyer spend which
means anyone listed in the buyer table.

The main query has these fields.
RC Name
Dept Name
Commodity
Commodity Type
Vendor Name
CV
Amount
Lowest Savings Estimate
Highest Savings Estimate
FY Quarter
Accounting Date
PO Number
Buyer
Category
Invoice Number
My main problem is the way the transaction data is brought into the
database. there are rows that are missing a buyer name but they should
be associated with the buyer listed because the date and invoice
number match. How do I add these up so that each transaction lists a
buyer name?

 

[Jerry Whittle]

If you can find the buyer name in another record having the same invoice
number and date, I'd be tempted to first run an update query to populate the
records with the right data. Nothing like clean data to return good
information.

This wouldn't be an easy query. Provide us with the table and field names
and a sample of the data showing the problem.

 

[Jerry Whittle]

If you can find the buyer name in another record having the same invoice
number and date, I'd be tempted to first run an update query to populate the
records with the right data. Nothing like clean data to return good
information.

This wouldn't be an easy query. Provide us with the table and field names
and a sample of the data showing the problem.

Sorry if this is a duplicate post but the first one didn't seem to go through.