Re: Lpad in Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You have to write a VBA function, and then call that function from your
query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"DonnaA" <DonnaA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B2F615CE-BB5D-4EA5-8D44-507C96CB6A04@xxxxxxxxxxxxxxxx
So is there an equivalent for Access? I'd already found some references
via
Google but they involved scripting functions, not queries.


"raskew via AccessMonster.com" wrote:

Did a google on 'lPad'. It's an Oracle function.

Bob

DonnaA wrote:
lpad ('string', n [, 'string_pad')
rpad ('string', n [, 'string_pad')

string is left padded to length n with string_pad. If string_pad is
ommited,
a space will be used as default

What is Lpad supposed to be? I'm not aware of any function built into
Access
with that name.

I am having trouble constructing an Update query using Lpad. I keep
getting
an "unidentified function 'Lpad'" error message. The same happens in
Query.

--
Message posted via http://www.accessmonster.com




.

Relevant Pages

  • URI::URL query vs equery
    ... I'm testing a module using URI::URL, and it refuses to call query() on ... the URL created by google: ... The error message is ...
    (comp.lang.perl.modules)
  • Re: select data from linked server
    ... That's what I found when I google ... Since I just made up the table names and the query pattern, ... If you get an error message, ...
    (microsoft.public.sqlserver.server)
  • Re: Why =?iso-8859-13?b?tG5ld6E/?=
    ... query but the first post mentioning J did not make it clear that it was ... We are talking about programming here. ... That's if google didn't turn out to just ignore one-letter query terms. ...
    (comp.lang.java.programmer)
  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Background Web Queries flaws!
    ... There is no way to trap errors on a background query. ... There is no way to control the timeout setting. ... The basic problem is that IE spits an error message before returning control ... > hard coded a 5 minute limit into the web query system. ...
    (microsoft.public.excel.programming)