Hey,
I have two tables used within a report one therough btrieve and the other odbc.
Within each table there is a field called {emp.no}. However, one field is located within a Jobshop database and is a string field and the other is located within a TimeLOG database and is a number field.
Is there anyway of linking these fieds within crystal? I dont belive its possible with the Database Expert. But maybe elsewhere?
The report feeds through from the Jobshop (string) field and I need to match records within the TimeLOG (number) database to those within Jobshop based on emp.no and a date field.
Any help much appreciated.
Regards
RobSee the help on the ToText and ToNumber functions.
You should be able to use these in the Record Selection formula.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment