Using decimal points in text 1.2.3

[dichotomous2013]

Made an access data base for our company policies and procedures.



Fields are:

Section
Section Title
Policy
Explanation
Related Documents - (hyperlink field)

Running a query on the table for the report the delivers the policy.

the Section Field is Rich Text - this is the only way I can figure out how to display decimal point divisions like, 1.1.0, or 6.5.3 (for relevant sections).

Query won't return anything when I set a parameter on Section Feild and I suspect it's because of the Rich Text issue. I've tried smart tag but no avail.

I'm open to suggestions here.

Help????


And the next thing I want to do is have an index that gives me Section and Section Title with a go to. How best to achieve that???

[June7]

A normal text field should have no problem with values like 1.1.0.

Don't quite understand your last question but maybe this will give you idea http://datapigtechnologies.com/flash...earchform.html

[dichotomous2013]

Ok, lets deal with the first issue first.

My parameter query wont return anything. If I enter 1.1.1 for the relevant section of the policy, I get no record. And, in the table, the Feild name Section clearly lists the numerical divisions. 6.1.3, or 1.0, or 1.1.1.

do you not understand my question??

What is wrong with my parameter query, or the field settings that the query wont return a value like this. there will be no point me setting up the DB if I can't search based on the numerical value of the relevant policy.

Please help.

[June7]

I tested this data and the query works just fine.

Is the parameter dynamic or hardcoded in the query criteria? If dynamic, how is the value input?

I tested with hardcode and input prompt, both worked.

If you want to provide db for analysis, follow instructions at bottom of my post.