Triplicate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
Click to expand...

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
Click to expand...

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!
Click to expand...

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]
 
Back
Top