Recent content by JonyBravo

DCrake, Perfect soluction. Thanks :D

Let supose I have the following records: Car - color - performance - date Ford - Red - 100% - 01/01/2008 Ford - green - 90% - 02/01/2008 Ford - blue - 95% - 03/01/2008 Rover - Red - 90% - 04/01/2008 Rover - green - 97% - 05/01/2008 Rover - blue - 95% - 06/01/2008 I need a query to group by...

I want to group only one field and If I try to display the date without grouping it wont run the query. I need something like: SELECT fldModelName, Max(fldPercentage) AS Rank, fldDate FROM tblModels GROUP BY fldModelName ORDER BY Max(fldPercentage) DESC; but it only runs if is like that...

Thanks to your help DCrake. And if I have another field called date and I want it also displaying the date with the max(fldPercentage)? How do I do?

Hi there If i've got the following fields and values: Cars - colour - performance Ford - Red - 100% Ford - green - 90% Ford - blue - 95% Rover - Red - 90% Rover - green - 97% Rover - blue - 95% It's possible to write a query to give me the best performance by each car? ex Ford - Red - 100%...

Thank you very much. :o

Hi there I need to use Cristal report in my work but I have no idea how it works. I would like to know if it can retrieve the information direct from the SQL database or if it needs an application built as example in vb6 or vb.net? Thanks

Hi there. I built the following code to run a report: Private Sub cmdTest_Click() If Not IsNull(txtDateFrom) Or (txtDateFrom <> "") Then DataEnvironment1.Command2 txtDateFrom.Text DataReport2.Show End If End Sub When I run it displays the report strait away but if I try to run another report it...

Hi there I had the same problem in SQL2000 and I had to delete the field ID and create a new one. It may be another easy way to do that but this worked with me. I hope this helps

Hi I've got an VB6 application front end with an SQL2000 database as a back end. I need to create some reports using the datareport but I don't know how to do. Is there anyone that could tell me where to find a good tutorial online please.

Hi there Once again thanks SQL_Hell for your help. I've use an example I've found to build the following dts.execution from VB: Dim opackage As DTS.Package Set opackage = New DTS.Package opackage.LoadFromSQLServer PARS, , , DTSSQLStgFlag_UseTrustedConnection, , , , copyTxt, 0...

Thanks SQL_Hell. You are absolutely right. I would like to create a button on an VB6 application when clicked execute the saved packdge. Is this possible? Thanks again

I'm using the follwoing part of code to connect to an VB6 application to a sql 2000 server: Sconn=”Provider=SQLOLEDB.1;Trusted Connection = True; Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=PARS;Data Source=10.100.66.118" conn.open sconn The problem is whe...

Hi there I'm new on SQL server and I need some help. I'm building a VB6 front end with SQL 2000 as a back end. I've built my tables but the information that will be feeding them It will be received weekly on text files and then I have to export manually into the tables. I woul like to know if...

Thanks rainman89. That was perfect