Binding a query result to a text box - PLEASE HELP !!

J

Jacob Frankham

PLEASE HELP!

I have had help in the past with this one but I cannot get it to work !

I have a query called 'sqry_ContractProvisions' which produces 2 fields:
contract and provision
ie
contract NTN001506 provision BET
contract NTN001506 provision LOT
contract NTN001506 provision IAP
contract SCO003201 provision SJFT

I have a report which is grouping by contract in the 'group header', and I
wish to list all of the associated provisions in the 'group footer' ON ONE
LINE SEPARATED BY COMMAS.

ie for the group NTN001506, I wish to see something like this in the group
footer:
BET, LOT, IAP

Hope you can help, I am a complete novice.

Jake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Binding query results to a text box 1
how to calculate sum of the repeating values in queries 2
Help with Query 2
Merge (sort of) 2 databases into one 6
New to Queries 4
HELP WITH Access QUERY PLEASE :) 8
append query from form only appends first record 0
VAT on Report 5

Top