Re: Combine multiple records for a single date into 1 record

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.
--
Duane Hookom
MS Access MVP

"Adam" <Adam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:01490DC6-4461-4796-BBC4-6CBBFD84B516@xxxxxxxxxxxxxxxx
Any ideas?

Thanks,

Adam

"Adam" wrote:

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

"KARL DEWEY" wrote:

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


"Adam" wrote:

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


.

Relevant Pages

  • @@@@every burdens will be selective think leaves@@@@
    ... Estefana's silk motivates in favour of our calendar after we ... confront through it. ... I was enjoying to report you some of my ...
    (sci.crypt)
  • Re: Count within intervals
    ... Each time the asset status changes, ... >I need to produce a report that counts the devices by type that were ... you need a calendar table that holds all dates this report could ... suggested query), we create a list of all dates each asset was IN. ...
    (microsoft.public.sqlserver.programming)
  • Re: Calendar Report
    ... It isn't clear if you are just drawing a calendar or if you are adding data. ... The following code draws a calendar on a report page. ... Dim lngDayHeight As Long ... The details section of my> report is split into 7 columns, and in the On Format section of my detail,> i have the following code which sets the date under the correct column ...
    (microsoft.public.access.reports)
  • Re: My calculated expression field is not being populated in the t
    ... I can get that but the problem is that I have a prompt to run the report ... which is 'Calendar Year'. ... now I have the report looking at a calendar year query and the query criteria ... > any calculation will be MUCH faster than a disk fetch); ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Calendar on report
    ... I have my applications pop up a calendar any time a textbox on a date ... Month and day and doubleclick to return ... > Currently, to run the report, one must enter each date in a separate ...
    (microsoft.public.access.gettingstarted)