creating a single string from mulitple query results

[action]

I am sending SMS messages of team league results, my current query give me a record for each game, how can I get all the games in a single string so that I can send it to the SMS server via email.

Current results show like:

CombineTeams:
GISB 2 Vs REDSOX 2
WANGANUI 0 Vs TARANAKI 3
NCR 2 Vs MANAWATU 0
MARIST PN 6 Vs MASSEY 0
H.LOCK 4 Vs TARADALE 2

At the moment I create a report and send this which I can't automate.

Any suggestions? Thanks

 

[RichO]

Do you want it to look like this?

GISB 2 Vs REDSOX 2, WANGANUI 0 Vs TARANAKI 3, NCR 2 Vs MANAWATU 0, MARIST PN 6 Vs MASSEY 0, H.LOCK 4 Vs TARADALE 2


The only way I would know of to do this would be to open a recordset based on your query and concatenate the strings by looping through the recordset.

Perhaps there is a better way that I'm not aware of.

 

[action]

Sound like thats the answer

RichO, yes I have had a friend suggest the same thing, I will have to look at the post on recordsets from queries. Thanks