|
Regina Whipp |
|
The difficult I do immediately, the impossible takes a little bit longer. |
Memo field is truncated when exported to Excel |
|
Queries |
|
SELECT DISTINCT tblLifts.lLiftID AS LiftID, Sum(tblLifts.lGrossWeight) AS GrossWeight, Sum(tblLifts.lCalcNet) AS CalcNet, Sum([lGrossWeight]-[lCalcNet]) AS Tare FROM tblLifts GROUP BY tblLifts.lLiftID ORDER BY tblLifts.lLiftID; |
|
Unless you need your query to produce Unique Values, setting that to No will remove the DISTINCT clause. |
|
Some of the reasons could be…
1. Using a DISTINCT clause |
|
2. Using aggregates, such as... |
|
3. Applied formatting to the memo field, ie. Nz([MemoField]) or IIF() |
|
SELECT Max(Val(Right$([msMetalLiftID],Len([msMetalLiftID])-InStr(1,[msMetalLiftID],"SS")-1))) AS LastBinID FROM tblMetalScrap; |
|
Avg Count First, Last Min, Max StDev, StDevP Sum Var, VarP |