Query Filter Sort

From: Toan Chau (anonymous_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 12:00:10 -0700

Hello all!

Let's say I have a table that has these columns...

Account #, Name, Person Requesting

I also have two person that are responsible for the file
depending on the the letter of the Name column

For example...

Vannessa is responsible for all files with the Name that
starts with a letter in the range of A-M.

Jessica is responsible for all files with the Name that
starts with a letter in the range of N-Z

How can I make a query that will sort out my table based
on the two critias mentioned above?

A thousand thanks in advance!

Relevant Pages

  • Re: OpenProcessToken access denied
    ... what access are you requesting in your call to OpenProcessToken? ... I don't know for certain what Process Explorer is doing. ... > domain account of the client computer. ... > by using Sysinternals Process Explorer. ...
    (microsoft.public.platformsdk.security)
  • Re: A little bit of math
    ... _must not_ be a string. ... someone requesting withdrawl from a bank account actually has the ... accelleration control in an automobile handles a request to ...
    (comp.lang.tcl)
  • Re: Bigots Continue to Expose Their Stupidity
    ... accounts by requesting a password change. ... the e-mail registered as the owner of the account that a request ... the idiots who keep making up phony entries &insisting they're mine. ...
    (soc.culture.jewish)
  • Re: Running a software / program as a service.
    ... Is the application full non-interactive (i.e. no user interface)? ... Does the application rely on running in the context of your account? ... Depending on answers then srvany may ...
    (microsoft.public.windows.server.security)
  • Re: AT & T
    ... Has anyone else been receiving mailings and phone messages from AT & T ... that someone was requesting an address change on your account (phone ... changes being requested on the account, but then try to do a hard sell ... AT&T's part that customer service people are supposed to try to sell ...
    (alt.support.arthritis)