Is a query what I want?

[jerimy75]

I've started a database for engineering plans/ blueprints in my office, which date back to the early '70's. I would like to be able to search for projects (plans/blueprints)to help facilitate research for future projects. For example if I am going to do a water main replacement on street A, I would like to search not only for plans that involved street A in the past, but also for projects that have involved water mains in the past. I guess it would kinda be like a cross reference, if that makes any sense. I already have my database made. It includes the Project Number, Description, Type (Water main, Sewer, etc.), Type 2 (if a certain project involved more than one type), Main street, and 15 Side street (some projects go a few miles and involve more than one street), Project file location, As-built, and Hard copy on file fields. I would like to use some kind of form with pull down menus to preform the search, and subsequently list every project that meets the criteria I've selected. If anyone understands what I am trying to do and has an idea of how I can accomplish this task I would be very greatful.

 

[johnnymac43]

I hope I'm wrong, but it sounds like you have all the data for these projects in one table. If this is so, you will need many queries to find all projects of interest. If at all possible, build separate tables for Type and Street, with link tables for the Many-to-Many relationships. You will then only need one query for Type and one for Street. Any projects that match on Type and Street will appear in each result set.

HTH

John

 

[Clandon]

jerimy75

You are on the right track if you want to use a form instead of a query. But, you can still create a form using a query with a drop down, but you will need to include many "Or" criteria in your query the form is built on. If you have more definite criteria you need help with, let me know.