I have a somewhat complex report that I am attempting to create that draws different types of information from a number of different tables.
This is a 2 part question. I haven't coded any reports in Access for quite a while so please bear with me.
As a report runs, is there a way to reference current record values in the detail portion of the report? What I have is an employee database and as it processes each detail record I want to use the current detail SSN to generate additional values.
Second question. Is it possible to assign a value to a text box as determined by a sql string? i.e. make a text box equal to something like "select sum(RegularHours) from employee where SSN = CurrentReportDetailSSNValue" <--This is a very simple example only.
I may just end up creating a new table to temporarily hold all of the values that I am looking for.
Also open to any other ideas.
Thanks for at least reading and not making too much fun of me.