Getting two fields into one

  • Thread starter Thread starter lucky33
  • Start date Start date
L

lucky33

I have a report that is trying to get a total damage rate for
employees as they load trucks. I have two fields setup. Loader 1 and
Loader 2. Each employee can be either Loader 1 or Loader 2 in the
truck.

On my report how can I pull the information combined in one row on the
report. I need the information from whether they were loader 1 or
loader 2. I can only figure out how to get the information if they are
loader 1 and it is not pulling the information if they are loader 2
 
I'm not sure I understand enough about how your data is organized or how
your report is "pulling" data to offer any specific suggestions...

A general suggestion is to use a query against the underlying data/table(s)
and base the report on the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a table with a form for entry. Field1 is Loader1 Field2 is
Loader2. I then run a report from a query that pulls the damage rate
for a specified employee for a given amount of time. Right now I
cannot figure out how to combine the two into one entry in the report
footer

I need the report to show the following

Information In table

Dan when loader 1 = 2
Dan when loader 2 = 4

Total For Dan =6
 
I pretty much need to take all of Dan's records when he was loader 1
and combine them with the records where Dan is loader 2 and make them
one field on a report?

Can this be done?

All help is greatly appreciated
 
I still don't have a very clear picture of your data structure, and
everything starts with the data in Access.

Another way to approach keeping information about who performed which role
(i.e., loader1, loader2, ???) is to use one field to hold the PersonID
(e.g., your "Dan"), and a second field to hold the "role" (e.g., "loader1",
"loader2", ...).

This way, you can do a simple query to find all loads Dan helped with, and
what his roles were.

If you HAVE to look in two separate fields, you could use a UNION query to
get all the "loader" data in one query, then use that query as your source
for your report.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Just create a text box on your report and in the Control Source type the
formula to include both fields, Like:

=[field1]+[field2]

good luck
 
Back
Top