A Al Campagna Mar 22, 2010 #2 Mark, First, change the names of those fields. Avoid spaces in names. (if you do have a name with spaces, make sure you always bracket... ex. [Billed Amount]) When in doubt... bracket. Avoid Access reserved words, and special characters. The $ designates a string in Access, and should be avoided used in object names. [Billed] - [Paid] = [Saving] -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
Mark, First, change the names of those fields. Avoid spaces in names. (if you do have a name with spaces, make sure you always bracket... ex. [Billed Amount]) When in doubt... bracket. Avoid Access reserved words, and special characters. The $ designates a string in Access, and should be avoided used in object names. [Billed] - [Paid] = [Saving] -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
J Jerry Whittle Mar 22, 2010 #3 In a query: Saving $: [Billed $] - [Paid $] Make sure that the two fields within the brackets are spelled properly.
In a query: Saving $: [Billed $] - [Paid $] Make sure that the two fields within the brackets are spelled properly.
