DATE FIELDS IN REPORTS

[Guest]

I have 3 date fields in my table,
one of which generates the dates for the other two fields. First date field
is "DOA" (date of accident) other 2 are "Statutedate"
(IIf([Type_of_Claim]="Goverment Claim",[DOA]+180,[DOA]+365) and
"Statutedate1" (=IIf([Type_of_Claim]="Goverment Claim",[DOA]+270,Null)
The data from statutedate & statutedate1 depends if its a Goverment claim or
non gov claim.
I have a form that displays
the fields fine when I input data I can see it in "from view" or "datasheet"
view but when I try and print a hard copy REPORT, it doesn not show
Statutedate or Statutedate1. Everything else shows up in the report. It
shows older records that have already been inputed. But these records I got
from a delimited dump and imported them into Access.
Any help would be
appreciated. Thank You, James

 

[Bill]

James,
It might help us if you post the SQL statements that
define the Report's underlying RecordSource. Be
sure to check the Report's text box controls versus
the fields you want.
Bill

 

[Bill]

Also, James, look at the Format property for the
text box controls for the dates.

Bill

 

[Guest]

Bill,
Ok I'm a novice in Access not sure just what you need? The report
design has Lname, Fname, att. ini, Caseno, Statutedate, statutedate1, status
I do a preview and it shows everything except statutedate & statutedate1.

James,
It might help us if you post the SQL statements that
define the Report's underlying RecordSource. Be
sure to check the Report's text box controls versus
the fields you want.
Bill

I have 3 date fields in my
table,
one of which generates the dates for the other two fields. First date
field
is "DOA" (date of accident) other 2 are "Statutedate"
(IIf([Type_of_Claim]="Goverment Claim",[DOA]+180,[DOA]+365) and
"Statutedate1" (=IIf([Type_of_Claim]="Goverment Claim",[DOA]+270,Null)
The data from statutedate & statutedate1 depends if its a Goverment claim
or
non gov claim.
I have a form that displays
the fields fine when I input data I can see it in "from view" or
"datasheet"
view but when I try and print a hard copy REPORT, it doesn not show
Statutedate or Statutedate1. Everything else shows up in the report. It
shows older records that have already been inputed. But these records I
got
from a delimited dump and imported them into Access.
Any help would be
appreciated. Thank You, James

 

[Bill]

When you created the report, what did you specify as
the data source for the report? A table? A query?

Test yourself by opening the report in design view and
investigate the text box controls for the date fields that
fail to display.

If you don't find a text box that is bound to the date
field(s) then there lies your problem. If you find bound
text boxes for the date fields, then investigate the
recordsource for the report.

From your original description, it may be that the calculated
dates never in fact were saved into the table.

Bill

Bill,
Ok I'm a novice in Access not sure just what you need? The report
design has Lname, Fname, att. ini, Caseno, Statutedate, statutedate1,
status
I do a preview and it shows everything except statutedate & statutedate1.

James,
It might help us if you post the SQL statements that
define the Report's underlying RecordSource. Be
sure to check the Report's text box controls versus
the fields you want.
Bill

I have 3 date fields in my
table,
one of which generates the dates for the other two fields. First date
field
is "DOA" (date of accident) other 2 are "Statutedate"
(IIf([Type_of_Claim]="Goverment Claim",[DOA]+180,[DOA]+365) and
"Statutedate1" (=IIf([Type_of_Claim]="Goverment Claim",[DOA]+270,Null)
The data from statutedate & statutedate1 depends if its a Goverment
claim
or
non gov claim.
I have a form that
displays
the fields fine when I input data I can see it in "from view" or
"datasheet"
view but when I try and print a hard copy REPORT, it doesn not show
Statutedate or Statutedate1. Everything else shows up in the report.
It
shows older records that have already been inputed. But these records I
got
from a delimited dump and imported them into Access.
Any help would be
appreciated. Thank You, James

 

[Guest]

Bill
Can you expand on your last 2 post. Like I said I'm a beginner using
Access

(Test yourself by opening the report in design view and
investigate the text box controls for the date fields that
fail to display.

If you don't find a text box that is bound to the date
field(s) then there lies your problem. If you find bound
text boxes for the date fields, then investigate the
recordsource for the report.)

Also, James, look at the Format property for the
text box controls for the dates.

Bill

I have 3 date fields in my
table,
one of which generates the dates for the other two fields. First date
field
is "DOA" (date of accident) other 2 are "Statutedate"
(IIf([Type_of_Claim]="Goverment Claim",[DOA]+180,[DOA]+365) and
"Statutedate1" (=IIf([Type_of_Claim]="Goverment Claim",[DOA]+270,Null)
The data from statutedate & statutedate1 depends if its a Goverment claim
or
non gov claim.
I have a form that displays
the fields fine when I input data I can see it in "from view" or
"datasheet"
view but when I try and print a hard copy REPORT, it doesn not show
Statutedate or Statutedate1. Everything else shows up in the report. It
shows older records that have already been inputed. But these records I
got
from a delimited dump and imported them into Access.
Any help would be
appreciated. Thank You, James