Change a field in a query using combo box

[Zekeo]

I think ive bitten off more than I can chew with my first database. I want to store our manufacturing results and downtime in access rather than deal with 100's of spreadsheets.
Surprisingly I have a working version, all the tables are built along with user forms queries and a couple of reports.

My problem is with a report that I would like to add.

The table uses the following fields
Date, Supervisor, Machine 1, machine 2, machine 3 etc.

I want to produce a report using the following query.

Date, Supervisor, Machine n

Where machine n is chosen from a combo box in a form.

Is this possible?

 

[bat17]

Welcome to the board
You will be better off creating another table for your machines. This will give you far greater flexibility when it comes to running queries and things. It will also allow you to group results when someone decides that they want to lump some machines together for a graph but show others separately.
The Database Journal has an article on nominalization which may be of interest.

HTH

Peter

 

[Zekeo]

Thanks for the reply.

I did try building it that way initially, but encountered numerous problems, due to us having 5 sections within the plant each with around 15 machines, cells or lines within them. data must be recorded each day regardless if they have run or not. User forms needed to look like a spreadsheet so that data can be entered for each machine in each section on each shift of every day, forms being broken down by shift and section.

Wouldn't building it this way give me 15 records per section per shift, thats an amazing 225 records per day.

The way i have built it give me 1 record / section / shift, totaling 15 per day, a pretty huge reduction, but also the problem.

You hit the nail on the head, I need to produce efficiency charts, filtered by supervisor or shift, I can filter the supervisor from a userform combo box but can't choose which Machine field I want in the query from a combo.

I can do it by querying everything and charting everything, but thought it would be more useful if the user had the options available, will have to do it this way if its not possible.