If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
using dlookup and multiple table querie on a single form
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 |
#3
|
|||
|
|||
using dlookup and multiple table querie on a single form
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. |
Thread Tools | |
Display Modes | |
|
|