Triplicate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Bruce - 31 Jul 2006 21:00 GMT

I completed an Access/SQL Database Linking but now when I attempt to run my
reports one of two things happen:

Each line item is in triplicate or
I will get the following error message and the report won't run:
Undefined function 'sGetBudEmp' in expression

How can I fix? What do I need to change or delete? I am an absoulte newbie
so please be gentle!

Thanks for your help. It is greatly appreciated!

Reply to this Message

John Vinson - 31 Jul 2006 21:33 GMT

>I completed an Access/SQL Database Linking but now when I attempt to run my
>reports one of two things happen:
>
>Each line item is in triplicate or

This would suggest that the Report is based on a Query which is
incorrect - perhaps you're joining a table with three records into the
query without a Join line, or you have the Sorting and Grouping done
incorrectly.

>I will get the following error message and the report won't run:
>Undefined function 'sGetBudEmp' in expression

Well, sounds like somewhere in the query (which I can't see from here)
or on the Report (which I can't see either) you have a call to the
function sGetBudEmp(). Access is trying to execute it as a function,
but the function does not exist in your database.

>How can I fix? What do I need to change or delete? I am an absoulte newbie
>so please be gentle!

It would help us immensely if you would open the Report in design
view; find its Recordsource property, the first property on the Data
tab; click the ... icon by it to open it in design view; select
View... SQL; and post the SQL text here.

John W. Vinson[MVP]

Reply to this Message