Re: how do I increase a query field size to more than 255 characters?

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

From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
Date: Tue, 17 Jan 2006 09:04:08 -0600

It might help if you offered up a view of the SQL of your query. You might
have phrases like "DISTINCT" or "GROUP BY" or other that would limit the
number of characters.

--
Duane Hookom
MS Access MVP
--

"Alan Synnott" <AlanSynnott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B424A0ED-297A-4D13-9DD7-C33407EDFD4C@xxxxxxxxxxxxxxxx
>I have a query based on a table. the table contains a field which holds a
> large amount of text data, so I have set its data type to Memo. No
> problem.
> But the query will only display (and export) the first 255 characters of
> the
> large amount of text in each record, and I cannot find any method to
> increase
> this, despite searching high and low in the Help sections etc, but
> logically
> speaking there must be a way of doing it.
> I could work without the query I suppose, and pull the info straight of
> the
> Table, but I would prefer not to. Please advise.

.

Prev by Date: Re: Transferring Data
Next by Date: Re: How to remove duplicates from linked table query?
Previous by thread: Sum Query with 2 Sums on One Line
Next by thread: Re: how do I increase a query field size to more than 255 characters?
Index(es):
- Date
- Thread

Relevant Pages

Re: Truncated Memo field displayed on form
... 255 characters in any column that is in the combo box's RowSource query. ... My fields down to "Knowledge and Understandings" are fine. ... occurs with the "descriptor" field being truncated on my form. ...
(microsoft.public.access.forms)
Re: Query Exceeds the limit of data for a single record
... A query can only return 2000 characters in any one row. ... I tried to use the memo data type but my report would only show ...
(microsoft.public.access.queries)
Re: Using part of a field
... See the article "Finding and replacing characters using wildcards" at: ... AS400 SQL may have a different way of doing ... called i.dsn, containing the followiing text: ... sort of thing in a query. ...
(microsoft.public.word.mailmerge.fields)
Re: Export to Ascii
... characters in a calculated field when you export a query. ... Modify your query to append its output to the temporary table; ... "John Nurick" wrote: ... that instead of concatenating with a delimiter it concatenates a fixed ...
(microsoft.public.access.externaldata)
Re: SQL too long?
... I haven't done a thorough analysis here, but I suspect that the number of characters needed to express the SQL may not be as important as the number of aggregate functions like Sumand Countthat you invoke along the way. ... Although what you now have may be correct, assuming no simian behavior on the part of Access, splitting up the Query may also make it easier to debug if you later encounter any questions concerning its correctness, or if you need to revise it in some way. ... For example, in my copy of Access 2000, it says that the "Number of characters in an SQL statement" has a maximum value of "approximately 64,000", so you probably have some wiggle room there, even without using abbreviated aliases for some of the names. ... tblARTrn01.invno) INNER JOIN tblARMst01 ON tblDUPSFreight.invno = tblARMst01. ...
(microsoft.public.access.queries)