[AccessD] difficult query??

Hello Eric,

it doesn't matter how this is done, as a query expression or in code.
Only i don't have an idea how to do this.

Pedro Janssen


In antwoord op:

> From: "StaRKeY" <starkey at wanadoo.nl>
> To: "'Access Developers discussion and problem solving'"
> Date: Mon, 8 Nov 2004 23:13:22 +0100
> Subject: RE: [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.
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>