report based on autolookup query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Access 2003 and I have a report based on an autolookup query. Here's
what I need. I have the following tables: R&DCredit, ProductionEmployee,
ECR-PC., the report is based primarily on the R&DCreditTable and it looks up
the employee first name and department from the ProductionEmployee table
based on the last name in the R&DCreditTable, it then looks up in the ECR-PC
table the R&DCredit assigned based on the ECR-PC number placed in the
R&DCredit Table. Tt is looking them up based on all records in the R&DCredit
table. Now what is happening is that in the report I am sorting based on the
R&DCredit assigned and it is placing everything in one area (R&D for example)
everything is being placed under that heading in the report. Any
assistance would be helpful, I just seem to be drawing a blank on what is
wrong.

Leslie
 
Show us the query (SQL statement) that is the report's RecordSource. Tell us
what you're using in the Sorting & Grouping propery for the grouping. Show
us some sample records so that we can see how the data change from one
record to another (how would the grouping be occurring).
 
Back
Top