By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,870 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,870 IT Pros & Developers. It's quick & easy.

Easy Question: Comparison Operator

P: n/a


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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.