Filtering basic database

K

Katie

I am a novice to microsoft access, and am finding some difficulties
with steps to complete a very simple database. The information
currently stored is a supplier list, with supplier
id-name-address-email-contact-notes, I want the users of this database
to be able to filter by state, by supplier name (as some suppliers
have several locations) and so on...
So I attempted to move next on to a query, which left me able to sort.
could I be too far off?
 
R

Rick Brandt

Katie said:
I am a novice to microsoft access, and am finding some difficulties
with steps to complete a very simple database. The information
currently stored is a supplier list, with supplier
id-name-address-email-contact-notes, I want the users of this database
to be able to filter by state, by supplier name (as some suppliers
have several locations) and so on...
So I attempted to move next on to a query, which left me able to sort.
could I be too far off?
Click to expand...

If the entire address is in a single field then you won't be able to filter
on state very easily or efficiently. Each piece of the address should have
its own field.
 
J

JoeO

SELECT tbl_Clients.*, tbl_Clients.State
FROM tbl_Clients WHERE tbl_Clients.State ="Texas"

SELECT tbl_Suppliers.*, tbl_Suppliers.Name
FROM tbl_Suppliers WHERE tbl_Suppliers.Name ="Donald Duck"
 
K

Katie

Apologies on not being more specific and correct, The address is
inclusive of building number and street name only. City, State and Zip
code are all seperate fields.
 
Top