V
Vylent Fyre
I'm at a complete loss right now in trying to decipher what is causing this
error. I have started the queries over from scratch and still get this. I'm
sure it's an obvious answer; I'm just not able to pin point it right now. I
am trying to, ultimately, in a 3rd or 4th query after this one (this is 2nd
one) to get a sum from a particular expression, but first I need to get this
to not get this error. There's nothing being summed in this query; just all
grouped by for now. Below is the SQL for this query (the 1st query it's
pulling information from is qry_ARI Future Pmts_1st) -
SELECT [Month Booked], Client, Vehicle, Div, Yard, [Bill Client Data], [In
Service], [Rental Amt], [Interest Amt], [Tax Amt], [Mgmt Fee], [Ins Fee],
[Total Billed], [Invoice Number], [Invoice Date], [Cap Cost], [Book Value],
[Mos Bill], [1st Bill], [Last Bill], [CLIENT DATA1], VIN, [Lease Term], [AFE
Number], [Term Payment], [Admin Fee], [Curr Cap Cost], [Curr Interest],
[Total Payment Forward], [1st Pmt Date Long Org], [Last Pmt Date Long Org],
[1st Pmt Date Long], [Last Pmt Date Long], [1st Pmt Date Month], [Last Pmt
Date Month], [1st Pmt Date Year], [Last Pmt Date Year], [1st Pmt Date], [Last
Pmt Date]
FROM [qry_ARI Future Pmts_1st]
GROUP BY [Month Booked], Client, Vehicle, Div, Yard, [Bill Client Data], [In
Service], [Rental Amt], [Interest Amt], [Tax Amt], [Mgmt Fee], [Ins Fee],
[Total Billed], [Invoice Number], [Invoice Date], [Cap Cost], [Book Value],
[Mos Bill], [1st Bill], [Last Bill], [CLIENT DATA1], VIN, [Lease Term], [AFE
Number], [Term Payment], [Admin Fee], [Curr Cap Cost], [Curr Interest],
[Total Payment Forward], [1st Pmt Date Long Org], [Last Pmt Date Long Org],
[1st Pmt Date Long], [Last Pmt Date Long], [1st Pmt Date Month], [Last Pmt
Date Month], [1st Pmt Date Year], [Last Pmt Date Year], [1st Pmt Date], [Last
Pmt Date];
error. I have started the queries over from scratch and still get this. I'm
sure it's an obvious answer; I'm just not able to pin point it right now. I
am trying to, ultimately, in a 3rd or 4th query after this one (this is 2nd
one) to get a sum from a particular expression, but first I need to get this
to not get this error. There's nothing being summed in this query; just all
grouped by for now. Below is the SQL for this query (the 1st query it's
pulling information from is qry_ARI Future Pmts_1st) -
SELECT [Month Booked], Client, Vehicle, Div, Yard, [Bill Client Data], [In
Service], [Rental Amt], [Interest Amt], [Tax Amt], [Mgmt Fee], [Ins Fee],
[Total Billed], [Invoice Number], [Invoice Date], [Cap Cost], [Book Value],
[Mos Bill], [1st Bill], [Last Bill], [CLIENT DATA1], VIN, [Lease Term], [AFE
Number], [Term Payment], [Admin Fee], [Curr Cap Cost], [Curr Interest],
[Total Payment Forward], [1st Pmt Date Long Org], [Last Pmt Date Long Org],
[1st Pmt Date Long], [Last Pmt Date Long], [1st Pmt Date Month], [Last Pmt
Date Month], [1st Pmt Date Year], [Last Pmt Date Year], [1st Pmt Date], [Last
Pmt Date]
FROM [qry_ARI Future Pmts_1st]
GROUP BY [Month Booked], Client, Vehicle, Div, Yard, [Bill Client Data], [In
Service], [Rental Amt], [Interest Amt], [Tax Amt], [Mgmt Fee], [Ins Fee],
[Total Billed], [Invoice Number], [Invoice Date], [Cap Cost], [Book Value],
[Mos Bill], [1st Bill], [Last Bill], [CLIENT DATA1], VIN, [Lease Term], [AFE
Number], [Term Payment], [Admin Fee], [Curr Cap Cost], [Curr Interest],
[Total Payment Forward], [1st Pmt Date Long Org], [Last Pmt Date Long Org],
[1st Pmt Date Long], [Last Pmt Date Long], [1st Pmt Date Month], [Last Pmt
Date Month], [1st Pmt Date Year], [Last Pmt Date Year], [1st Pmt Date], [Last
Pmt Date];