Hi all, first post..
I had been using excel to track some basic data on some assets but it has grown to big and I require better query abilities. anyhow I am using access 2007 and my database is like this
table: assets; serial number, model, purpose, etc
some of those such as model and purpose are related to other tables that list models and purposes
I have a form where I have me and a few other people make changes. It basically just limits access to stuff like serial number but...
It is a split form so it shows all records at a time but I want to be able to filter the shown records based on the purpose and/or model I just need help how to get it to show the list of records that meet the critera.
thanks all