Re: Sorting Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sun, 24 Jun 2007 09:04:06 -0400, Tom <tom@xxxxxxxx> wrote:

Am running an Access 2K database in Access 2003. Have not converted it yet
and cannot for awhile until entire sales force has the new Laptops running
Access 2003.

My application deals with some 24,000+ part numbers that sometimes need to
be sorted in our part number sequence in Reports. Our part numbers involve
both numeric only number consisting of string lengths from 4 to 8 AND part
number that begin with Alpha characters (1 or 2 or 3 Alphas) then numeric
numbers with string lengths of 3 to 8. Some of these numbers have a hyphen
in them that skew the actual string length for sorting based on length. We
publish our price lists and put our products on the shelf based on the
length of the part number (up to the hyphen), then the sort.

I am looking for a way to sort our numeric numbers based on length and then
sort our Alpha/numeric parts up the hyphen in the part number when the
Report is printed.

If someone could point me in correct direction, it would be much
appreciated!

TIA!

This is not an Access or VB problem per se.
This is a logic problem. First solve the logic of what you are trying to do.
Express the logic in a series of plain english statements (or what ever your
first language is), or a series of algebraic equations.
The logic does not change from one program to another, only the syntax the
program requires varies - in this case you need the syntax Access requires.

Example: In VB you might have if ... then ... else ...
In Access you would have iif ... then ... else ...
In Excel you would have if(... , ... , ...)
The syntax is different but the results are the same.

Chuck --
.

Relevant Pages

  • Re: Sorting Question
    ... both numeric only number consisting of string lengths from 4 to 8 AND part ... I am looking for a way to sort our numeric numbers based on length and then ... first language is), or a series of algebraic equations. ... program requires varies - in this case you need the syntax Access requires. ...
    (microsoft.public.access.reports)
  • Re: Advanced Macros && Preprocessors
    ... nor what sort of "motion" you desire. ... Currently i'm using SAFECALL macro, the syntax is SAFECALL, ... evidently trying to introduce some sort of assertion or error-check, ... exp comment ...
    (comp.lang.c)
  • Re: Startup Outlook Express Via Command Line
    ... There is no provision there to add an attachment, ... but it doesn't with Outlook Express 6. ... sort of syntax that I can think of in the 'attachment' part). ... OE 6 actually works, and if so, what the syntax would be? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Startup Outlook Express Via Command Line
    ... The only choice that would work would be to use a template to send mail. ... but it doesn't with Outlook Express 6. ... sort of syntax that I can think of in the 'attachment' part). ... OE 6 actually works, and if so, what the syntax would be? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Sorting Question
    ... and cannot for awhile until entire sales force has the new Laptops running ... both numeric only number consisting of string lengths from 4 to 8 AND part ... number that begin with Alpha characters then numeric ... I am looking for a way to sort our numeric numbers based on length and then ...
    (microsoft.public.access.reports)