L
Lee-Anne Waters via AccessMonster.com
Hello everyone,
My problem is i have main table where i store all the constant values (some 1000 records)
when a job is booked off we select the relevent codes from this table and it writes them to another table:
ie: job 56 (Orders Table) = job 56 Item 2.1
job 56 Item 2.2 (and so on)
so everything is working fine up to this point
now the probelm, what our client wants is to see all these values in one cell with the order only having one row. (there can be up 100 or so values)
ie: Row would equal = Job 56 (new cell) 2.1;2.2 and so on but only in one cell
the sheet would then get exported to excel. its having all the values in one cell that i really need help on
why our client actually wants this i dont know but they are insisting that the data be returned this way.
Thank you so much for your assistance
Lee-Anne
Perth WA
My problem is i have main table where i store all the constant values (some 1000 records)
when a job is booked off we select the relevent codes from this table and it writes them to another table:
ie: job 56 (Orders Table) = job 56 Item 2.1
job 56 Item 2.2 (and so on)
so everything is working fine up to this point
now the probelm, what our client wants is to see all these values in one cell with the order only having one row. (there can be up 100 or so values)
ie: Row would equal = Job 56 (new cell) 2.1;2.2 and so on but only in one cell
the sheet would then get exported to excel. its having all the values in one cell that i really need help on
why our client actually wants this i dont know but they are insisting that the data be returned this way.
Thank you so much for your assistance
Lee-Anne
Perth WA