Combine multiple records for a single date into 1 record

[Guest]

Hello, I am creating a database that will be used to track janitorial
duties. Each duty is performed once a week by a certain person on a certain
shift, and almost every day has more than one duty/person/shift combination.
I have created the tables, forms, links, and a great calendar report thanks
to A.D. Tejpal's reportcalendarstyle.mdb sample at rogersaccesslibrary.com.
Anyways the problem is that the calendar report will write a new day in the
calendar for every task, ex my calendar will have 4 May 5ths containing one
task a piece (but I want one May 5th containing 4 tasks). I am looking for a
way that I can combine multiple task, shift, and employee records for one
calendar date into 1 text field which I would then in turn link to the
report.

appreciate your ideas!

Adam

 

[Guest]

Rather than combine I think you could display the date in a text box of the
report but change the Hide Duplicates property to Yes. It would change this
--
5 May Mop
5 May Wax
5 May Empty trash
to display this --
5 May Mop
Wax
Empty trash

 

[Guest]

Karl,

I tried your suggestion, however when I change the Hide Duplicates to yes it
caused all of the text boxes to return #Name?. I tried all different
combinations of hide duplicates on and off with the textbox that returns the
day's details and the textbox that returns the date number, I was able to get
the date number to print out only once, however there would be a day's
details textbox next to it without the date number textbox above it. Any
ideas what could be causing this, do I maybe need to link the two textboxes
in some way? Also, I have been having some troubles getting "ChoreName"
"EmployeeName" "ShiftName" to return in the day's detail textbox in the
report(report currently returns "ChoreID" "EmployeeID" "ShiftID"), but in the
query all of the Names (not IDs) show, and the report links to the query, how
does this happen?

Thanks for your help!

Adam

 

[Guest]

Any ideas?

Thanks,

Adam

Karl,

I tried your suggestion, however when I change the Hide Duplicates to yes it
caused all of the text boxes to return #Name?. I tried all different
combinations of hide duplicates on and off with the textbox that returns the
day's details and the textbox that returns the date number, I was able to get
the date number to print out only once, however there would be a day's
details textbox next to it without the date number textbox above it. Any
ideas what could be causing this, do I maybe need to link the two textboxes
in some way? Also, I have been having some troubles getting "ChoreName"
"EmployeeName" "ShiftName" to return in the day's detail textbox in the
report(report currently returns "ChoreID" "EmployeeID" "ShiftID"), but in the
query all of the Names (not IDs) show, and the report links to the query, how
does this happen?

Thanks for your help!

Adam

 

[Duane Hookom]

Check out the calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is a calendar
style report that allows any number of detail records on a date.