Re: Lpad in Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

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: 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)
  • Re: How would the God of Standard Sql - Celko do server side paging?
    ... I think that first my query is checked against other previously ... A lot of people Google "<movie star ... Then using the same model as a report server, ... If I ask a truly original query of Google, ...
    (microsoft.public.sqlserver.programming)
  • Re: Update Query only works first time
    ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ... Microsoft Access MVP 2006 ... It works the first time, but then there is a very long error message with several reasons why it does not work. ...
    (microsoft.public.access.queries)