Crystal Report Formula..??

[jeffro]

I hope someone can help me out. I'm trying to write a formula for the top ten in industrial. The fields I'm using are repairtime, setuptime, and pmtime, which are used to do the totaling and that will be used to find the top total of the machineno. Also I'm using the machineno, and division, the division field is used to look up just the industrial equipment.

Can anyone help out??

Aja

[simonm]

I would not do that as a crystal formula.

I would create an SQL query to list each machine in order of total time. Use the 'SELECT TOP 10' syntax to only retrieve your top ten records.

I'm sorry if I've misunderstood your requiredments but I found it difficult to make sense of problem description. If I am barking up the wrong tree then please elaborate further.

Simon.

[jeffro]

Do you want me to make a SQL statement in my database? The only thing I have in my database is 3 Tables and the forms, reports are made in Visual Basic. Could I write an SQL statement in my Visual Basic code?

You had the right idea with my post!

Thanks Aja

[simonm]

You can create an SQL statement and store it in you database as a 'query'. This can be done either from VB or directly in Access(I presume that's what you're using) itself. The report just needs to be based on the query instead of the tables.
The exact syntax of the query would depend on the tables involved.