Search results

No those four fields aren't teh ones it is [Roll No] [Assessment] [Class] and the fourth one was the sum of assessment if the roll no and class matches. In regards to the first bit of code you put there if I remove it, I get an error?

LOL okay well now I can see what is going on a bit better I was trying to do that but had no clue what was going on :p I am so lost with this stuff. Also that code must have all been created by Access because I only used the "Field" part of the query to enter formulas.

Here is what I am seeing in SQL view: SELECT [Combined Grantable & Taxable].[Roll No], Sum([Combined Grantable & Taxable].Assessment) AS SumOfAssessment, [Combined Grantable & Taxable].Corporation, [Combined Grantable & Taxable].Class, [2007TaxRates].Code, [City WideR]+[Cons...

There is alot of code in the SQL view already how do I know where to add this to? The Select From and Group By are all there but I can't follow it not sure if the first item in Select has to match the first item in the From and Group by areas how does that work?

Ha your going to have to bear with me I have no idea what to do with that. I recently discovered how to do this: Distributed PIL: Sum([city wide]+[cons area]+[police]+[urban fire]+[rural fire]+[urban transit]+[rural transit]+[para transit]+[education$]+[fire supply]) So is that considered a...

Where woud I put that in column 4?

I can't open it, I am using A97 :rolleyes: Is there a way of doing this without using a macro? How would you just say iif row1 column 1 = row 2 column 1 then add the next column?

Column A Column B Column C Column D 1*010101001000000 CF 5 010101002000000 RF 010101002000000 RF 010101029000000 CU 1*010101001000000 CF 10 010101351010000 RF 2*010101354000000 CF 11 2*010101354000000 CF 13 010101358000000 CY...

Ya I will have to do it this way. It is irritating that I couldn't figure it out in the query though :p Thanks very much for your help!

I have narrowed it down further: Expr1: Format(Sum([city wide]+[pol]+[urban f]+[rural f]+[urban t]+[rural t]+[para t]+[education$]+[fir s]),"Currency") Whatever is the second to be added in this formula can't be formatted, so in this example if I format [pol] to currency the formula won't work...

Samples of problems I am having: City Wide: Format([Assessment]*[City WideR],"Currency") - GROUP BY Cons Area: Format([Assessment]*[Cons AreaR],"Currency") - GROUP BY Expr1: Format([city wide]+[cons area],"Currency") - Expression works without messages but puts both city wide and cons area...

Both are set to Double, and formatted as currency and percentage.

If I use this: City Wide: Format([Assessment]*[City WideR],"Currency") & Cons Area: Format([Assessment]*[Cons AreaR],"Currency") and try and sum those two columns by using this: Expr1: [City Wide]+[Cons Area] It says enter perimiter value for City Wide and Cons Area. I just say okay okay and...

I removed the $ character still doesn't format to the right, I am using Access 97 :rolleyes: Is it possible using the Format function for currency in a query just doesn't have that feature? Or is there anything else you can thing of? Thanks!

Does anyone know why it doesn't align to the right when using the format function?

Why wouldn't the query right align this: City Wide $: Format([Assessment]*[City Wide],"Currency") If it is formatted as Currency should it not be aligned to the right? Thanks again :D

Okay its these relationships that I dont' understand, I see what your saying once you create a relationship to the codes between the two tables. But how do you know when to use what type of relationship and what does "Enforce Referential Integrity" mean? Thanks!

The C-rate is dependent on teh class so if the Cat is the FG class how would I put the associated c-rate in another column beside that...i don't know how to do that either thats why I was using d-lookup?

I guess it should be something like this but I still can't get it to work: Dlookup "[Class]","Table1" or should this be table two I don't understand how you connect the two columns so it refers to the proper column in the other table?

in a query