Two digit day only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Query 1 has some code that calculates a due date - Date:
IIf([tr.....[ReceivedDate]+30).

Query 2 has only "Date" from query 1.

I create a report with query 1 and the dates are fine.

I use that report as a sub report and it only shows dates that had a two
digit date.
Example: 12/23/07 would carry over fine, but 12/04/07 does not display on
the report when used as a sub report.

I am posting this question to both sobjects Reports and queries because I'm
not sure which are to solve the issue.

Thank you
 
If the subreport is linked to the main report by the date field, there may
be a time as well as a date in the field. If so (even if suppressed by the
Format), the values won't match, so the subreport won't show the records.

Alternatively, Access may be misunderstanding the data type of the
calculated field, and therefore performing a text match instead of a date
match. Wrapping the calculation in CVDate() could solve that. Details:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Back
Top