Hi,
I an new to access, and need to build a simple app.
this is supposed to be a kind of journal, and the main table (named 'entries') holds records with the following fields:


- record_id (autonumber)
- text_contents (a short memo, up to 255 chars)
- tags
the tags field is a multivalued lookup field that links to another table (called 'tags') with all the possible tags. (that table has only two fields: tag ID and tag name)
Now I'm trying to create a report, and group all the memos based on their tags.
the result should be:

tag 1:
memo 1
memo 2
tag 2:
memo 2
memo 3
as i showed here, if a memo has two tags, it should be listed under both. (this applies to 'memo 2' in this example).

I have managed to use the report wizard and group by 'tags.value'.
The result is almost exactly what I need, in the sense that everything is grouped correctly. The only problem is that the report shows the tag ID in stead of the tag name.
How do i add a field to the report, that would show the text representation of my 'tags.value' field? I think it should be simple.....

Take in mind that I really don't know much about access. I'm mostly clicking through the menus up until now.... i have some basic programming and database background, but that's all.

Any help would be great. I hope i explained my problem clearly enough.