Please Help!!!!!!!!!!

[lee_morgan]

Hi guys/gals from a Newbie

I have a problem with a university project. I have to convert a paper system into an electronic one. Basically the Doctor inputs a series of about 40 yes/no questions. (I've done this in a series of forms) however I want the info from these forms to be included in referrral form to be sent to the ante-natal department at the hospital.
The form being sent needs to include the info submitted into the forms. when I have tried to create a a report it won't let me as it says it includes too many fields!!

Any help would be most appreciated.


Lee

 

[The_Doc_Man]

"Too many fields" is a very rare message that I didn't think you could ever generate on a report. Are you sure it isn't in a query that causes the message? Or did you attempt to create the report with the query wizard and let it generate its own internal SQL? Query wizards can often have limits that Access itself does not have.

Forty yes/no fields is, to be blunt about it, chump-change for Access reports and queries. The result might be awfully ugly, but it is still chump-change. I think we might need a bit more information to fully diagnose this particular problem.

Take it up a notch. Tell us as concisely as possible what approach you are taking to define the contents of the report. Tell us (by manually counting, if necessary) how many controls exist on the report when in design view.

 

[lee_morgan]

Will do, thanks

 

[The_Doc_Man]

Good point, Pat. I have many other foibles, but forgetting to compact my DB on a schedule isn't one of them. Which is probably why I've never seen this problem.

Advice to Lee Morgan: Make it a habit to copy your DB to a safe folder, then repair it and compact it in place. If either action fails, you still have the original. But if both succeed, replace the copy with a new copy that becomes a good, clean (relatively clean) backup of the repaired, compressed DB. This is a very good habit to learn.

As Pat points out, this gets rid of lots of problems all at once just by tossing out the trash. Which, in any file, cannot always be a bad thing.