Search results

georgedwilkinson, thanks. I'll look for cascading (though I thought it is for a form not a table, I wanted to have this dependency in table for selection of entries). yes this is just an example. Don't see the problem if it would have been a real problem without simplification :) Actually the...

Oh, I see..., I tried but didn't use decimal, because it truncated the entry. Yep, 'scale' solves the issue.

Hi, guys, Have been trying different approaches literally the whole day on Saturday. Nothing else comes into my mind. Need your help. I have 2 tables: Table 1: CATEGORY : SUB-CAT Computer : Motherboard Computer : CPU Car : tires Car : wheel Table 2: 2 Fields as Combobox or List Box...

Thanks guys for your responses. @Bob, that adds a currency sign. Don't want to see it. Strangely it is happening just for one sum (aggregated month data). Other sums (other months) through month were fine. I did it with Properties choose Fixed from the Format list. (thx to huilmn) Well, will...

jal, thanks, for a reply I have tried Double - same story. The thing is that I indicate already that it should be 2 decimals (2nd screen shot). Of course I could do SELECT Format(Sum([sum]),"0.00") AS sssum FROM Appended; But I do not think it a good solution because it would mean that I need...

This is really something, has never happened to me in Access 2003. Now among some other things in 2007 this really bothers me: There is a table with number which have 2 digits after decimal point. Query calculates the sum of the sum of this column. Somehow I am getting more digits. :eek: Table...