Member Panel

I am in need of some help. I run a drywall company, so I rather swing a hammer than sit at a computer (sometimes i want to swing my hammer at my computer). My ??? is with Access. I have set up tables for my employees, with contact list. Table for all my subdivisions with supers that work in them. Table for my plan numbers with square footages. And one for my address i am, and have worked on. In my address table i have columns for, subdivisions, employee that did the work, plan #, square footage and i figured out how to pull those from my other tables. My question is on my plan # and sqr ft. i have a table with all that in it, and on my address table i would like to pull an plan number and have it also fill out the sqr ft column in my address table. So i do not have to worry about making sure i have correct numbers each time. Is it possible for me to pick a plan number and have other columns in address table be filled out automatically by what is in plan # tables?

Hello and welcome to PCHelpForum.

I have marked your thread as "Open" in readyness for the Tech Team and helpfull members to assist you.

JB.

I've re-read your post a few times and all I can say is:

The good news is that the answer to your question is yes. The bad news is that for anybody to help you design the Access Query they will need full details of your table structures and a system analysis of your requirement(s)

I can't see a quick fix in this type of forum.



Others in the forum may know better.

What about simple math? Will it add or multilpy numbers in two different columns in the same row?

Yes it will