Reporting on fields in form not in table

[keiath]

Hi Guys



I have been automating my forms based on calculations, for example my Year end date now calculates my Account deadline date and notice date in the form automatically, this is great (thanks to Gina) as i no longer have to fill in these date fields, and of course no chance of mistakes.

The problem is I now need to produce a report base on the 3 fields as above, but when i run a report wizard of course it only gives me tables and queries, so now do I make this report?

Thanks

[ItsMe]

Can you post some of the code you use in your form?

[ssanfu]

produce a report base on the 3 fields as above

What do you mean "report based on the 3 fields".

You want to use the 3 date fields as criteria?
Or just have them on the report (in the report header)?

[keiath]

Hi Steve

I need to produce a report like this:-

Site No Name of Site Yearend Date Deadline Date Sec20b Date

0002S Old Brompton Road 31/12/2014 31/05/2015 30/06/2014

The later two dates are calculated in the form and therefore atm not stored (always told storing calculated fields is bad practice)

the code used in the later two in the forms is =DateAdd("m",5,[S Charge Y/E Date]) =DateAdd("m",6,[S Charge Y/E Date]) repectivtly

[June7]

Do the same calcs in textboxes on the report or in the query the report is based on.

[keiath]

Thank you I had a sneaky suspicion it was going to be that, should try before i ask i guess!

[June7]

Trying never hurts!