X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Dlookup, Access 2016    
post Oct 19 2019, 12:30 PM

UtterAccess VIP
Posts: 14,018
Joined: 6-June 05
From: Dunbar,Scotland

Hi Everyone

The following DLookup is returning no value when it should return one.

Can anyone spot where I am wrong?

Any help appreciated

=DLookUp("Balance","tblStudentFeeCollection","[StudentID] = " & [StudentID] And [MonthID]=" & [MonthID] & ")

Hope this helps?


Get happiness out of your work or you may never know what happiness is.

Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    5th July 2020 - 12:38 PM