I think I might have missed something. I would use:
P = DSum("SUM_BxQty", "tbl_DistributionMap", "[MDLID]= """ & ChRstMdlID & """ And [AssyPage] = """ & ChRstAssyPage & """")
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 17, 2019 7:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] wrong syntax
Sent: Friday, May 17, 2019 7:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] wrong syntax
Try:
P = DSum("SUM_BxQty", "tbl_DistributionMap", "[MDLID]= " & "'" & ChRstMdlID & "'" And [AssyPage] = " & "'" & ChRstAssyPage & "'")
There was an extra " in there. I also took out some extra table names.
Duane
Get Outlook for iOS
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Dave Williams davewillgmale@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, May 17, 2019 5:33:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] wrong syntax
Sent: Friday, May 17, 2019 5:33:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] wrong syntax
The line is not completed?
On 17/05/2019 09:36, youssef2309@gmail.com [MS_Access_Professionals] wrote:
> Dear All,
>
> thanks to feed back what is the wrong in the next syntax line
>
>
> P = DSum("SUM_BxQty", "tbl_DistributionMap",
> "[tbl_DistributionMap]![MDLID]= " & "'" & ChRstMdlID & "'" And
> "[tbl_DistributionMap]![AssyPage] = " & "'" & ChRstAssyPage & "'")
>
>
> I'm using Microsoft office 2010
>
>
> Your quick response will be highly appreciated.
>
>
> thanks in advance
>
>
------------------------------------
Posted by: Dave Williams <davewillgmale@gmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
On 17/05/2019 09:36, youssef2309@gmail.com [MS_Access_Professionals] wrote:
> Dear All,
>
> thanks to feed back what is the wrong in the next syntax line
>
>
> P = DSum("SUM_BxQty", "tbl_DistributionMap",
> "[tbl_DistributionMap]![MDLID]= " & "'" & ChRstMdlID & "'" And
> "[tbl_DistributionMap]![AssyPage] = " & "'" & ChRstAssyPage & "'")
>
>
> I'm using Microsoft office 2010
>
>
> Your quick response will be highly appreciated.
>
>
> thanks in advance
>
>
------------------------------------
Posted by: Dave Williams <davewillgmale@gmail.com>
------------------------------------
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
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.
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar