If/Else statement

[rickyshah]

Hi All

I need help in writing an If or Else statement for the following data.

Have 2 variables (Store Number and Type):

Example of layout:
Store Number Type
123456789 R
123456789 S
987654321 S

What I want the statement to be able to do is if the storenumber has both a row with R and S, to pick the row with R. Alternatively if there is only one entry per storenumber like the 987654321 then to pick the type S for that.

Thanks in advance

Ricky

 

[SkipVought]

Ricky,

SELECT `Sheet3$`.`Store Number`, Min(`Sheet3$`.Type)
FROM `D:\My Documents\vba\RPT_Schedule-06_07_05`.`Sheet3$` `Sheet3$`
GROUP BY `Sheet3$`.`Store Number`

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[rickyshah]

Hi Skip,

Thanks for the tip, but is there a way to insert this in An access query in design view as I am not too familiar with SQL.

Thanks.

 

[rickyshah]

Hi Skip,

Don't worry think I've got it, used the MIN option when grouping the data.

Thanks.

Ricky