DAO Undefined Function (from Access)

[Leon123456]

Hi

I'm trying to link a query from access (or stored procedure in Crystal), into Crystal.

Query is called 'LQClients' and is itself based upon a query called 'LQData'

The query call a custom function called 'RoundUp' which just takes a number and round it up to nearest whole. This works perfectly in Access.

When I try to connect the query to Crystal I get:

Database Connector Error: DAO Error Code 0xc0D
Source DAO.Parameters
Description: Undefined function 'Roundup' in expression.

How can I get around this?

Also, I'm ultimately looking to run the Crystal report from a VB6 app, with the datasource being created within VB6. I 'm fine with adding the datasource etc but how would I reference the 'Roundup' function.... in VB6 or Crystal???

Thanks

LeonH

 

[namliam]

Use something like:
Int(field+1)

which is native without using a function

 

[Leon123456]

Thanks Namliam I'll give that a go.

I would like to know how I'd use the actual 'Roundup' function I'd written to rystal though, as I have a number of reports to move from Access to Crystal and most have some custom functions involved!!

Thanks

Leon

 

[Leon123456]

After playing around for a bit I've discovered the answer!

I just need to recreate the functions in Crystal for each report.