Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RaceStats

    Database Connection with Visual Basic 2005

    I'm converting a program from VB6 to VB 2005 and am having problems trying to figure out the connection and updating the database. In VB6 my code looked pretty much like this: Set objCon = New ADODB.Connection Set objCom = New ADODB.Command 'Creating the DB connection string...
  2. RaceStats

    Date comparison and delimiters

    PHV Awesome, that worked. I knew it was something like that but I couldn't figure it out. Thanks a ton for the help.
  3. RaceStats

    Date comparison and delimiters

    I've been banging my head against this for the past few days and can't get past it. I'm using VB6 to access an Access DB. All I'm trying to do is compare a tables date field to 2 variables that contain dates. I've tried numerous delimiters and syntax and I either error out or the result...
  4. RaceStats

    SQL Calculations, Percentages, & Averages

    lameid, first off thanks for helping out a rookie I truly appreciate it. To answer your question, there might be 2 ways of determining (RaceNumberAgo). This could be done by either EventDate or EventID. Let me give you the important table configuration to better explain. Table - Events...
  5. RaceStats

    SQL Calculations, Percentages, & Averages

    I'm new to SQL and need some advice on performing various calculations. If someone could point me down the right path to get information on how to do these things I would appreciate it. I'm trying to create a Racing Statistical Program. You can see thread "Selecting data with criteria from 3...
  6. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Awesome!! That did it. I now have the result set that I'm looking for. One more hurdle has been jumped and it's on to the next one. I want to thank everyone for their help. This was fun and I have learned a lot from it. For quite some time I've been focusing on creating the database which...
  7. RaceStats

    Selecting data with criteria from 3 or 4 tables

    OUCH!!! At first I thought that would work. I made the change and I got the following error: "No value given for one or more required parameters". After looking at the code it seems to me that this would limit the result set to only those records with same TrackID as that of the selected...
  8. RaceStats

    Selecting data with criteria from 3 or 4 tables

    LOL!! I got a copy of Beginning SQL by Paul Wilton & John Colby. They have the best explaination of JOINS that I've come across so far. I put the extra "()" and got rid of the syntax error and at least received a result set. However all that is being returned are the results fro the selected...
  9. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Leslie I tried your suggested code and received the following error: "Missing operator in expression" and it displays the following code in the pop-up: Events E ON E.EventID = R.EventID " & _ " INNER JOIN Track T ON E.TrackID = T.TrackID " & _ " INNER JOIN TrackType T2 ON...
  10. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Leslie Thanks for the SQL article I totally missed that thinking the 2 links were the same. I'll check that out. Thanks for the help. I'll be giving this a try a little late. I can't you enough for the help.
  11. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Lelsie/Golom Golom's code worked great and your advice has helped me to better understand what's going on. I'm Technical. I'll keep your environment running, build, load, & maintain your servers, etc. but programming has always been difficult for me to pick up so please bear with me. I'm...
  12. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Leslie Thanks for the help. That worked great. Also thanks for the article. Much of that information I had used when I created my DB, but this gave a little better understanding of some areas I was fuzzy in. To answer your question, there are no NULL values in the Points field however there...
  13. RaceStats

    Selecting data with criteria from 3 or 4 tables

    I am new to SQL and need help with some complicated transactions. Using an Access DB and writing the code in VB6, I am creating a Racing Stats Program. The current 2 queries that I am trying to figure out gather driver stats for a selected track or track type. The tables involved and contents...
  14. RaceStats

    Selecting data with criteria from 3 or 4 tables

    Thanks for the help, I truly appreciate it. However, I am currently utilizing an Access database. I could create the query in Access, but how would I call it from there? Thanks again for the help.
  15. RaceStats

    Selecting data with criteria from 3 or 4 tables

    I am new to SQL and need help with some complicated transactions. I am creating a Racing Stats Program. The current 2 queries that I am trying to figure out gather driver stats for a selected track or track type. The tables involved and contents are: Results - DriverID, EventID, Points...

Part and Inventory Search

Back
Top