Year 12s: what will be the first way you research your future options? >>

Forums
Access Help needed!!

This discussion is now closed.

Check out other Related discussions

do unis care
[Request] Need Assistance Accessing an IbisWorld Report for University Project
Career help needed.
GCSES and Access to HE
distance learning centre
Access Course Equipment
can I still have access to uni's libary resources after interrupting studies?
College Access Course
Access to HE/Medicine
I achieved 45 Distinctions in an Access course with the DistanceLearningCentre. AMA!
Access course
Access to HE - to study Dietetics
A-levels or access course? To get into university
7 Tips for Studying Abroad with Disabilities
Kings College London access course
Possible to work part time and achieve distinctions on access course?
Which access course is the most versatile?
Edexcel A2 Biology Mind Maps For All Units/Topics
wanting to get back into education
Should I study an access course? (Very important question pls answer ASAP)

Access Help needed!!

I am trying to do an iif statement in a query and I think it needs to be an AND iif. When I write it it comes up saying poor syntax and highlights the AND.

Does anyone know the correct syntax i am doing
iif(AND >10,[Price]<20,"Ok","No")

Thanks

Reply 1

teachercol

'And' works slightly differently in Access to Excel....it can only join Boolean expressions

iif(>10 AND [Price]<20, "OK","NO")

Thank you thank you for your reply it has saved me hours!!!

Reply 4

teachercol

Related discussions

do unis care
[Request] Need Assistance Accessing an IbisWorld Report for University Project
Career help needed.
GCSES and Access to HE
distance learning centre
Access Course Equipment
can I still have access to uni's libary resources after interrupting studies?
College Access Course
Access to HE/Medicine
I achieved 45 Distinctions in an Access course with the DistanceLearningCentre. AMA!
Access course
Access to HE - to study Dietetics
A-levels or access course? To get into university
7 Tips for Studying Abroad with Disabilities
Kings College London access course
Possible to work part time and achieve distinctions on access course?
Which access course is the most versatile?
Edexcel A2 Biology Mind Maps For All Units/Topics
wanting to get back into education
Should I study an access course? (Very important question pls answer ASAP)