Jumat, 17 Mei 2019

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


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
 
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/

__._,_.___

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 (3)

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