G
Guest
Hi,
I am trying to use the dfirst function to pick the first description of
a particular date. e.g first instance where the description 'NEF Grant'
appears on the 04.06.07.
I have built this which doesn't seem to work.
=DFirst("[Id]","[Invoice Items]","[Description]='" & [Forms]![Weekly Child
View]![Description] & "' AND [Child ID]=" & [Forms]![Children
List].[Form]![Child ID] & " AND [Date]=#" & [Forms]![Weekly Child
View]![ChangeDate] & "#")
the text box appears blank although there is data to be displayed. At first
there wasn't an equals sign at the beginnig, hence showing 'name?#' but now
shows blank.
Any idea where I am going wrong?
Any help would be appreciated.
Thanks in advance.
I am trying to use the dfirst function to pick the first description of
a particular date. e.g first instance where the description 'NEF Grant'
appears on the 04.06.07.
I have built this which doesn't seem to work.
=DFirst("[Id]","[Invoice Items]","[Description]='" & [Forms]![Weekly Child
View]![Description] & "' AND [Child ID]=" & [Forms]![Children
List].[Form]![Child ID] & " AND [Date]=#" & [Forms]![Weekly Child
View]![ChangeDate] & "#")
the text box appears blank although there is data to be displayed. At first
there wasn't an equals sign at the beginnig, hence showing 'name?#' but now
shows blank.
Any idea where I am going wrong?
Any help would be appreciated.
Thanks in advance.