|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 15th, 2009, 04:35 PM
posted to microsoft.public.access
|
|||
|
|||
sort records
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)))) 
|
|
#2
January 15th, 2009, 05:26 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
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" wrote in message ... 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))))
|
|
#3
January 15th, 2009, 05:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
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. "Jeff Boyce" wrote: 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" wrote in message ... 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))))
|
|
#4
January 15th, 2009, 06:06 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
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? "salim wave" wrote in message ... 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. "Jeff Boyce" wrote: 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" wrote in message ... 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))))
|
|
#5
January 15th, 2009, 06:18 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
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, "Jeff Boyce" wrote: 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? "salim wave" wrote in message ... 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. "Jeff Boyce" wrote: 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" wrote in message ... 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))))
|
|
#6
January 15th, 2009, 06:37 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
Change all "," to ";" and try.
Looks to me a separator problem. - And Title is a field name on your query of course. rgds
|
|
#7
January 15th, 2009, 09:50 PM
posted to microsoft.public.access
|
|||
|
|||
|
sort records
On Thu, 15 Jan 2009 09:46:10 -0800, salim wave
wrote: 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. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
