Help with Select Joins

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

Guest

I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
 
I have a report where I would like list various fields from two tables.
Your query only select one field from one table.
Why do you need to join these two tables?
 
Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


visidro said:
I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
Click to expand...
Click to expand...
 
I recommend you create a query and base the report on it.
Seems to me using FirstName and [assistant's names] is poor as some will put
nickname instead of true name. What happens if you have two employees with
the same name? I would use EmployeeID in both cases.
I would use a left join from employees to timesheet as you will always have
employee but may not have a timesheet for them.
--
KARL DEWEY
Build a little - Test a little


visidro said:
Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
I have a report where I would like list various fields from two tables.
Click to expand...
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


visidro said:
I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
Click to expand...
Click to expand...
Click to expand...
 
Thanks Karl I'll try that.

KARL DEWEY said:
I recommend you create a query and base the report on it.
Seems to me using FirstName and [assistant's names] is poor as some will put
nickname instead of true name. What happens if you have two employees with
the same name? I would use EmployeeID in both cases.
I would use a left join from employees to timesheet as you will always have
employee but may not have a timesheet for them.
--
KARL DEWEY
Build a little - Test a little


visidro said:
Thanks for answering Karl.

I need to create a report that shows Billing Rate, Time start, Time Finish
and amount; the start time and the Finish time reside on the work time sheet
table; the billing rate resides on the employee table the amount is
calculated from these fields.
What should be the row source or control source on the billingrate field?

thanks again.

KARL DEWEY said:
I have a report where I would like list various fields from two tables.
Your query only select one field from one table.
Why do you need to join these two tables?

--
KARL DEWEY
Build a little - Test a little


:

I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:

SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];

I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?

thank you
victor
Click to expand...
Click to expand...
Click to expand...
 
Back
Top