Solved

Expression "VAR-Rnd()-PCT" in Access 2000

Posted on 2011-03-25
2
317 Views
Last Modified: 2012-05-11
Do you know  by any chance

What is the purpose of  "VAR-Rnd()-PCT" in Access 2000.

We named one field "VAR-RND-PCT" in Access 2000 table  However starting 3/11 this expression caused us problems.

In order to fix I have to rename field to something else.  However, what is the purpose of this expression.  Why it is giving us problems, but we did not have problems before
0
Comment
Question by:maximyshka
2 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 300 total points
ID: 35219464
Using 'strange' characters like - in an Access name is bound to cause problems.  Using names of Access functions like Rnd() is definitely error bound.  Using them together is a headache - which you have done.  It might be wise to have a look at:

http://www.acc-technology.com/namconv.htm
0
 
LVL 11

Assisted Solution

by:donaldmaloney
donaldmaloney earned 200 total points
ID: 35219509
Looking at it, it looks like access thinks you are using the function rnd() in an expression.
especially since you have -  (minus signs) in it
Using any function names in access could cause a problem since access will break the names apart in vb code and think that you are doing math with the field names.
If you are going to use something like this and have to then maybe change the name to VAR_RND_PCT,  this way there is no math and the field wil be sen as all text.
Don
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
type of query 11 42
A Function to parse a text string 4 36
Delete QueryDef IF it Exists: Access VBA 5 34
ms access vba split-screen form needs to be refreshed on load 7 31
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question