[Simmy]

Hi,

I am doing a query to select wearers by size from a wearer table.
I need to display + or - a half size for each wearer i.e. if they are a size 7 then i need to display 6.5, 7, 7.5.

I am thinking and trying it with a case statement.
Would this be a good idea or is there ant better ways?

Thanx a lot.

Simmy.

[Advertisements]

Just loop through the returned recordset and add the half sizes to the return values.

If your recordset is rsSizes and the return column is sizes

SmallHalf = Cstr(Val(rsSizes("sizes").value)-1) & ".5"
RegularSize = rsSizes("sizes").value
LargeHalf = rsSizes("sizes").value & ".5"


You could actually even do this in the query. If your size is numeric

Select (Size-.5) as SmallSize, Size, (Size + .5) as LargeSize from tablename

Edited by Ctrl_Alt_Del, 08 July 2005 - 03:21 PM.

[Ctrl_Alt_Del]

Just loop through the returned recordset and add the half sizes to the return values.

If your recordset is rsSizes and the return column is sizes

SmallHalf = Cstr(Val(rsSizes("sizes").value)-1) & ".5"
RegularSize = rsSizes("sizes").value
LargeHalf = rsSizes("sizes").value & ".5"


You could actually even do this in the query. If your size is numeric

Select (Size-.5) as SmallSize, Size, (Size + .5) as LargeSize from tablename

Edited by Ctrl_Alt_Del, 08 July 2005 - 03:21 PM.