Return query results based on results of another field query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a access table with the listings of machines and which Circuit
breaker panel and Circuit breaker no. that supplies power to the machines.
Table: EQUIPMENT MASTER LIST CONTAINS: Text machine info:Mfg,No.,Power
KeyField: EQUIPMENT NUMBER CONTAINS: Text such as x0001,m0002, d0065
SUPPLIED FROM TYPE CONTAINS: Text such as PP, BD
Field: SUPPLIED FROM ID CONTAINS: Text such as A1, B3, C26
Field: CIRCUIT NO# CONTAINS: Numbers such as 1 thru 42
Field: Todo CONTAINS: YES/NO

I have a query that brings up all machines and the Circuit breaker that
supplies power to the machines that have a yes selected in the todo field.
The Circuit Breakers feed more then one machine, Circuit brekers follow
identification by PP26C11 = Power Panel PP, Panel Location 26C, Circuit
Breaker No.11

How can I return all the machine No. in a different field that matches the
same:
SUPPLIED FROM TYPE & SUPPLIED FROM ID & CIRCUIT NO#
 
I have set up a access table with the listings of machines and which Circuit
breaker panel and Circuit breaker no. that supplies power to the machines.
Table: EQUIPMENT MASTER LIST CONTAINS: Text machine info:Mfg,No.,Power
KeyField: EQUIPMENT NUMBER CONTAINS: Text such as x0001,m0002, d0065
SUPPLIED FROM TYPE CONTAINS: Text such as PP, BD
Field: SUPPLIED FROM ID CONTAINS: Text such as A1, B3, C26
Field: CIRCUIT NO# CONTAINS: Numbers such as 1 thru 42
Field: Todo CONTAINS: YES/NO

I have a query that brings up all machines and the Circuit breaker that
supplies power to the machines that have a yes selected in the todo field.
The Circuit Breakers feed more then one machine, Circuit brekers follow
identification by PP26C11 = Power Panel PP, Panel Location 26C, Circuit
Breaker No.11

How can I return all the machine No. in a different field that matches the
same:
SUPPLIED FROM TYPE & SUPPLIED FROM ID & CIRCUIT NO#
Click to expand...

Just additional criteria on these fields. You can use a Parameter
Query; one handy way to do this is to create a little form named
frmCrit, with combo boxes (unbound!) selecting all SUPPLIED FROM TYPE
(named cboType for example), SUPPLIED FROM ID (cboID), and CIRCUIT NO#
(cboCircuit) values. You can then use critera

=[Forms]![frmCrit]![cboType]

and so on. Base a Form (for online display) or Report (for printing)
on your query, and put a command button on frmCrit (using the command
button wizard) to open the form or report.

John W. Vinson[MVP]
 
Back
Top