Hi All
I have one table that content all. I have tried linked to Access and
creates queries and it worked but, I need use Crystal for that.

Here are the queries that I did in Access
Query 1.

SELECT ssa_ith.ttype, ssa_ith.thcntr, ssa_ith.ttype, ssa_ith.ttdte, ssa_ith.twhs,
ssa_ith.tref, ssa_ith.thlin, ssa_ith.tqty
FROM ssa_ith
WHERE (((ssa_ith.ttype)="U") AND ((ssa_ith.ttdte)>20000601) AND ((ssa_ith.twhs)="CH"));

Query 2.

SELECT ssa_ith.ttype, ssa_ith.thcntr, ssa_ith.ttdte, ssa_ith.twhs, ssa_ith.tqty,
ssa_ith.tscst
FROM ssa_ith
WHERE (((ssa_ith.ttype)="T") AND ((ssa_ith.ttdte)>20000601) AND ((ssa_ith.twhs)="CH"));

Query 3.

SELECT ssa_ith.tprod, ssa_ith.twhs, ssa_ith.ttdte, ssa_ith.thcntr, [Receipts
Transaction].ttdte AS [Date Received into Consignment], [Transfer Transaction].ttdte
AS [Transfer Date], [Transfer Transaction].tqty AS [Quantity Transferred],
[Transfer Transaction]![tqty]*[Transfer Transaction]![tscst] AS [Extended
value]
FROM (ssa_ith LEFT JOIN [Receipts Transaction] ON ssa_ith.thcntr = [Receipts
Transaction].thcntr) LEFT JOIN [Transfer Transaction] ON ssa_ith.thcntr
= [Transfer Transaction].thcntr
WHERE (((ssa_ith.tres)="01") AND ((ssa_ith.twhs)="KH") AND ((ssa_ith.ttdte)>20010301)
AND ((ssa_ith.ttype)="CI"));

And now how do I create the first two queries and link to the database?

I also tried to use Crystal Query Designer to created the first two queries
and save as .qry files but, I can't generate the last query.

Can anyone help me!
Thanks
Andrew