DLookup Seperate Lines

[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)

 

[Dirk Goldgar]

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)

How about:

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

?

 

[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)

How about:

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

?

Dirk,
That did it.
Thank You
DS