Single row data query

[nicolareina]

good morning Forums I wanted to create a selection query.

I have a table called Allegati_Autorizzazioni, multiple dates are associated with each individual customer id.
Is it possible to extract the dates of each individual customer ID and have them in a single line?
thanks for help.
Nicola Reina

 

[CJ_London]

Use a crosstab query? Or look at the concatrelated function

Microsoft Access tips: Concatenate values from related records

Return a string containing the values of related records.

allenbrowne.com

Be aware the function will only return 255 chars so if your dates are say 10 chars plus a comma you will be limited to 23 dates

 

[arnelgp]

Allegati_Autorizzazioni table is Linked table so we cannot access it's data.
what you can do is make a copy of your FE and on the copy, right click on
Allegati_Autorizzazioni linked table and convert it to local table.
then post back the copy of your db.

 

[nicolareina]

@arnelgp

Allegati_Autorizzazioni table is Linked table so we cannot access it's data.
what you can do is make a copy of your FE and on the copy, right click on
Allegati_Autorizzazioni linked table and convert it to local table.
then post back the copy of your db.

pardon mea culpa

 

[arnelgp]

see Query2. also view the code in Module, basConcatRelated.

 

[Gasman]

good morning Forums I wanted to create a selection query.

I have a table called Allegati_Autorizzazioni, multiple dates are associated with each individual customer id.
Is it possible to extract the dates of each individual customer ID and have them in a single line?
thanks for help.
Nicola Reina

Crossposted at https://www.accessforums.net/showthread.php?t=90672

 

[nicolareina]

see Query2. also view the code in Module, basConcatRelated.

good work!!
I was wondering if it was possible to separate the fields. thanks a lot.

 

[Pat Hartman]

I was wondering if it was possible to separate the fields. thanks a lot.

don't use the concat function. Use a crosstab query.

 

[arnelgp]

test query3.

 

[nicolareina]

test query3.

It was just what I wanted.
thanks my friend

 

[nicolareina]

It possible select a data range??

test query3.

 

[Gasman]

It possible select a data range??

Yes, you use criteria in the query.

 

[nicolareina]

Yes, you use criteria in the query.

I couldn't do it because the query is concatenated. see the project

 

[Gasman]

I couldn't do it because the query is concatenated. see the project

You put the criteria on the base query, then only the data retrieved is concatenated.