Concatenate with Multiple Criteria filter

[jocasio via AccessMonster.com]

I have the followin tables and fields

Main
1. ID numeric
2. Name text
Training
1.TID numeric
2. TDATE date
3. ID numeric
TrainingList
1. TID numeric
2. TrainingDesc

The code that I cannot get to work is the following:
Expr1: Concatenate("select tdate from training where ID =" & [MAIN].[ID] &"
AND TID =" & [TRAININGLIST].[TID])

Please help, I need several record (dates) in one single field, but I need it
based on the ID and on the type of training.

Thxs,

 

[Gina Whipp]

Where are you trying to use this? Because you are calling two tables.
(Almost like talking to the neighbor without the phone.) I suggest you
create a query with the two tables in question.

Expr1: Concatenate("Select tdate FROM qryYourNewQueryHere WHERE ID =" &
[MAIN].[ID] &" AND TID =" & [TRAININGLIST].[TID])

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm