DLookup Seperate Lines

D

DS

How do I break this into seperate lines, I'm trying but I can't seem to
get it.
Thanks
DS

Nz(DLookup("[PriceID]", "[MenuDetails]", "TerminalID = " &
Me.TxtPStation & "And StartDay = " & Me.TxtPDay & " And MenuID = " &
Me.TxtPMenu & ""), 0)

Nz(DLookup("[PriceID]", "[MenuDetails]",
"TerminalID = " & Me.TxtPStation & "
And StartDay = " & Me.TxtPDay & "
And MenuID = " & Me.TxtPMenu & ""), 0)
 
D

Dirk Goldgar

DS said:
How do I break this into seperate lines, I'm trying but I can't seem
to get it.
Thanks
DS

Nz(DLookup("[PriceID]", "[MenuDetails]", "TerminalID = " &
Me.TxtPStation & "And StartDay = " & Me.TxtPDay & " And MenuID = " &
Me.TxtPMenu & ""), 0)

Nz(DLookup("[PriceID]", "[MenuDetails]",
"TerminalID = " & Me.TxtPStation & "
And StartDay = " & Me.TxtPDay & "
And MenuID = " & Me.TxtPMenu & ""), 0)
Click to expand...

How about:

Nz(DLookup("[PriceID]", "[MenuDetails]", _
"TerminalID = " & Me.TxtPStation & _
" And StartDay = " & Me.TxtPDay & _
" And MenuID = " & Me.TxtPMenu), 0)

?
 
D

DS

Dirk said:
How do I break this into seperate lines, I'm trying but I can't seem
to get it.
Thanks
DS

Nz(DLookup("[PriceID]", "[MenuDetails]", "TerminalID = " &
Me.TxtPStation & "And StartDay = " & Me.TxtPDay & " And MenuID = " &
Me.TxtPMenu & ""), 0)

Nz(DLookup("[PriceID]", "[MenuDetails]",
"TerminalID = " & Me.TxtPStation & "
And StartDay = " & Me.TxtPDay & "
And MenuID = " & Me.TxtPMenu & ""), 0)
Click to expand...


How about:

Nz(DLookup("[PriceID]", "[MenuDetails]", _
"TerminalID = " & Me.TxtPStation & _
" And StartDay = " & Me.TxtPDay & _
" And MenuID = " & Me.TxtPMenu), 0)

?
Click to expand...
Dirk,
That did it.
Thank You
DS
 
Top