Query tables where string of data is other table

[mralmackay]

Hi,
Hope I explain this well enough... I have two tables in my db.
Table1 'Request' and Table2 'User'.

These tables don't have any link between them.

I need to be able to count how many Case-ID (from Table Request) exist
where field Diary (from Table Request) has any of the names within
table User, field 'Full-Name'. There is one other condition though
that I need to apply, that is to only use examples from table User
that have the field 'Primary-Group' = 'System Team'

So for example if Table User contains five people (rows) that are in
the primary-group 'System Team'. I need to understand how many cases
within table Request that they've been involved in. This is all
captured within the Diary field so it needs to look within the string
of data.

Hope this is enough information. Apologies, just have no idea where
to start on this - access knowledge isn't the best and this is far
beyond me!

Thanks in advance, Al.

 

[Golfinray]

If the tables are not linked (have a relationship) there is not an easy way
to do that. You need to find some way to link them, like putting an
autonumber field in the tables if nothing else. In table design, set a
primary key in both tables then go to tools/relationships and set a
replationship. Then your query should connect them for you.