I have a pricing tool I use in excel, works well but would be better in access.
I have set some tables up and one is Blank sizes, OD , ID and length.
My components are all round rings
On my form I wish to query this blank list by putting my part sizes in OD, ID and length, then search my blank table to bring by best blank and costs etc.
I thought Dlookup might do it, but this could return a blank which is not the ideal blank, i.e much too big on OD.
I have set some tables up and one is Blank sizes, OD , ID and length.
My components are all round rings
On my form I wish to query this blank list by putting my part sizes in OD, ID and length, then search my blank table to bring by best blank and costs etc.
I thought Dlookup might do it, but this could return a blank which is not the ideal blank, i.e much too big on OD.