Elimination Formula

A

acctsrec

Okay, I have completely redone the SQL and now nothing is filtering through.
When I run my query I get no answers. SQL copied below. Any corrections?

SELECT [Walmart Open Invoices].[Invoice #], [Walmart Open Invoices].[Inv
Date], [Walmart Open Invoices].[Inv Amt], [Walmart Open Invoices].[Bal Due],
[tbl primary].[date filed], [tbl primary].[claim amount], [tbl
primary].[claim carrier], DateDiff("d",[Inv Date],Now()) AS [No Days Open]
FROM [Walmart Open Invoices] LEFT JOIN [tbl primary] ON [Walmart Open
Invoices].[Invoice #]=[tbl primary].[invoice number] WHERE [tbl
primary].[claim amount]<>0 And [tbl primary].[invoice number] Not Like "02*"
And DateDiff("d",[Inv Date],Now())<60;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top