J
JJA
In a report I would like to access the linked query to retreive info from a
specific field without using the detail section on the report. I have used
the DLookup within the Detail Header using VB Code. The problem is the DLoop
did not act as a "data dump" and locked on the first element that met the
criteria.
Question: If I have a query linked to the report how hard can it ge to
access one of the fields through code without having to use the detail
section on the report. I have tried using "Me.Test_Score" but I get an error
message that access cannot find the field. It shouldn't be that difficult to
do if the "Test_Score" field is in the query and the query is linked to the
report. I do not want to have to put the field in the Detail section because
the information will be compiled and used in the report footer.
Help me if you can with an easy solution........... thanks
specific field without using the detail section on the report. I have used
the DLookup within the Detail Header using VB Code. The problem is the DLoop
did not act as a "data dump" and locked on the first element that met the
criteria.
Question: If I have a query linked to the report how hard can it ge to
access one of the fields through code without having to use the detail
section on the report. I have tried using "Me.Test_Score" but I get an error
message that access cannot find the field. It shouldn't be that difficult to
do if the "Test_Score" field is in the query and the query is linked to the
report. I do not want to have to put the field in the Detail section because
the information will be compiled and used in the report footer.
Help me if you can with an easy solution........... thanks