Re: [MS_AccessPros] Need Syntax help please.

 

Doyce-

I think there's a missing paren:

"WHERE (((Manual_Invoice_Detail.[Account])<>0) AND ((Manual_Invoice_Header.[Invoice Date]) Between #" & StartDate & "# And #" & EndDate & "#) AND ((CustomerGroup([Cust]))=""CNF""));"

John Viescas

Sent from my iPad

> On Aug 20, 2015, at 22:26, winberry.doyce@roadsysinc.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
>
> "WHERE (((Manual_Invoice_Detail.[Account])<>0) AND ((Manual_Invoice_Header.[Invoice Date]) Between #" & StartDate & "# And #" & EndDate & "# AND ((CustomerGroup([Cust]))=""CNF""));"

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___