Saving a report

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Hello,

I would like to save a report every month.

I added a button to the form for which I open the report
with the action - "Report to File" But whenI open the
file it is empty...

What did I do wrong?

How can I save automatically every month?
 
Sharon

A couple clarifications...

Why? As is "what business need are you trying to satisfy by 'saving a
report every month'"?

And what? Are you saying that you want a paper copy of a report? The
ability to re-run a report for any given month's data? A "static" copy of
the report that was run (but not a paper copy)? A copy in something like
Word (although this would imply you could "alter history")?
 
Sorry, I am new in Access.
The thing is that in the main form I have a lot of fields
to update in the main table (I have 40 date fields and 40
text fields).

I tried to make a query that checks all those date
fields, but I recieved an error saying that it is too
long. Do you know how I can handle this?

About your question, from your answer it looks like this
is the best thing to do - re-run the report for any given
month's data. So, How can I do that?

Thanks a lot,
Sharon
 
Sharon

If your underlying table has "40 date fields and 40 text fields", your
database will probably benefit from some additional normalization. This
description suggests that you've committed spreadsheet on Access. A scan
through the tablesdbdesign newsgroup will reveal that a well-normalized
table rarely needs more than 30 or so fields.

Anytime you have repeating fields (date1, date2, ..., date40, text1, text2,
...., text 40), back up and look into normalizing.

I'd suggest looking at that before proceeding, as you will be making a LOT
more work for yourself if you try to use Access as if it were Excel. On the
other hand, is there a reason you don't just use Excel?!
 
Back
Top