Query to work out which rate should be inserted

  • Thread starter Thread starter Leanne
  • Start date Start date
L

Leanne

Im not sure if this is the right way to go about this but I would like a way
to get the computer to automatically input the correct rate.

I have 3 tables, 1 has invoice details (invoice, job number, hours charged,
type, customer) 2nd has Engineer details (job date, job number, time paid,
pay rate, engineer name) and my last have customer rates (customer, callout
rate, job rate)

my job number and customer fields have lookup relationships

I would like a query to display
Invoice, Job number, hours charged, type, customer and a new field Rate

For the rate heading i need the query to look at what customer is selected
and what job type is selected in order to display the correct rate

is this possible?
 
Your [customer rates] table does not include job type so as to select the
correct rate.
 
You would create your query and add both tables Invoice Details and Customer
Rates. You would add all fields from Invoice Details and the rate field from
Customer Rates. Since you say your tables are linked by job number and
customer, I assume they hold equal information. However, when you link two
tables by a common field, you really should keep the same name from table to
table to make it less confusing.
--
Miranda


KARL DEWEY said:
Your [customer rates] table does not include job type so as to select the
correct rate.

--
Build a little, test a little.


Leanne said:
Im not sure if this is the right way to go about this but I would like a way
to get the computer to automatically input the correct rate.

I have 3 tables, 1 has invoice details (invoice, job number, hours charged,
type, customer) 2nd has Engineer details (job date, job number, time paid,
pay rate, engineer name) and my last have customer rates (customer, callout
rate, job rate)

my job number and customer fields have lookup relationships

I would like a query to display
Invoice, Job number, hours charged, type, customer and a new field Rate

For the rate heading i need the query to look at what customer is selected
and what job type is selected in order to display the correct rate

is this possible?
Click to expand...
Click to expand...
 
Back
Top