[AccessD] difficult query??

Pedro Janssen pedro at plex.nl
Mon Nov 8 15:47:56 CST 2004


Hello Group,

i have a table [tblA] with 20 fields.
One of these fields [Number] has a value from 1 to 25.
I would like each record with a value in field [number] giving the ammount of records of the value of field Number in a new table. And the value of field [Number] must change into "X". All other fields must also be present.

for example

i have
tblA

ID   fieldA  Number etc etc etc
1       A           3


i need 
ID   fieldA  Number etc etc etc
1       A           X
1       A           X
1       A           X

Can this been done?

Thanks

Pedro Janssen



More information about the AccessD mailing list