Easy Question: Comparison Operator

[IceTre]

Hi --

I haven't used Access on a regular basis in 3 years and many simple
concepts have escaped me.

I have a database and I'm trying to print only the records from the
database where field A "quantity" is less than field B "stock."

I just can't remember if I do that in the Field space or the Criteria
space and how I write it out.

Thanks in advance!

-Trey

[Bas Cost Budde]

Join the tables on, say, part number (assuming the quantity is of parts)
and then put the quantity in a column. In the criteria line, you then have

<stock

IceTre wrote:

Hi --

I haven't used Access on a regular basis in 3 years and many simple
concepts have escaped me.

I have a database and I'm trying to print only the records from the
database where field A "quantity" is less than field B "stock."

I just can't remember if I do that in the Field space or the Criteria
space and how I write it out.

Thanks in advance!

-Trey

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

[IceTre]

Hey thanks...actually there was only one table involved so it was even
easier than that -- all I needed to do was put:

[Quantity] < [Stock]

in the Criteria row in the Quantity field and it gave me what I needed.

Just very rusty on basic syntax stuff -- it will come back to me...

Thanks again!

-Trey