Lookup query

[Christopherusly]

Ok here is my problem, i have a table which contains a list of staff, the charge out rate and then team role (this is either leader, member or observer)

This table is interogated by three queries to identify the leaders, members and observers, which are used as lookup sources for my report table; what i want to be able to do is when i assign the audit leader, member and or observer and then for the query to pick up the row source and then enter the charge out rate for that person, in the current record.

I am stumped does any one have any recommendations / suggestions.

Many thanks

 

[FoFa]

If I understand, you have this lookup table, can't you just join the lookup table in your query and then select the fields you want? That is typically how it is done. Or maybe I am not understanding the problem.

 

[Christopherusly]

If I understand, you have this lookup table, can't you just join the lookup table in your query and then select the fields you want? That is typically how it is done. Or maybe I am not understanding the problem.

each record is for a report, each report typically involves two people, the team leader and the team member.

I have a table containing the staff involved inthe reporting process, other information included is their charge out rate and roles.

Staff list (table) ---- Leader (Query)
---- Member (Query)
---- Observer (Query

When creating a new report record, the team leader and member are selected using a query as the record source, so for audit leader, you select from the audit leader query and so on ...

What i want to be able to do is put together a query which wil see that John Doe was selected as the audit leader, then find his charge out rate, multiply that by the number of hours he worked, so the report costings can be monitored

I do nto know how to make the query select the charge our rate based on the Audit leader / member / obsever selected.

I hope this is clearer ?

 

[FoFa]

OK, what table (and fields) is the query/ies based on?
I am assuming you have another table it is based on, and you are trying to pull the data for each from the staff table, correct?