Hello all,
So I'm pretty new to access, and I'm pulling my hair out trying to get this to work.
I have data in tables, and I have a form connected to that data, so when the form is filled out, the table fills in.
From said data, I have a query that calculates some "other data".
I would like to display this "other data" in my form (which I will lock and grey out to prevent editing, just so the user can see the end result of what he is inputting).
I have tried using DLookup, but it only gives me a single value back for all of my records. I'm not sure if theres something I am missing with my relationships either.
Please haalp! and thank you in advance