InvoiceTot

[tom]

How does this work with no table or query
called InvoiceTot?

SELECT InvoiceTot.[Invoice Number]
FROM Invoice AS InvoiceTot
GROUP BY InvoiceTot.[Invoice Number];

 

[storrboy]

How does this work with no table or query
called InvoiceTot?

SELECT InvoiceTot.[Invoice Number]
FROM Invoice AS InvoiceTot
GROUP BY InvoiceTot.[Invoice Number];

The AS keyword is used to rename (alias) a field, calculation, table
or other query. The actual table name is [Invoice]. This would be the
same...

SELECT IT.[Invoice Number]
FROM Invoice AS IT
GROUP BY IT.[Invoice Number];