Hi,
Thanks for the replies. From what I can see, even a simple query to extract the contents of the field will truncate the contents to 255. The entire content can be extracted in parts though, using the "MID" command and then extracting the contents in 'clusters' of 255 characters...
Hi,
I am experiencing a problem pulling the "full" content of a memo field in a query. It seems to limit the return to a maximum of 255 characters. Is there a solution to this problem, whereby a query can be written to pull ou the complete contents of the field in Access 2000...
Terry,
You are a SAVIOR!!! The third example was exactly what I needed. I truly appreciate your help.
And thank you lisbet for helping out as well.
Much Thanks,
Wyman
Thanks,
However, I was not very explicit with my explanation of the problem. When I use the INNER JOIN, would it not look for values where the Project ID's from both query results are EQUAL? I am looking for a way to combine two queries that contain the information for different projects...
Hello,
I was wondering if it's possible to join the result of two queries together? I have one query that is used to calculate the revenue difference between projects that carryover to a new period. The other query filters out all projects that started exclusively in the current period...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.