Linking on Formula

[shelby55]

Hello

I use Crystal 8.5 on Windows 2000. The database is SQL.

The database is patient related and has the age and for children under 2 years has the age as days or months.

There is a table in an Access separate from the database above that I would like to link, however the link is to be on age group (0 to 17, 18 to 69, 70+) and CaseType.

CaseType is already a field in the SQL database but for the ages I would first have to create a formula called "real age" to get all as years:
If {AgeCode} = "D" then 0 else
If {AgeCode} = "M" and {AgeNumber}< 12 then 0 else
If {AgeCode} = "M" and {AgeNumber}>=12 then 1 else
{AgeNumber}

Then I'd want to create a formula based on "RealAge" for the Age Groups (which I know how to do, just won't post) and for the purpose of example call it DataAgeGrp.

My question is: can you link the Access table field of Age Group to the database via the formula field of "DataAgeGrp"? If not, is there any way to get this link developed other than building it in the SQL database?

Thanks to all for your assistance and expertise.

Shelby

 

[synapsevampire]

A common way to join Access and SQL Server tables (I assume that you meant SQL Server) is to link to the SQL Server tables from within the Access database, and then create the query from within Access.

Or you might import the Access table into the SQL Server database using DTS, it's fairly easy as well.

-k

 

[shelby55]

Hi Synapsevampire!

Thanks for the reply but I'm not really experienced - what is DTS? And yes I did mean SQL Server.

Shelby