Elimination Formula

[John W. Vinson]

However, in
this case I am getting exports from our accounting system and sometimes you
have no choice but take what you can get.

You do NOT need to let the fieldnames or format of the accounting
system exports dictate your table fieldnames. If they're bad
fieldnames *just don't use them* - you can append from a table with
one set of fieldnames into a table with a different set.

I'd also avoid storing data - "Walmart Open Invoices" - in tablenames
or fieldnames.

John W. Vinson [MVP]

 

[Guest]

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;