Excel as a database?

per3 · May 23rd, 2002, 08:29 AM

I am utilizing excel to create an extensive database for an industrial engineering firm. There are machine specific tabs with fields such as customer name, city, state, description, and part number. I need to create a user form that allows different queries to be made on one or all of the criteria. This query needs to spit the appropriate information somewhere, probably in an output tab. The front-end should include the field names with drop-down menus. Basically, I would like some suggestions as to how to set up a query systems similar to what I have just described. Also, since certain machinery doesn't include some of the fields when the query is executed, how can each query be format specific to elimate blank columns from the output? Any help and/or guidance is most appreciated, thank you for your time and I look forward to your reply.

lenze · May 23rd, 2002, 08:36 AM

Here is a link that might be helpful.

http://tushar-mehta.com/index.html?h...cel/intro.html

Also, you might consider some type of Pivot Table

[ This Message was edited by: lenze on 2002-05-23 07:36 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 08:29 AM	#1
per3 New Member Join Date: May 2002 Posts: 10	I am utilizing excel to create an extensive database for an industrial engineering firm. There are machine specific tabs with fields such as customer name, city, state, description, and part number. I need to create a user form that allows different queries to be made on one or all of the criteria. This query needs to spit the appropriate information somewhere, probably in an output tab. The front-end should include the field names with drop-down menus. Basically, I would like some suggestions as to how to set up a query systems similar to what I have just described. Also, since certain machinery doesn't include some of the fields when the query is executed, how can each query be format specific to elimate blank columns from the output? Any help and/or guidance is most appreciated, thank you for your time and I look forward to your reply.

May 23rd, 2002, 08:36 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Here is a link that might be helpful. http://tushar-mehta.com/index.html?h...cel/intro.html Also, you might consider some type of Pivot Table [ This Message was edited by: lenze on 2002-05-23 07:36 ]