S
submarine2000
Hi~. please help me...
I'd like to query a data based on the values in a form.
I'd like o know how I can read the bounded input values, and pass it to
query, and find the antena factor, and pass it to the Test subform. How can
I do?
Pleas look at the WHERE condition in the below.
SELECT tblTDS.TDSID, tblTDS.Sensor, tblSensor.SensorID AS
tblSensor_SensorID, tblSensorLevel.SensorLevelID,
tblSensorLevel.SensorFrequencyFrom, tblSensorLevel.SensorFrequencyFromHz,
tblSensorLevel.SensorFrequencyTo, tblSensorLevel.SensorFrequencyToHz,
tblSensorLevel.AntenaFactor, tblSensorLevel.SensorID AS
tblSensorLevel_SensorID, tblTest.TestID, tblTest.TestFrequency,
tblTest.TestFrequencyHz, tblTest.AntennaFactor
FROM ((tblSensor INNER JOIN tblSensorLevel ON tblSensor.SensorID =
tblSensorLevel.SensorID) INNER JOIN tblTDS ON tblSensor.SensorID =
tblTDS.Sensor) INNER JOIN tblTest ON tblTDS.TDSID = tblTest.TDSID
WHERE (((tblTDS.TDSID)=6) AND ((tblTDS.Sensor)=1) AND
((tblSensorLevel.SensorFrequencyFrom)<=10) AND
((tblSensorLevel.SensorFrequencyFromHz)=3) AND
((tblSensorLevel.SensorFrequencyTo)>=10) AND
((tblSensorLevel.SensorFrequencyToHz)=3) AND ((tblTest.TestID)=15));
I'd like to query a data based on the values in a form.
I'd like o know how I can read the bounded input values, and pass it to
query, and find the antena factor, and pass it to the Test subform. How can
I do?
Pleas look at the WHERE condition in the below.
SELECT tblTDS.TDSID, tblTDS.Sensor, tblSensor.SensorID AS
tblSensor_SensorID, tblSensorLevel.SensorLevelID,
tblSensorLevel.SensorFrequencyFrom, tblSensorLevel.SensorFrequencyFromHz,
tblSensorLevel.SensorFrequencyTo, tblSensorLevel.SensorFrequencyToHz,
tblSensorLevel.AntenaFactor, tblSensorLevel.SensorID AS
tblSensorLevel_SensorID, tblTest.TestID, tblTest.TestFrequency,
tblTest.TestFrequencyHz, tblTest.AntennaFactor
FROM ((tblSensor INNER JOIN tblSensorLevel ON tblSensor.SensorID =
tblSensorLevel.SensorID) INNER JOIN tblTDS ON tblSensor.SensorID =
tblTDS.Sensor) INNER JOIN tblTest ON tblTDS.TDSID = tblTest.TDSID
WHERE (((tblTDS.TDSID)=6) AND ((tblTDS.Sensor)=1) AND
((tblSensorLevel.SensorFrequencyFrom)<=10) AND
((tblSensorLevel.SensorFrequencyFromHz)=3) AND
((tblSensorLevel.SensorFrequencyTo)>=10) AND
((tblSensorLevel.SensorFrequencyToHz)=3) AND ((tblTest.TestID)=15));