name/value pair

[Simon Weaver]

Hi
I have a problem.

I am developing an on-line booking system based on a
Microsoft Access crosstab query. It work fine.

i.e. Rooms as rows, timeslots as columns.

Except the Crosstab value is a concatenated string of
which I only need part of. In Access we would say e.g.

Right([MyString,3]) - extracts the last 3 characters

The parameter value in FrontPage reads
<%=FP_FieldURL(fp_rs,"1")%>

Is it possible to extract only the last most character
from this string in FrontPage. And How??

TIA, Simon
Please help.

[Tom Pepper Willett]

The FP vba programming newsgroup has been discontinued. You may wish to
post in microsoft.public.frontpage.programming newsgorup
--
-----
Tom Pepper Willett
Microsoft MVP - FrontPage
----
"Simon Weaver" <***@msn.com> wrote in message news:027c01c368ec$276cd400$***@phx.gbl...
| Hi
| I have a problem.
|
| I am developing an on-line booking system based on a
| Microsoft Access crosstab query. It work fine.
|
| i.e. Rooms as rows, timeslots as columns.
|
| Except the Crosstab value is a concatenated string of
| which I only need part of. In Access we would say e.g.
|
| Right([MyString,3]) - extracts the last 3 characters
|
| The parameter value in FrontPage reads
| <%=FP_FieldURL(fp_rs,"1")%>
|
| Is it possible to extract only the last most character
| from this string in FrontPage. And How??
|
| TIA, Simon
| Please help.