So you already have a query as the source for the report, and that query
includes a field named MemberNr.
Your Members table also has a field named MemberNr.
Add the Members table to the query.
Join it to your existing table on the MemberNr field.
Drag the [Name of team] field into the query grid.
You now have the [Name of team] field in your report.
If some records in your main table have no MemberNr (i.e. it is Null), you
will need to double-click the line joining the Members table to your
existing one. Access pops up a dialog offerring 3 choices.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
LeifT said:
Thank You for Your answer BUT
I already have another question as base för the report and I can´t find a
way to incorporate my lookup-field in the original question because I pick
up
this lookup-field from another question in my database using following
typical solution:
=DLookUp("[Name of team]";"[Members]";"[MemberNr] = Reports![Actual
report]![MemberNr]")
I hope I now have explained my problem and hope there is another solution
for this problem
--
LeifT
"Allen Browne" skrev:
Create a query that contains the table you need for your report, and also
the table you need to look up.
Save this query, and set the report's RecordSource to this query.
You now have the lookup field in the report's RecordSource, so you can
choose it in the Sorting And Grouping box in report design view.
I have a report in which I have a need for a DLookUp-field.
How do I manage to sort on this field in the report ??
Thank You i advance for an answer
