Query Filter Sort

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

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!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'd have to have some way of identifying the user. Using Access user
security you'd use the CurrentUser() function.

Use a query that filters data, dependent on the user. E.g.:

SELECT * FROM table_name
WHERE (CurrentUser() = "Vannessa" AND Name Like "[A-M]*")
OR (CurrentUser() = "Jessica" AND Name Like "[N-Z]*")

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVHPJoechKqOuFEgEQKtZwCgokq2VLz71mql4E+OldnAicMOmiIAoNUc
gdpi5zDJtyttAvF49m54tAvv
=hydb
-----END PGP SIGNATURE-----
 
Back
Top