Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DLOOKUP of table from itself
Are you making your comparison against the same data type? If ID is long int field and facadj1 is text then that will cause an error. =DLookUp("[facid]", "FACILITIES", "[ID] = " & [facadj1]) =DLookUp("[facid]", "Facilities", "[ID] = "...- tzephon
- Post #6
- Forum: Microsoft: Access Reports
-
BLANK LINES IN NAME ADDRESS FIELD
You could use iif() to remove unwanted lines. =iif(isnull([ADDRESS1]),"", [ADDRESS1]& vbcr) & iif(isnull([ADDRESS2]),"", [ADDRESS2]&vbcr) Or you could use a small vba function that would be easier to read in your text box to replace the iif statement to do the same thing...- tzephon
- Post #5
- Forum: Microsoft: Access Reports
