room chart problems

Hello All,

I have a report that has unbound boxes for each room, and each unbound
box is named for a room i.e N047A,N047B,N048A,N048B etc..

Is there a way that I can use the label name such as "N047A" as the
criteria for a dlookup or other function .. that would populate the
unbound box with the persons name [tblFullName] and date they were
placed in that room [AssignDate].

This particular report will have 34 total rooms, and I need it to
autopopulate each persons information in the appropriate box on the
report.

TIA,
_Bigred
.

Relevant Pages

  • Re: Using a form to open a report
    ... I have a report: rptByEmployee, which I want to open by way of a form. ... txtStartDate and txtEndDate (both unbound) ... Assuming that your controls for Starting Date and Ending Date are ... If the Employee field could contain a ' ...
    (microsoft.public.access.reports)
  • Re: Using a form to open a report
    ... I have a report: rptByEmployee, which I want to open by way of a form. ... txtStartDate and txtEndDate (both unbound) formatted to short date. ... Assuming that your controls for Starting Date and Ending Date are ... If the Employee field could contain a ' ...
    (microsoft.public.access.reports)
  • RE: Field timming!
    ... I did try to reference the unbound field the way you showed me, however, ... when my report prints out, it is behind my 3 opened forms. ... >>of the unbound textbox has an expression created in the ...
    (microsoft.public.access.formscoding)
  • Re: room chart problems
    ... I have a report that has unbound boxes for each room, ... The problem with your proposed report is that you want to lay out the boxes as though they were all fields in one record, whereas the "natural" way of storing these rooms, and room assignments, is as discrete records. ...
    (microsoft.public.access.reports)
  • Field timming!
    ... SOMEHOW I CAN'T PRINT UNBOUND FIELDS IN A REPORT)." ... >of the unbound textbox has an expression created in the ...
    (microsoft.public.access.formscoding)
Loading