Re: Selection on MergeAll

I have checked it Albert, the field is a number type, not a text.

So what should I do , There should be no double quote?
--
H. Frank Situmorang


"Albert D. Kallal" wrote:


MergeAllWord ("select * from PelayanJemaat Where TahunPel= " &
lngMergeYear")

The above has a extra "quote" at the end....does the above even compile??

Remote the last trailing quote you have right after LngMergeYear" <--
remote quote.

eg:

MergeAllWord "select * from PelayanJemaat Where TahunPel= " &
lngMergeYear"


Note that if TahunPel a text type field, then you need the following with
quotes (check in the table design mode if TahanPel is number or text).

If it is a text field, then you need to surround the sql with quotes...

eg:

MergeAllWord "select * from PelayanJemaat
Where TahunPel= '" & lngMergeYear & "'"


Watch for word wrapping in the above...they should be on one line....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx



.

Relevant Pages

  • Re: Larry Craig
    ... Albert to quote it. ... It will halt within if Ramzi's discussion isn't ... slight. ...
    (sci.crypt)
  • Re: What is fundamentalism?
    ... Albert "Only when you are willing to give some answers to the questions I ... I often find myself in a quandary about answering un-asked questions. ... question more completely I could instruct you on how to google the ... You want me to quote writers on the SRB that said these things? ...
    (soc.religion.bahai)
  • Einstien Repost (No Links)
    ... Albert Einstiens Theory Of Relativity Perpetual motion and Circular Motion. ... Albert stated "I want to ride that beam of light with 'u' " end quote. ... Einstien himself stated "That little dog tries" end quote. ... Is not a dream the foundation of any idea? ...
    (sci.physics.relativity)
  • Re: Selection on MergeAll
    ... Thanks very much Albert it works perfectly now. ... lngMergeYear") ... The above has a extra "quote" at the end....does the above even compile?? ... Note that if TahunPel a text type field, then you need the following with ...
    (microsoft.public.access.forms)
  • Re: Selection on MergeAll
    ... lngMergeYear") ... The above has a extra "quote" at the end....does the above even compile?? ... Note that if TahunPel a text type field, then you need the following with ...
    (microsoft.public.access.forms)
Quantcast