Crosstab Query 2

[TriniGal]

Hello,

I have a crosstab query showing the amount of new units recorded on a montly basis. I have the following code to show it:

Expr1: Format([L_FOUND],"mmm")

Does anyone know how I would change this to show new units recorded bi-weekly?

Thanks.

 

[PHV]

You may try this:
Expr1: Format([L_FOUND],"ww")\2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Perhaps:

Format(Format([L_FOUND],"ww")/2,"00")

 

[TriniGal]

Hello,

I thank you for your quick responses. I neglected to mention that this is a Date/Time field. I am getting a "Type mismatched Error". I'm not sure what I should do now. Any suggestions?

 

[PHV]

Perhaps this ?
Expr1: Format(Val(Format([L_FOUND],"ww"))\2,"00")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TriniGal]

Before I try to do this would you mind telling me what the "ww" is please? I like to know what I'm doing and for future reference.

 

[Remou]

ww = format week.

When I tested, \2 returned 0 for week 1.

 

[PHV]

Week number.
Tip: press the F1 key with the cursor insid the Format word.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TriniGal]

Thank you both so much for all your help. It worked.

 

[PHV]

When I tested, \2 returned 0 for week 1
OOps, sorry.
what about this ?
Format((1+Val(Format([L_FOUND],"ww")))\2,"00"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886