popo725
Last Activity: Sep 23 '08, 05:46 PM
Joined: Sep 19 '08
Location:
-
Thanks for the pointers - will test it out. =) -
I finally figured out the way to change the 'fieldsize' but confirmed that the existing setting for 'number' is already preset as 'Long Integer'. Any suggestions of what to look for next?Leave a comment:
-
Thanks for this - I have been checking a number of blogs on resolving this issue and would like ask to make such conversion, do I need to put 'CLng' in front of the syntax expression that calculates the YTD number?
Many thanks....Leave a comment:
-
Thanks Fish. I am a newbie to Access and the biggest challenge is I am not the creator of this database and therefore, don't have a clue what these syntax expressions mean. Per your instruction, can you provide some pointers using the query I copied in the enquiry to start off the self-checking process?
Many thanks....Leave a comment:
-
Problem with Overflow error message in Access
Hi,
I'm new at using Microsoft Access (2003), and I've created a "MonthlyRep ort" query, which has functioned properly in the past and I update the table monthly as I update the data in the underlying table and query files. All the query does is to run some calculations from data inputed every month, and it aggregates the results of those calculations in the report.
I tried to run or display the report under...
No activity results to display
Leave a comment: