Re: Make table truncates text concatenated using fnConcatenate

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

On Wed, 11 Apr 2007 12:48:04 -0700, Dale Fye <dale.fye@xxxxxxxxxx> wrote:

I know I could create the base table and import the data from my query into
that table, but I would prefer to make this table on the fly, and then delete
it when I am done with it.

Any recommendations?

If you want the text to end up in a Memo field, AFAIK you have no choice but
to create the table first.

MakeTables are rarely (IME) necessary. If you want a scratch table, just
create it once, keep it around, and empty it when you're done with it.

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Form tutorials?
    ... "John W. Vinson" wrote: ... know if anyone can point me to relevant tutorials. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)
  • Re: Very Basic Question about Totaling
    ... "John W. Vinson" wrote: ... But I can't find how to use excel formulas in access. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.gettingstarted)
  • Re: Hiding dates Query fields
    ... "John W. Vinson" wrote: ... My query selects all the records that I want. ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)
  • Re: delete access 2007 database
    ... John W. Vinson [MVP] ... The databases are not on your disk. ...
    (microsoft.public.access.gettingstarted)
  • Re: I need help creating a popup message
    ... "John W. Vinson" wrote: ... The Access Web resources page: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)