Subreport in MS Access 2000?

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

Guest

Database: tracks hours for 8 people (all tasks have numeric code)

Report: in date footer, totals time

Question: can I break out annual and sick hours on the same line in the date
footer? Would I use a subreport and maybe another query? This is probably
simple...

Example:
Billable (Annual) (Sick)
1/1/00
_______________________________________________
Worked 4
Sick 3 (3)
Annual 1 (1)
_______________________________________________
TOTAL 8 (1) (3)
 
You can control that from the query,

select YourHourType,
Billable,
iif(YourHourType="Annual",-Billable,0) As Annual
iif(YourHourType="Sick",-Billable,0) as Sick
From YourTableName

then reference the annual and sick columns in your report and calculate your
totals in the date footer like any other field,
 
Wonderful! Thank you.

jl5000 said:
You can control that from the query,

select YourHourType,
Billable,
iif(YourHourType="Annual",-Billable,0) As Annual
iif(YourHourType="Sick",-Billable,0) as Sick
From YourTableName

then reference the annual and sick columns in your report and calculate your
totals in the date footer like any other field,
Click to expand...
 
Back
Top