I have 3 odbc linked tables that I use to create a report, but as I am using tables from more than 1 odbc source I get a message saying that I will be unable to use Sql.
Does anyone know of a work around for this, I need to add an Sql statement in to the query as the data type from one table is a number and in another is text, I need to link these two fields, to do this I normaly use SQL in access to CSTR so that the two feilds can talk.
Anyone able to help?
The main reason I want to use Crystal reports instead of access is I want to schedule the report to run at a set time 7 days a week automaticly (I use business objects for this at the moment)
Does anyone know of a work around for this, I need to add an Sql statement in to the query as the data type from one table is a number and in another is text, I need to link these two fields, to do this I normaly use SQL in access to CSTR so that the two feilds can talk.
Anyone able to help?
The main reason I want to use Crystal reports instead of access is I want to schedule the report to run at a set time 7 days a week automaticly (I use business objects for this at the moment)
