Reporting Question

[WebGodiva]

I have a report i'm generating based off a query. In the report, I total personnel's hours and such. What the problem is that in the header of the report, i have four areas where i need to print four different personnel's names, city and state. I've created a field in my query which concetanates those fields into one field, I'd like to be able to get them to print on the report without having the end user type them in.


Basically, I have

Employees Expense Records for:

1. ______________ 2. _____________
3. ______________ 4. _____________

The detail is below this section with all of the expense information broken out by date range for all four employees.

I have the end-user typing in some data for the header which is just stuff that really doesn't need to be stored in the tables...mainly fluff for the managers so why waste database space.

I really need the four name fields to come in from the query. When i try now, i get all four fields filled in with one employee's name...

I know there is something probably so simple i just can't even think of it to make it move to the next record....i'm so brain fried right now that i can barely think of my own name....any help would be appreciated.



"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

 

[AlexCuse]

Is the other data for all 4 employees showing up on the same page? And is the expense info somehow grouped by employee or just showing the sum of the 4 columns?

 

[WebGodiva]

All of the other expense data is showing in the detail section for each employee, sorted by date and grouped by employee. No two employees will ever have expenses on the same date - it's just how they have the travel set-up.





"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

 

[AlexCuse]

obviously columns should = rows. Rough week...

 

[AlexCuse]

How is your data source defined for the fields where the different employee names are listed with expense info? By filling in your four fields on top the same way you should be able to get the four names to show up

 

[WebGodiva]

sorry for the delay - had to stop beating my head into the desk.

The data for the fields comes from a lookup - i have created a query where that information is joined with the city, state and it runs great. i need to take that data and then put it in the report but only for the people that are showing on the specific page that their records are on. The joined field is in the same query as all of the expense data.







"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

 

[AlexCuse]

I think that you may be able to fill in the fields so they grab names from lower on the report where expense data is shown. Not 100% sure though. Have you considered making the data source for those fields a second query with the same joins as your lookup query, and assigning an auto-number 1-4 to each name/city/st and then having the report grab from these query results where autonumber=1 for position 1 etc...?