I discovered once I deleted the heading from my table the formulas worked. Is there a way to automatically delete the first 2 rows of a spreadsheet? Or another way to go about that issue?
I discovered once I deleted the heading from my table the formulas worked. Is there a way to automatically delete the first 2 rows of a spreadsheet? Or another way to go about that issue?
How is the data getting into this table?
It's the first mention of a spreadsheet in the thread, so are you not giving us the whole picture here?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
No kidding, and it only took 16 posts to learn that.It's the first mention of a spreadsheet in the thread,
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.