Search results for query: *

I suppose I should be thankfull - 12 months ago I had great difficult creating SQL statements/queries and today I can at least perform basic queries etc. That said I spent hours last night trying to create a query that performs the following. I have three Tables. Employees with Fields EmpID...

I have a table (Manhours) with 4 fields (ManID, VehicleID, Manhours and RptDate). I created the query (query 1) below (in Access 2000) to sum the total hours for each vehicle. It works OK in Access 2000. This query is also used by an application written in VB6 (using Crystal Reports) to create...

Many thanks again Parm. I have been trying different ways of obtaining the data and I ended up with the code being quite different from that above. Following your reply above - I returned all the code to original (ready to bundle for you) and ran. You would not believe it - it worked OK. All I...

Thanks parm Tried you suggestion but still no luck. I have been trying also to use the DataEnvironment connection before I go using the rsado connection. What I mean is that the Dataenvironment has a connection to the access database via a query, however this query is never used. I seem to be...

Appears no one can help me. I suspected this would be a tough one. I have spent some time looking at my problem and it appears that if I use the VB Datareport to do the reporting under cmd InjClass_Click. All is OK so it looks like Crystal does not like using the Data report + runtime...

The data environment is a VB6 ActiveX designer (see under Project/More ActiveX Designers) that allows you to connect to the database specifically for reporting etc. In VB6 you can also add a Data Report that uses the data presented by the Data Environment to create reports. Instead of using MS...

I am using VB6 with Crystal reports 8.5 to produce a couple of reports. Both reports use the VB Data Environment to access the Access 2000 database 'workcare.mdb' and until now I have not had any real problems. If I run the application and select cmdInjClass_click (see code below), data is...

I am using VB6 with Crystal reports 8.5 to produce a couple of reports. Both reports use the VB Data Environment to access the Access 2000 database 'workcare.mdb' and until now I have not had any real problems. If I run the application and select cmdInjClass_click (see code below), data is...

Worked a treat - it looked to me like there were too many brackets in my query - but that is what the SQL designer created after I used the wizard. Thanks.

I have 2 tables: Manhours with fields: ManID, VehicleID, ManHours and RPTDate Vehicles with fields: VehicleID and Vehicle I am trying to create a query that sums the ManHours for each vehicle based on a given date range. The following query works: SELECT Sum(manhours.Manhours) AS SumYearHours...

Many thanks Gary

I have an Access 2000 table with an ID, dates and other info. Eg: ID Date 1 1/1/99 2 2/1/99 3 3/1/99 1 10/6/00 2 11/6/00 2 12/6/00 I need to extract the latest date for each ID but I also need that ID as I use the dataset created in Crystal reports. My dataset should contain 1...

Hi - I am also trying to change a CR8.5 subreport database during runtime. I have looked everywhere and this thread is about the closest I have come to seeing anything that helps. I am using a CR with a main report and one sub report. In VB6 my code is: Set cn = new ADODB.Connection Set rsADO...

I am using VB6 with Crystal reports 8.5. I have a single viewer on a form and within my VB code I have multiple instantiations of reports. Eg at the start of my code I have: Dim svcClass as new rptClass ' Crystal rpt with class info Dim svcEquip as new rptEquip ' Crystal rpt with equip info...

Have tried using the EMPID from the main table (ie that table with Names) without a subreport and it seems to work reliably except I now get blank lines if the criteria is not met. I am trying to get format as below: Name Elect LicNo Expires First Aid No Expires Joe XY123...

dgillz - When I created my initial report I did not use a subreport as you suggested and I do have a link via EmpID to each table. If I only pass the single parameter from VB I seem to get the correct presentation but the VB program can pass up to 5 values of the same parameter and that is when...

I am using CR8.5 to create a report. I am grouping by a list a names with an ID number and using this ID number as a parameter that is entered by users. The names and ID come from a table called 'Employee'. The report works fine to this point - not much to brag about I know. Under each group I...

Thanks Jim i will try it and see if I can get it to work. I am still a novice when it comes to parameters.

Sorry - I cannot see how this will help. I suppose I was a bit short with my description of what I am trying to do. I am using VB6 to present a report (.rpt) and as default I currently have selected 'Format Section' and then selected Group header (that which I am grouping on, and selected 'New...

I have created a Crystal report (8.5) and have used group by Name, with details following. I have also checked the box that forces a page break before each group, this allows each persons details to be displayed/printed on a separate page. I would like to be able to perform the initial report...