Search results

Thank You so much for that recommendation. I agree that is a much better use of the table. I have made the suggested change to my table. It is now titled "Medicare Fee Schedule_NON FACILITY" and I added a column for the Fee Schedule Year (i.e 2017, 2018, etc) How does this change to the...

Do you have any suggestions or recommendations as to structuring my tables more efficiently? Thanks!

It is formatted as currency and default value set to 0 but still displays nothing. :confused: Do I need to add something to the formula to account for null values?

Yes, this table comes from an outside source and will change yearly. When I imported the data in Access, I did so as a linked Excel file so that changes made to that file are reflected in the table. Do you know of a better method to do this? I'm trying to integrate some of the things we do...

Thank You so much for your quick help. That solved my error. Now what's happening is on records where [CD1] is blank the text box with Dlookup is showing no value. I would prefer it to display $0 if [CD1] is blank.

Hi, new to the forum and fairly new to Access. Thanks for taking the time to help me on this issue. I've been searching and searching and cannot figure it out alone. :banghead: I have a form with a text box control where I am trying to perform Dlookup function. This is what I put in the...