Solved Concanetate according to date (1 Viewer)

[FahadTiger]

hi sir...
I have table like Table1 have this fields
i want concanetated descreption of cusName according to dates.. like this:
thanks my Experts

 

[theDBguy]

Have you seen/tried this simple function?

Code Snippets

 

[ebs17]

Similar functions: SQLListe, ADOConcat, ConcatVar
Grundlagen - SQL ist leicht (22) - Zusammenfassen von Datensätzen

 

[FahadTiger]

thanks Sir for replying..im trying several time but I can not pass the date into the function ..so I can concatenate the field (descreption) have the same date as shown in my demo
thank you

 

[Gasman]

thanks Sir for replying..im trying several time but I can not pass the date into the function ..so I can concatenate the field (descreption) have the same date as shown in my demo
thank you

That is because you are not taking into account the dates, just the custname?
The code is only doing what you tell it to.?

Why not just use the DBGuy's function?

 

[FahadTiger]

IF you mean simpleCSV ..Im tried with it but fail

​

Why not just use the DBGuy's function?

 

[theDBguy]

IF you mean simpleCSV ..Im tried with it but fail

​

Here, open the query I created for you.

 

[Gasman]

IF you mean simpleCSV ..Im tried with it but fail

​

Well the thread is titled 'concatenate by date' and you are doing it by custname?

 

[FahadTiger]

But the Field (descreption) is Empty my sir

Here, open the query I created for you.

 

[theDBguy]

But the Field (descreption) is Empty my sir

Sorry, it wasn't empty when I tried it. Try taking out the alias and leave it as Expr1.

 

[FahadTiger]

But its still Empty

 

[theDBguy]

But its still Empty

Interesting, it's definitely not empty on my end.

There may be some fundamentals we're missing. Can you please answer the following questions?

1. Are you opening the query I created from the file I posted earlier?
2. Did you "unblock" the file first before opening it?
3. Did you "enable content" when you opened the file?

 

[CarlettoFed]

In the attachment a variant to the previous solution.

 

[Gasman]

Interesting, it's definitely not empty on my end.
View attachment 105502
There may be some fundamentals we're missing. Can you please answer the following questions?

1. Are you opening the query I created from the file I posted earlier?
2. Did you "unblock" the file first before opening it?
3. Did you "enable content" when you opened the file?

@theDBguy
I downloaded your DB really just to say 'works here'

However I also get

I will investigate further.
Just mentioning as hoping it might highlight the issue?

Edit: Date format issue, OP is using UK format dates as do I.

@FahadTiger
Replace the simple csv with

description: SimpleCSV("SELECT descreption FROM Table1 WHERE custname='" & [custName] & "' AND desdate=#" &Format( [desDate],"mm/dd/yyyy") & "#")

but please understand the issue.

Amended, I get

 

[FahadTiger]

t

Replace the simple csv with

thank you Gasman ..its perfect now .. Although I use (yyyy/mm/dd) in my pc
thanks theDBguy for your function
thanks CarlettoFed ..but that not i want it

​

​

 

[Gasman]

t

thank you Gasman ..its perfect now .. Although I use (yyyy/mm/dd) in my pc
thanks theDBguy for your function
thanks CarlettoFed ..but that not i want it

​

​

When using dates in Access they have to be in mm/dd/yyyy format or (I think) yyyy-mm-dd format. Certainly your format does not work?
I used this

Public Const strcJetDate = "\#mm\/dd\/yyyy\#"  'Needed for dates in queries as Access expects USA format.

in some of my DBs when I was using Access seriously.

Remember this anyway.

 

[theDBguy]

@Gasman Thanks for the assist. Cheers!

 

[Gasman]

@Gasman Thanks for the assist. Cheers!

More than welcome @theDBguy
Happy New Year as well.