I have a subreport that is sorting and totaling by a field called 'insrcd'. This fields description is 'iname' in table 'insurance'. In the 'insrcd' footer on the report, I print the 'insrcd' and the total for this category. This works fine. Now I am trying to add the description of 'insrcd' and I can not get it to work. The best I have gotten is the description of the first entry in the 'insurance' table. I added a Text Box and set the control source to '=DLookUp("iname","insurance","insurance.insrcd = " & '[insrcd]')'. This prints the first entry in the insurance table.
The record source for this report is a query 'pr7demog'. I am not printing anything else on this report, the detail section is empty, because all I am interested in is the totals by insrcd category. What am I doing wrong?.
I am using Access 2003 and Win Vista.
All help is appreciated.
Sarah
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar