[AccessD] 8 columns of data to 6 output fields

Hi Paul and the list,

I had a re-think last night and have now come up with a string based on the 
codes that need to appear in the report.

So I will end up with things like, the lengths will differ according to how many 
mapped values there are in the data

190101010101
0301192701
01011901
0101
030119

Where I have hit my next brick wall is the removal of duplicates from this 
string.

So, for the string 19010101, I only need to see 1901 and these will then be 
spilt into 19 and 01 for the output


I have sort of got some duplicate removal working, but again its very klunky and 
doesn't catch things like 01011901 where the 19 fools my logic.

I've also now run into a "Query too complex" problem as well.

Guess the question now is how can I remove the duplicates from the string that I 
create !!

I think that once I can resolve this bit I can get the output I need

Once again, thanks for any help.

C




________________________________
From: Paul Hartland <paul.hartland at googlemail.com>
To: Access Developers discussion and problem solving 
<accessd at databaseadvisors.com>
Sent: Wednesday, 17 November, 2010 7:18:44
Subject: Re: [AccessD] 8 columns of data to 6 output fields

Chris,

If you still havent solved this could you mock up a quick access db with
some dummy tables/data, zip it up and mail me off list (
paul.hartland at googlemail.com) and I will have a quick look today, as I think
I know exactly what you want.

Paul