Cadavre,

Help! 🙂

Cadavre:

Could you please give me an example!

I tried to search google but I don't find what I need.

I see the TRANSFORM statement and tried to use it but I think...

Cadavre:

Is their any other way,

the computer hanged-out

due to many IIF.

I think their are other ways,

help!

🙂

Cadavre:

Thanks, I actually tried nested IIF but when I try

to run the statement the computer stocked-up.

So maybe using AND instead of multi IIF would

make a difference.

Will give you feedback...

Chrissy321,

Yeah, Case doesn't work in Access. Anyway any idea using

IIF. Kindly read my sample table and desired output specifications.

Salamat! (Filipino way of saying Thanks)

🙂

Thanks Cadavre:

I need a statement that will view the Item per category.

All barcodes that starts with M and D are regular items,

otherwise barcodes that starts with A and B are...

@ derek.colley

I will always bear in mind all your suggestions Derek.

Advance merry Christmas bro!

Maraming salamat! (Filipino way of saying Thank you very much)

derek.colley,

Probably, your suggestion is not working

in Access, any more suggestion?

Will wait, thanks! 🙂

Tom:

I did try to run it on Access, no error but still the

values is not correct. I don't know what to do.

I know you're a busy man but can you...

@tom Brown

Thanks for the suggestion.

I tried but it's not working in Access, hope you could give me other

options. Simplified statements will be greatly appreciated.

Will wait for you then....

Raunak,

Thanks for the suggestion.

I tried to run your suggestion, no error but the figure is incorrect.

I'm hoping that you could give me other suggestions!

Will wait then.

Salamat! (Filipino way of...

Tom,

Yeah, not possible I guess that's why I get error message.

Anyway Tom, any suggestion in the problem I'm having to get the correct result?

Will wait for your cool ideas.

Maraming...

Glad to know that you're also a Filipino?

Are you here in Manila?

Any FB account or YM?

Hope we could meet sometime and have some cold beer, haha!

🙂

Salamat 🙂

Yeah thru Google I found out that Access doesn't support CASE WHEN statement,

I tried your new suggestion and to my amazement it works really well. Perfect bro! Thanks! Maraming salamat!...