Re: Coding file into 4ths
From: Hal Pratt (pdihal_at_comcast.net)
Date: 02/12/04
- Next message: John Spencer (MVP): "Re: Query Criteria"
- Previous message: Rick: "P.S. to decimal datatype field not sorting correctly"
- In reply to: [MVP] S.Clark: "Re: Coding file into 4ths"
- Next in thread: Duane Hookom: "Re: Coding file into 4ths"
- Reply: Duane Hookom: "Re: Coding file into 4ths"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Feb 2004 18:29:33 -0600
What I'm looking to do is Nth code a list into fourths (i.e., record 1=A,
rec 2=B, rec 3=C, rec 4=D, rec 5=A, rec 6=B and so on)
"[MVP] S.Clark" <Steve.Clark_NOSPAM@FMSInc.com> wrote in message
news:eTXno797DHA.1948@TK2MSFTNGP12.phx.gbl...
> Define what you mean by "coded".
>
> Use 4 make table queries to write the data from the 1 table to each of the
4
> tables.
>
>
> --
> HTH,
>
> Steve Clark, Access MVP
> FMS, Inc.
> Professional Solutions Group
> http://www.FMSInc.com
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Is your Access database too slow?
> Are you ready to upgrade to SQL Server?
> Contact us for optimization and/or upsizing!
> http://www.FMSInc.com/consulting
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> "Hal Pratt" <pdihal@comcast.net> wrote in message
> news:gICdnaB0FPlC2rXdRVn-ug@comcast.com...
> > I have customer file with hundreds of unique autonumbers [ID] which need
> to
> > be coded into 4 groups of equal size. Is there a way to do it in with a
> > single expression?
> >
> >
>
>
- Next message: John Spencer (MVP): "Re: Query Criteria"
- Previous message: Rick: "P.S. to decimal datatype field not sorting correctly"
- In reply to: [MVP] S.Clark: "Re: Coding file into 4ths"
- Next in thread: Duane Hookom: "Re: Coding file into 4ths"
- Reply: Duane Hookom: "Re: Coding file into 4ths"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
