Query formula (one field based on another field)

[afs24]

I have two fields VCP & SSP. I want to pull all VCP's less than 12 and all SSP's that are 50% of the VCP or less. How would I create this in a query.

VCP SSP
12 6
12 4
10 5
10 2
6 6

 

[bat17]

In the criteria for the VCP field add <12.
add a new column and add PC: [ssp]/[vcp] to caculate the PerCentage.
In the criteria of this column add <0.5

If you want it to select both cases put the criteria on seperate Rows. (I.E if you want a VCP of 14 and a SSP of 5 to show)


HTH

Peter

 

[ddeldeb]

Here is the SQL for a query:

SELECT Table1.VCP, Table1.SSP
FROM Table1
WHERE (((Table1.VCP)<12) AND ((Table1.SSP)<=(VCP * .5) ));

This returns records of VCP 10 & 10 with the SSP records with 5 & 2

I think this is what ya wanted.

Dave,,