I have created an DataAccessPage but all numbers carry over from my source tables unformatted. I can use the =CCur() function in the control source to format currancy. I also have incorporated FormatNumber() and FormatPercent() for other number formats needed. However, when I try to open the...
At work I have Access 97 and at home Access 2000. Obviously Access will convert a 97 file to a 2000 file automatically -- but how can I convert from a 2000 file back to 97 so I can work at home? Thanks in advance. Jim
Is there a way to run a query to limit the number of Grouped records in a query to 12. I work in real estate and have 100+ different properties. each month I enter financial statements for each property and some properties may have 40 or more records. I need to run calculations on a each...
Novice user trying to write somewhat simple code but I can not get the program to run. I want to group records by a common "Control Number" then populate a running total for each Control Number in a field called RecordCount. Some "Control Numbers" may have 18 records and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.