|Subject:||Re: Text in a Query Table Field
|Date:||Fri, 10 Nov 2017 07:44:36 -0500
|From:||"Steven Green" <firstname.lastname@example.org>
what's the error message? did you accidently put a comma after the
CheckPlus? does the actual text include the quotes?
Myrtle Beach, South Carolina, USA
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"John Wright" wrote in message news:email@example.com...
I have a Query as below...
getCode = Query
ANSWER: :PRIV:ANSWER.DB ;Query = GetGroupedIndInfo
:APL:IndividualStoredInfo.DB | Date and Time Stamp |
| CheckPlus |
:APL:IndividualStoredInfo.DB | UniqueCode | Description|
| CheckPlus _join1, ~UniqRef | CheckPlus |
:APL:IndividualStoredInfo.DB | Object Stored Field | Masonic Title |
| CheckPlus | CheckPlus |
:APL:IndividualStoredInfo.DB | Surname | C Name | Short C Name |
| CheckPlus | CheckPlus | CheckPlus |
:APL:APLaddress.DB | UniqueCode | Home Phone | Home Email |
| _join1, ~UniqRef | Check | Check |
In the Description Field above I have the following...
NOT "REPLACE THIS WORDING or this record will get deleted when you leave
This query has not been used for some time and I am sure it used to work
ok! The query only works now if I DON'T include the NOT and the text.
Any thoughts as to what is wrong with that text entry?
This email has been checked for viruses by Avast antivirus software.