OPENING MS ACCESS REPORT BASED ON DATES

Question

Hello am trying opening a report from a form based on the current record selected which is a date but it cant display the specified DATE record it only diplays all dates please help me with this.....?

THIS FORMULAR WORK WITH OTHER RECODE'S BUT NOT DATES
WHERE CONDITION: ="DATE_PAID=" & [DATE_PAID]
OR
VISUAL BASIC: DoCmd.OpenReport "TUTION_R", acViewPreview, , , , "DATE_PAID = " & Me.DATE_PAID

Answer 1

Merely delimiting the value of the control with hash characters will not work if your system short date format is not in US format. To ensure international consistency it is best to format the value in US format or an internationally unambiguous format such as the ISO standard for date notation of YYYY-MM-DD:

DoCmd.OpenReport "TUTION_R", acViewPreview, , , , "DATE_PAID = #" & Format(Me.DATE_PAID,"yyyy-mm-dd") & "#"

Another thing which might cause the report not to return the record is if the date/time values in the report include non-zero time of day elements. This might not be readily apparent from the data. If a column is only to include date values (i.e. with a zero time of day element) this should be enforced by a ValidationRule which only allows integer values. Any existing values can be corrected with an UPDATE query which updates the column to Int(Date_Paid).

Answer 2

Try:
VISUAL BASIC: DoCmd.OpenReport "TUTION_R", acViewPreview, , , , "DATE_PAID = #" & Me.DATE_PAID & "#"