Access to Crystal

Yahoo Archive
1
Can you paste in your access query so we can see it to better help you.

________________________________

From: Late, Travis [mailto:tlate@...]
Sent: Thursday, September 18, 2008 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Access to Crystal



I'm in the process of converting this access query to a Crystal Report.
If you look at the formula in the WCCode Field it uses < > quite a few
times. I've tried to copy and pase this formula in Crystal , but the
formula does not work. This query is currently used to show count of all
open jobs. Anyone have any ideas how to convert this in crystal by using
an accurate formula?

As a note I am aware that in 8.03 the WCCode is now a Resource. This
Access report was written for 5.2

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
I'm in the process of converting this access query to a Crystal Report.
If you look at the formula in the WCCode Field it uses < > quite a few
times. I've tried to copy and pase this formula in Crystal , but the
formula does not work. This query is currently used to show count of all
open jobs. Anyone have any ideas how to convert this in crystal by using
an accurate formula?



As a note I am aware that in 8.03 the WCCode is now a Resource. This
Access report was written for 5.2











Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]