Blank notes field in Query2 - Microsoft Access Expert 11


	Back to Access Expert 11 Comments List

Upload Images Link Email

Blank notes field in Query2

Callum Stuart

2 years ago

Expert 11 Lesson 5, T 4:50 ish
Access 2016 on Win10

When I run MostRecentContact2Q, my notes fields are blank where they should have text from the ContactT Notes field. Interestingly I get the correct #Error stamps in the correct fields, so it's reading that fields are null or not, and the IIF statement works to change the text, I just cannot find a reason why it wont display. I have triple checked my DLookUPs and expressions for errors. I should say that this is also a fresh database downloaded from lesson 9, it's not one I have played around with, so I can only assume it is something to do with my client settings? Possibly the RichText throwing a spanner in the works? I tried change the format to PlainText though but that didn't work.

	Kevin Robertson 2 years ago
What is the exact expression you are using?

	Callum Stuart OP 2 years ago
ContactNotes: IIF(IsNull(MaxOfDateTime),"No Contacts",DLookUp("Notes","ContactT","CustomerID=" & [CustomerID] & " AND DateTime=#" & [MaxOfDateTime] & "#"))

	Callum Stuart OP 2 years ago
Should probably say also that I downloaded the lesson 11 database and that has the same anomaly.

	Richard Rost 2 years ago
I just downloaded the database myself, and it works fine for me. I see you're in the UK. Must be a regional date/time setting issue. This is why I recently switched everything I do to the ISO date format, and will in the future when I re-record these videos. SO many problems. Kevin, what do you get when you download the database file?

	Kevin Robertson 2 years ago
I'm using ISO as well. Before switching I had lots of problems with the date format.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 11.