Count (1 Viewer)
- Thread starter Gismo
- Start date
Minty
AWF VIP
- Local time
- Today, 07:13
- Joined
- Jul 26, 2013
- Messages
- 10,366
Badly stored data alert...
This is a typical problem associated with a spreadsheet style storage method. As you have now discovered it doesn't scale well and makes doing apparently easy things very difficult.
You'll have to literally add them up manually - PainfullResult: Field1 + Field2 + Field3 etc etc.
When you add column 9 you'll have to hardcode that back into your query, and if you have null values anywhere you have to encompass them to continue the sums to work.
This is a typical problem associated with a spreadsheet style storage method. As you have now discovered it doesn't scale well and makes doing apparently easy things very difficult.
You'll have to literally add them up manually - PainfullResult: Field1 + Field2 + Field3 etc etc.
When you add column 9 you'll have to hardcode that back into your query, and if you have null values anywhere you have to encompass them to continue the sums to work.
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 02:13
- Joined
- May 21, 2018
- Messages
- 8,516
Code:
Public Function AddColumns(ParamArray Columns() As Variant)
Dim i As Integer
For i = 0 To UBound(Columns)
AddColumns = AddColumns + Nz(Columns(i),0)
Next i
End Function
Code:
select AddColumns([field1],[field2].....[fieldN]) as Total from sometable
