Hi David, what if the number contain in that field "Money Given" is a text instead of number....and there are other field other then this two. Ask this because the system prompt me that there is and aggregate error ...something about data type.....is there a way to change text to numbers?........
if the column name is [money given] why would it be defined as text?
either its money given or its not. I would suggest you chaneg the data type of the underlying column in the table to a numeric value - currency for preference.
David C might be being a little 'frisky' in suggesting CINT, you would probably be better off using the currency conversion CCUR, unless of course you donations are always integer.
incidentally I'd also suggest that you dont use a space in column names, ie
"money given" should become "moneygiven" or "MoneyGiven", or give it an even clear name eg "Donation"
the reason? it gets rid of the need to enclise column names with square brackets eg [Money Given]
You can separate words with the underscore character but that cause problems with other SQL back ends such as SQL Server. AS a consequcne I'd suggest get in some good habits early.
hey hey sorry for the trouble...dudes...take it easy..the example above is not the actual thing i'm doing...just an illustration. Basically i'm transfering all these datas from excel and those idiots mess up all the datatype and fields in the excel sheet. My job didn't have much a choice but to except those mess and convert them into a working database. Anyway both of you i right...i just need some advice because i quite new to access and are draining all my brain cell to start learning. Thanks for all your advice i value them very much.