sort records

[salim wave]

can some one tell me why is this expresion is not working , knowing i am new
to expresions

IIf([Title] = "Vice President, Sales", 1, IIf([Title] = "Sales Manager", 2,
IIf([Title] = "Sales Representative", 3, IIf([Title] = "Inside Sales
Coordinator", 4, 5))))

 

[Jeff Boyce]

I'm not sure what you mean when you say "not working"...

What is it that you expect it to do? Where are you using this expression?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[salim wave]

i am trying to sort recordes in a table acoording to custom order.. so i went
to Office help.. and i did exactley what help assisstance said.. plz see
Office help access " sort records in custom order' ... but i did all of that
but every time i try that expersion i get the following message
" you omitted an operand or operator, you enterd an invalid charcter or
comma, or text with no qutaion.

I'm not sure what you mean when you say "not working"...

What is it that you expect it to do? Where are you using this expression?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

can some one tell me why is this expresion is not working , knowing i am
new
to expresions

IIf([Title] = "Vice President, Sales", 1, IIf([Title] = "Sales Manager",
2,
IIf([Title] = "Sales Representative", 3, IIf([Title] = "Inside Sales
Coordinator", 4, 5))))

 

[Jeff Boyce]

Access tables store data, Access queries and forms (and reports) display
data.

If you want to sort data, do so using a query.

The error message you received suggests that something is missing from your
expression. Are you using that expression in a query, or are you trying to
use it directly in a table?

i am trying to sort recordes in a table acoording to custom order.. so i
went
to Office help.. and i did exactley what help assisstance said.. plz see
Office help access " sort records in custom order' ... but i did all of
that
but every time i try that expersion i get the following message
" you omitted an operand or operator, you enterd an invalid charcter or
comma, or text with no qutaion.

I'm not sure what you mean when you say "not working"...

What is it that you expect it to do? Where are you using this
expression?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

can some one tell me why is this expresion is not working , knowing i
am
new
to expresions

IIf([Title] = "Vice President, Sales", 1, IIf([Title] = "Sales
Manager",
2,
IIf([Title] = "Sales Representative", 3, IIf([Title] = "Inside Sales
Coordinator", 4, 5))))

 

[salim wave]

yes i am trying to use this on Query.. but i said before.. i got this from
access help if you just have a look @ access help " sort recorde in custom
order" plz,

Access tables store data, Access queries and forms (and reports) display
data.

If you want to sort data, do so using a query.

The error message you received suggests that something is missing from your
expression. Are you using that expression in a query, or are you trying to
use it directly in a table?

i am trying to sort recordes in a table acoording to custom order.. so i
went
to Office help.. and i did exactley what help assisstance said.. plz see
Office help access " sort records in custom order' ... but i did all of
that
but every time i try that expersion i get the following message
" you omitted an operand or operator, you enterd an invalid charcter or
comma, or text with no qutaion.

I'm not sure what you mean when you say "not working"...

What is it that you expect it to do? Where are you using this
expression?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP


can some one tell me why is this expresion is not working , knowing i
am
new
to expresions

IIf([Title] = "Vice President, Sales", 1, IIf([Title] = "Sales
Manager",
2,
IIf([Title] = "Sales Representative", 3, IIf([Title] = "Inside Sales
Coordinator", 4, 5))))

 

[rumkus]

Change all "," to ";" and try.
Looks to me a separator problem.
- And Title is a field name on your query of course.
rgds

 

[John W. Vinson]

i am trying to sort recordes in a table acoording to custom order.. so i went
to Office help.. and i did exactley what help assisstance said.. plz see
Office help access " sort records in custom order' ... but i did all of that
but every time i try that expersion i get the following message
" you omitted an operand or operator, you enterd an invalid charcter or
comma, or text with no qutaion.

There is an error in your Query.

We cannot see your query, so we cannot tell what the error might be.

Please open the Query in SQL view and copy and paste the SQL text to a message
here.