Hi! I have a question regarding the rounding used for Access. I have a make-table query that pulls certain client info into a new table that uses the following SQL:
SELECT DISTINCTROW [HC Post units (change dates)].CLIENTID, [HC Post units (change dates)].CLIENT, [HC Post units (change dates)].GSEREXT, [HC Post units (change dates)].GAGENCY, Sum([HC Post units (change dates)].UNITS) AS [Sum Of UNITS] INTO [HC Post Units-Client Totals]
FROM [HC Post units (change dates)]
GROUP BY [HC Post units (change dates)].CLIENTID, [HC Post units (change dates)].CLIENT, [HC Post units (change dates)].GSEREXT, [HC Post units (change dates)].GAGENCY;
The query above is then further used by the crosstab query below, AFAIK.
TRANSFORM Sum([HC Post units (change dates)].UNITS) AS SumOfUNITS
SELECT [HC Post units (change dates)].CLIENT, [HC Post units (change dates)].GAGENCY, Sum([HC Post units (change dates)].UNITS) AS [Total Of UNITS]
FROM [HC Post units (change dates)]
GROUP BY [HC Post units (change dates)].CLIENT, [HC Post units (change dates)].CLIENT, [HC Post units (change dates)].GAGENCY
PIVOT [HC Post units (change dates)].GSEREXT;
I would like to add an additional column (calculated field) to the original query which will round to the nearest whole number - Access uses Banker's rounding, but I need Arithmetic rounding in this case. I have tried to make a function but the syntax seems to be off (I tried the info found in this thread to make a function - https://bytes.com/topic/access/answe...ounding-up-5-a)
Thank You!