Creating a string based on a query

B

bvdahl

Hello,

I have a query who generate a different number of rows depending on the
parameters I use to filter it by. In this query, there is a column that I
need to transfer to a string.

Let's say that the column's name is 'date'. If the query yields two rows and
the entries in this column are 'May 2nd' and 'June 3rd', then I want to ba
able to create a string in a textbox on the form that reads: May 2nd - June
3rd. If the query yelds more rows, then I want the string to get longer
accordingly.

I hope I have made the question clear enough, and I would be very thankful
for any help.

Baard
 

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

Top