Editable form from Query

B

bdehning

How does one set-up a form so that users could edit total information even if
multiple entries were made throughout a month?

I have tried but I end up with as many pages for a person as they had
entires. I would like each user to only see the totals for each month in
various fields so they could edi these totals if needed.

Help?
 
M

M.L. Sco Scofield

I'm afraid you are trying to treat Access like a spreadsheet.

Access, like all other databases, can total information in records for
display purposes only.

To change a total, you *must* edit the underlying data. That's the whole
point of a database. Integrity of the viewed answers.

If you want to disconnect the answers (totals) from the data that produced
them, export to Word or Excel and have at it.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
B

bdehning

Thank You. It is getting late and I lost my mind. I should have thought
about record entry and its purpose.

If they only had one entry for certain fields than those fields could be
edited as they would be the totals but not on multiple entries.
 
M

M.L. Sco Scofield

You're welcome.

BTW, if you haven't already, you might consider using a regular form for the
person with a subform on it for the detail. One screen for a person with a
lot of scrolling on the subform. Better than having to page through
individual records for the detail.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top