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!

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

Recent content by Idmpc

  1. Idmpc

    Help on creating a new field on a table and more complex stuff

    Thanks PHV! I never really learned how to use those "JOIN" commands, so that link will prove very useful!
  2. Idmpc

    Help on creating a new field on a table and more complex stuff

    Sorry, I'm kind of confused with that answer... However, I thought of a solution that may be possible: I created a new table called NAMES, which contains fields ID and NAME Then I created another table called CONTAINS, with fields ID, C and NAME Here's what my new tables look like: TABLE...
  3. Idmpc

    Help on creating a new field on a table and more complex stuff

    Hi everyone So, I was developing this database for someone, but now it needs an upgrade. They want me to add a field (lets call it NEWFIELD) to an already existing table, however, that field will need to store some information that's not present on the database. Also, the database is already...
  4. Idmpc

    How to group and order Jet SQL Query by count

    Alright, that works perfectly! Thank you very much everyone!
  5. Idmpc

    How to group and order Jet SQL Query by count

    Thank you, PHV and lespaul! It's ALMOST 100% working! I changed the ORDER BY clause to: ORDER BY B.ErrorCount DESC, 3 Now it is ordering my Errors correctly, but the details are being ordered from minimum to maximum (ascending), and I also need the details to be descending order. I tried...
  6. Idmpc

    How to group and order Jet SQL Query by count

    Thank you lespaul However, when I tried to type that query of yours (I did change the TableName to my table's name), I got the following error: You tried to execute a query that does not include the specified expression 'B.ErrorCount' as part of an aggregate function. Do you have any other...
  7. Idmpc

    How to group and order Jet SQL Query by count

    Hi everyone, As usual my thread title might be confusing, so here's what I've been trying to do but with no success: I have a table with the fields ERROR and DETAILS. here's an example of the data inside the table: ERROR DETAIL A D1 A D1 B...
  8. Idmpc

    Need help on a JET SQL Query for multiple series graphics :(

    dhookom, thanks a lot for your help! I went into access help file and read about those crosstab queries So I created one just as you specified and it's working perfectly! Here's the code I used for it to work on my ADO Components: TRANSFORM Count(Table.APN) AS CountOfAPN SELECT FORMAT...
  9. Idmpc

    Need help on a JET SQL Query for multiple series graphics :(

    dhookom Thanks for the help, and I'm very sorry about my lack of knowledge, but what is / how can I create a crosstab from my table? Thank you!
  10. Idmpc

    Need help on a JET SQL Query for multiple series graphics :(

    Hi everyone! Thanks for all the help! I'll try to be less confusing :) I really DID make a typo on my first sample, here's the sample again: 08/10/2008 05:06:07 - APN1 08/10/2008 07:08:09 - APN1 08/10/2008 07:07:07 - APN2 08/11/2008 10:10:10 - APN2 08/11/2008...
  11. Idmpc

    Need help on a JET SQL Query for multiple series graphics :(

    Hey everyone I know the title might have been confusing, but here's what I've been trying to do (and haven't been successful at all): I have a MS Access 2003 database, and am using ADO Components to access its contents with my Delphi program (So it uses JET SQL). In my database, I have the...
  12. Idmpc

    Help on grouping by TIME Range

    Amazing. Thanks for the help, Golom! After reading that code for a few minutes I managed to understand what's going on! Really nice code you wrote. Thanks everyone for the major help!
  13. Idmpc

    Help on grouping by TIME Range

    Thanks again! I have one last question: If I want to make those ranges custom, for example, instead of one in one hour, it can be from 2 in 2 hours, 3 in 3 hours, etc.. Is it possible? Thank you once again
  14. Idmpc

    Help on grouping by TIME Range

    One more question: Can I use CASE Statement to rename the values showed by Format(DT,'hh:00:00 - hh:59:59')? I mean, instead of displaying 00:00:00 - 00:59:59 and so on, it could display any other text like "Range 1", Range 2", etc.. If I can do it with CASE, how would I use it? I've been...
  15. Idmpc

    Help on grouping by TIME Range

    Amazing! Can't believe it was so simple! Thank you very much for your help PHV!
See more

Part and Inventory Search

Back
Top