Fail to display textbox based on query parameter onto Data Acces Page

smyeong

Registered User.
Local time
Tomorrow, 00:08
Joined
Mar 17, 2003
Messages
27
Hi all, i still have another problem which is related to Access Query parameter ' Between [Pdate1] And [Pdate2] '
When i converted it to DataAccessPage, it succeeded and came up with parameter box asking Pdate1 and Pdate2.
But, when i create a textbox on the DataAccessPage to remark the date range for the page header , i put in ="From " & [PDate1] & " to " & [PDate2]
it failed to display the required date. But when i put in ="From " & DateSerial(Year(Date()),Month(Date())-1,1) & "to " & DateSerial(Year(Date()),Month(Date()),0)
it succeeded.

Was this something related to ANSI-92 SQL syntax ?

Pls help out.

Thanks in advance,
 

Users who are viewing this thread

Back
Top Bottom