DATE FIELDS IN REPORTS

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

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

Bill said:
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

MebeJames said:
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
Click to expand...
Click to expand...
 
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


MebeJames said:
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.

Bill said:
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

MebeJames said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.)


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

Bill




MebeJames said:
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
Click to expand...
Click to expand...
 
Back
Top