dobule level break

  • Thread starter Thread starter rathika
  • Start date Start date
R

rathika

hi

i have a table with columns and records like this

Fields Record 1 Record2

employeename tom ian
month june june
Stage1-Penthouse 10 20
Stage1-Beachclub 15 25
Stage3-Penthouse 30 45
Stage3-Beachclub 50 90
stage1-Terrace 18 28
Stage3-Terrace 16 46


and so on like this

but my report should be like this

Item : Penthouse
----------------
stage :1
----------
Employee name No. of hrs
Tom 10
Ian 20

total 30

Stage : 3
-----------
Employee name No. of hrs
Tom 30
Ian 45


Item : Beach club
------------------
Stage :1
----------
Employee name No. of hrs
Tom 15
Ian 25

Stage :3
---------
Employee name No. of hrs
Tom 50
Ian 90


It is a double level break report.

pls help ( my records are not favourable)


this is very urgeant for me

rathika
 
Alas, by including _data_ in the field _names_, you have made your table
less than fully relational and made your job more difficult. Consider
revising your table design to have a record that links an employee and a
location (e.g., stage and location) with a work hours record.

Typically, you'd have an employee table with a unique id for each employee
and other information about the employee that is pertinent to your
application; similarly, if there's anything other than name for the things
like "Stage 1 - Beachclub", you'd have a location field with records
containing as data the information you're using as Field Names now. Then
you'd have a table for work hours, with foreign keys of employee id and
location id.

This, of course, will need some forms and a "developed application" for data
entry and editing. But, you can't do report sorting and grouping on Field
names as you apparently need to do, only on data.

Larry Linson
Microsoft Access MVP
 
Back
Top