Calculated field with where clause within Query

[jaryszek]

Hi,



i want to add where clause to multiply 2 fields based on table:

Size 1 , Label GiB
Size 1, Label TiB

And now i want to get some field from query, for example [Field1]*[Size] Where Label = 'GiB'

How can i do it using builder in Access query?

Best,
Jacek

[isladogs]

GIB:Field1*Size

[jaryszek]

Hi ridders52,

this is not working. I am getting computed 2 computed values: GiB and TiB and i want to get only these one for GiB.

You simply multiplied Field1*Size by each Label. I want to multiply only by specific label,

Best,
Jacek

[isladogs]

Sorry - misread your post.
Is this what you want?

SELECT Table1.Field1, Table1.Size, Table1.Label, [Field1]*[Size] AS Expr1 FROM Table1
WHERE (((Table1.Label)='GIB'));

[jaryszek]

Hmm not exactly.

My query looks like:



It is not possible to do something within column GiB: MemorySizeGib * Size?

Best,
Jacek

[isladogs]

Why have you got ten tables in your query including a Cartesian join?
Is it read only?

Assuming your memorysizegib is what you called field, what you have is what I wrote in my first reply when I thought gib was a derived field name.
In my second reply I thought it was a record value in a field called 'label'.

I've now got no idea what you mean so little point guessing.
Suggest you post some sample records so I can see what you want. Hide any irrelevant fields