using dlookup and multiple table querie on a single form

[M G Henry]

I have posted in the forms group looking for some assistance...

I have a project that requires the use of dlookup to retrieve data
from a matrix and then use factors input from a form to do aritmetic
functions to result in a sale price for any given quantity...

Having a problem constructing the querie upon which the form is based
to have it lookup across the tables properly.

the link to the thread is:

http://groups.google.com/group/micr...97cdb/69aaaec395a4b4e1?hl=en#69aaaec395a4b4e1

any help would be appreciated

M G Henry

 

[Duane Hookom]

It seems that you don't understand normalization and writing code. Your table
should not be a matrix. You need to normalize the table structure so that
adding "brackets" or whatever would never ever mean adding fields or
modifying code.

Also, you mentioned "Macro". I believe you would have much better success
creating one or more functions with code to determine pricing.

 

[M G Henry]

It seems that you don't understand normalization and writing code. Your table
should not be a matrix. You need to normalize the table structure so that
adding "brackets" or whatever would never ever mean adding fields or
modifying code.

Also, you mentioned "Macro". I believe you would have much better success
creating one or more functions with code to determine pricing.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

excuse my lack of the correct terminology, as I am just beginning at
Access...

What I meant by the term matrix was a table with several different
columns and then rows within the columns... and what I needed to do
was use the dlookup command to find the proper row within the
table....

Thru much trial and error and other research I was able to solve my
problem.

I will work on learning the correct terminology.