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

Picking a Value

P: n/a
I have two Access 2003 tables, one has a "Zone" and "Lot1SqFt" that
changes with each record.

The other table has fields (columns) for each "Zone" plus a Minimum
and Maximum field
and "Records" (rows) that denote the size "Lot1SqFt". (14 fields and
8 records)

How can I have Access find the right value, in the 2nd table, for the
two values from the 1st table?

I'm new to Access and don't know if Dlookup is best or how to write
anything that will do this!

Can anyone help me with this??? Please?

May 24 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Deac wrote:
I have two Access 2003 tables, one has a "Zone" and "Lot1SqFt" that
changes with each record.

The other table has fields (columns) for each "Zone" plus a Minimum
and Maximum field
and "Records" (rows) that denote the size "Lot1SqFt". (14 fields and
8 records)

How can I have Access find the right value, in the 2nd table, for the
two values from the 1st table?

I'm new to Access and don't know if Dlookup is best or how to write
anything that will do this!

Can anyone help me with this??? Please?
IF you open up the query builder, add the two tables. Link the two
tables on the zone (drag zone from 1 table to the other). Do the same
for Lot1SqFt.

If the second table does not have a Lot1SqFt (I don't fully understand
your table structure, so I don't fully understand the problem) perhaps
you need to use Between. Drag Lot1Sqft from table 1 and use Between
Table2.Min And Table2.Max in the criteria row..

Or Multiply Min and Max to get the LOt1Sqft? And in the criteria row
use Table1.Lot1sqft.

Hard to say with the info provided but maybe this will get you on track.
May 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.