Access Functions

[wiseamo]

Hi,

I just become a member, and this is a great forum.

Does anyone know, how I can get the coding behind built-in functions of access. I want to modify the function called "Partition". The function does grouping by range. example 1 to 199, >199 to 299, and so on. I want it to group by round numbers example 1 to 200, >200 to 300, to include the 200 or 300. The function does not do it.

So I need to modify it to my needs, but I could not find anywhere how the function was created or any other function MS Access has.

Can anyone help.

Thank you for your help.

 

[norman]

Hi

You can change the start value from 0 to 1, this will give you the ranges you want. Values for zero will be in it's own range.

Access help gives the example below (with 0 as the start)

SELECT DISTINCTROW Partition([freight],1, 500, 100) AS Range, Count(Orders.Freight) AS Count
FROM Orders
GROUP BY Partition([freight],1,500,100);


HTH

Norman

 

[Mile-O]

You can't modify the default functions - they are written and compiled in C++. Just write your own.