SubQuery Mulitple Queries for differences within Fields

[Guest]

Hello again.

I am attempting to write a query that will locate records with differences
in identicle fields. Monthly, we get a list of projects within the company.
Each row is another project and each project has several columns containing
different pieces of information about the project (i.e. leader, division,
project phase, etc.). I have consolidated all months into one master table
with a column for date. I then run 2 queries that identify the most recent
month and the month prior. I want to run a query that will idenfity any
records that have any changes within any field. Can I do that without
designating criteria for each column? There are 12 fields of criteria and
designating every possible combination would require !12 possibiliites. Is
there an easier way?

signed- desperate in Cincy...

 

[MGFoster]

Hello again.

I am attempting to write a query that will locate records with differences
in identicle fields. Monthly, we get a list of projects within the company.
Each row is another project and each project has several columns containing
different pieces of information about the project (i.e. leader, division,
project phase, etc.). I have consolidated all months into one master table
with a column for date. I then run 2 queries that identify the most recent
month and the month prior. I want to run a query that will idenfity any
records that have any changes within any field. Can I do that without
designating criteria for each column? There are 12 fields of criteria and
designating every possible combination would require !12 possibiliites. Is
there an easier way?

signed- desperate in Cincy...

GROUP BY <column list>

SELECT col1, col2, col3, col4, ... etc.
FROM table_name
WHERE <criteria>
GROUP BY col1, col2, col3, col4, ... etc.