Re: [MS_AccessPros] Joined Query

 

Dear Crystal,

Thanks a lot.

Best Regards,

Kevin

发自 WPS邮箱客戶端

在 "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2019年4月4日 04:40写道：

 

hi Kevin,

don't have field names starting with a number. You will get strange
problems like this. Always start field names with a letter. Perhaps
change to a15, a13, a11, etc

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 4/3/2019 6:45 AM, Kevin qingqinga [MS_Access_Professionals] wrote:
> Dear All,
>
> I made a mistake, it's union query, not "joned query".
>
> Best Regards,
>
> Kevin
>
> On 03-Apr-2019 6:52 PM, Kevin qingqinga
> [MS_Access_Professionals] wrote:
>> Dear All,
>>
>> In a joined query, I put the condition as below:
>>
>> WHERE ((11)=1 AND (15)=Forms!frmAllReceipt!TransactionYear AND
>> (13)=Forms!frmAllReceipt!TransactionMonth);
>>
>> It does work well with 15 and 13, but 11 doesn't screen out the expected
>> result. behind the 11 is AcountID.
>>
>> Please help. Thanks in advance.
>>
>> Best Regards,
>>
>> Kevin

__._,_.___

---

Posted by: qingqinga <qingqinga@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___