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,
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,