Fields not showing on Report

  • Thread starter Thread starter dstremmet
  • Start date Start date
D

dstremmet

I have a report based on a query. When I add the fields to the report, some
of my fields don't produce data.????
 
Post the SQL of the query.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Is the query returning the data?
If the query returns the data, make sure your report control is bound to the
right column.
What type of data is this (text, number,date etc.)?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
SELECT DISTINCTROW TIMEKEEPING.EMPLOYEENumber, Employees.FirstName,
Employees.LastName, TRADES.Trade, Employees.Salary, Employees.Agency,
Employees.HourlySalary,
IIf([agency]="afs",1.38,IIf([agency]="iss",1.365,IIf([agency]="TSI",1.37,0)))
AS Markup, [salary]*[markup] AS SalaryMarkup,
IIf([agency]="afs",[sumofreghrs]*[salarymarkup],IIf([agency]="iss",[sumofreghrs]*[salarymarkup],IIf([agency]="tsi",[sumofreghrs]*[salarymarkup],IIf([agency]="qc"
And [hourlysalary]="s",[salary]*520,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofreghrs],0))))) AS RegCost,
IIf([agency]="afs",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="iss",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="tsi",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="qc"
And [hourlysalary]="s",0,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofothrs]*1.5,0))))) AS OtCost,
[regcost]/[sumofreghrs] AS AudManhrRegRate, [otcost]/[sumofothrs] AS
AudManhrOtRate, Sum(TIMEKEEPING.reghrs) AS sumreghrs, Sum(TIMEKEEPING.othrs)
AS sumothrs
FROM (Employees LEFT JOIN TIMEKEEPING ON
Employees.EmployeeNumber=TIMEKEEPING.EMPLOYEENumber) INNER JOIN TRADES ON
Employees.Trade=TRADES.[AUTOTRADE#]
GROUP BY TIMEKEEPING.EMPLOYEENumber, Employees.FirstName,
Employees.LastName, TRADES.Trade, Employees.Salary, Employees.Agency,
Employees.HourlySalary,
IIf([agency]="afs",1.38,IIf([agency]="iss",1.365,IIf([agency]="TSI",1.37,0))),
[salary]*[markup],
IIf([agency]="afs",[sumofreghrs]*[salarymarkup],IIf([agency]="iss",[sumofreghrs]*[salarymarkup],IIf([agency]="tsi",[sumofreghrs]*[salarymarkup],IIf([agency]="qc"
And [hourlysalary]="s",[salary]*520,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofreghrs],0))))),
IIf([agency]="afs",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="iss",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="tsi",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="qc"
And [hourlysalary]="s",0,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofothrs]*1.5,0))))), [regcost]/[sumofreghrs],
[otcost]/[sumofothrs], TIMEKEEPING.REGHRS, TIMEKEEPING.OTHRS;
 
Yes they do.
--
dks


J_Goddard via AccessMonster.com said:
Hi -

Run the query on its own, outside of the report. Do the fields have the
required data when you do?

John



--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com


.
Click to expand...
 
SELECT DISTINCTROW TIMEKEEPING.EMPLOYEENumber, Employees.FirstName,
Employees.LastName, TRADES.Trade, Employees.Salary, Employees.Agency,
Employees.HourlySalary,
IIf([agency]="afs",1.38,IIf([agency]="iss",1.365,IIf([agency]="TSI",1.37,0)))
AS Markup, [salary]*[markup] AS SalaryMarkup,
IIf([agency]="afs",[sumofreghrs]*[salarymarkup],IIf([agency]="iss",[sumofreghrs]*[salarymarkup],IIf([agency]="tsi",[sumofreghrs]*[salarymarkup],IIf([agency]="qc"
And [hourlysalary]="s",[salary]*520,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofreghrs],0))))) AS RegCost,
IIf([agency]="afs",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="iss",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="tsi",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="qc"
And [hourlysalary]="s",0,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofothrs]*1.5,0))))) AS OtCost,
[regcost]/[sumofreghrs] AS AudManhrRegRate, [otcost]/[sumofothrs] AS
AudManhrOtRate, Sum(TIMEKEEPING.reghrs) AS sumreghrs, Sum(TIMEKEEPING.othrs)
AS sumothrs
FROM (Employees LEFT JOIN TIMEKEEPING ON
Employees.EmployeeNumber=TIMEKEEPING.EMPLOYEENumber) INNER JOIN TRADES ON
Employees.Trade=TRADES.[AUTOTRADE#]
GROUP BY TIMEKEEPING.EMPLOYEENumber, Employees.FirstName,
Employees.LastName, TRADES.Trade, Employees.Salary, Employees.Agency,
Employees.HourlySalary,
IIf([agency]="afs",1.38,IIf([agency]="iss",1.365,IIf([agency]="TSI",1.37,0))),
[salary]*[markup],
IIf([agency]="afs",[sumofreghrs]*[salarymarkup],IIf([agency]="iss",[sumofreghrs]*[salarymarkup],IIf([agency]="tsi",[sumofreghrs]*[salarymarkup],IIf([agency]="qc"
And [hourlysalary]="s",[salary]*520,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofreghrs],0))))),
IIf([agency]="afs",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="iss",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="tsi",[sumofothrs]*[salarymarkup]*1.5,IIf([agency]="qc"
And [hourlysalary]="s",0,IIf([agency]="qc" And
[hourlysalary]="h",[salary]*[sumofothrs]*1.5,0))))), [regcost]/[sumofreghrs],
[otcost]/[sumofothrs], TIMEKEEPING.REGHRS, TIMEKEEPING.OTHRS;
 
Which fields aren't showing up?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top