using dlookup and multiple table querie on a single form

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/micro...aaaec395a4b4e1

any help would be appreciated

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


"M G Henry" wrote:

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/micro...aaaec395a4b4e1

any help would be appreciated

M G Henry

On Feb 6, 9:35 am, Duane Hookom
wrote:
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



"M G Henry" wrote:
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/micro...forms/browse_t...

any help would be appreciated

M G Henry- Hide quoted text -

- 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.