UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Dlookup, Access 2016    
 
   
mike60smart
post Oct 19 2019, 12:30 PM
Post#1


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?

Mike

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