Query field length???

R

Rohn

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255 characters. I changed it to Memo, expecting to have much more room to store data in that field. Well, the table works like it should, but the query and the related Reports still act like there is a limit to the field length of 255 characters.... WHAT GIVES??????

Any insight would be appreciated!
 
J

Jeff Boyce

Rohn

As for the Reports, they "inherited" the field as it was THEN defined.
Updating your table definition doesn't automatically update the objects
depending on it.

I'm not sure on the query, but just for safety, you could delete the field
from your query grid and re-select it.

You'll want to take a look at your Forms, too. Any of them with the former
field have the former definition.
 
J

John Spencer (MVP)

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone can
spot the exact problem for you.
 
R

Rohn

Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
 
J

John Spencer (MVP)

So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255 characters. I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
 
R

Rohn

it did work!

I'm sure, its not the right way to get it fixed but it was the only way I
knew!
----------
Rohn Everson

So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255
Click to expand...
characters.
I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
 
J

John Spencer (MVP)

I can only guess that the original query had a format set in the query grid that
was causing the problem. It is always possible that the specific query had some
corruption in it. - Guess we will never know.

Glad it got fixed.
it did work!

I'm sure, its not the right way to get it fixed but it was the only way I
knew!
----------
Rohn Everson

So, did the rebuild work? Or do you still have the problem?
Thanks John,
I ended up deleting my query and rebuilding it as a fix! Because I could
not get the 255 character limit out of the Note field in my query? But
here is the SQL view of the query.

SELECT ContactData.Unit_ID, Notes.ContactDate AS ProblemDate,
Notes.NoteDetail, Notes.Call_Rep, Maintainer_Reps.Rep_FName,
[(Q)Call_Reps].[FullName], [(Q)Call_Reps].NoteID, Notes.Status

FROM (Maintainer_Reps INNER JOIN ContactData ON Maintainer_Reps.Rep_ID =
ContactData.MaintRep) INNER JOIN (Notes INNER JOIN [(Q)Call_Reps] ON
Notes.NoteID = [(Q)Call_Reps].NoteID) ON ContactData.RecordID =
Notes.ContactRecordID

WHERE (((ContactData.Unit_ID) Like [Enter: Unit # here] & "*"));

Thanks for taking the time to ask!
----------
Rohn Everson

POST your query.

If you have used DISTINCT or SORTED on the MEMO FIELD or USED Aggregate
functions (totals) OR applied formatting to the MEMO field, the memo field
will
be truncated by Access.

If none of those apply, POST the SQL text of your query. Perhaps someone
can
spot the exact problem for you.
Rohn wrote:

Not sure if this is a table problem or a query problem....

The Note field in my table was set to Text and limited to 255
Click to expand...
characters.
I
changed it to Memo, expecting to have much more room to store data in that
field. Well, the table works like it should, but the query and the related
Reports still act like there is a limit to the field length of 255
characters.... WHAT GIVES??????

Any insight would be appreciated!
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query field size quandry 2
disctinct query memo field 3
Query -Maximum Field Length 2
How can I convert text field to memo field in a query 10
Append Query - Cutting off Comment length field 1
Make Table Query Truncating Memo Field at 255 Characters 2
Append to SQL Server 3
memo field in the select query 2

Top