[AccessD] difficult query??

Hi Pedro, 

Must this be done in SQL/query or are you allowed to use a loop? 
If you can use a loop I'd use the number field in a nested loop (eg. 1 to
nr.) to add all records into a new table having the numberfield filled with
'X.


Regards, 
Eric Starkenburg 

-----Oorspronkelijk bericht----- 
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Pedro Janssen 
Verzonden: maandag 8 november 2004 22:48 
Aan: AccessD at databaseadvisors.com 
Onderwerp: [AccessD] difficult query?? 

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 
-- 
_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 



  _____  

avast! Antivirus <http://www.avast.com> : Uitgaande bericht is niet besmet. 


Virus Gegevensbestand (VPS): 0445-2, 04-11-2004
Getest op: 8-11-2004 23:13:21
avast! auteursrecht (c) 2000-2004 ALWIL Software.