Search results for query: *

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

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...

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...

Alright, that works perfectly! Thank you very much everyone!

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...

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...

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...

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...

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!

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...

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...

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!

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

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...

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

Hi everyone I'm using MS Access I have a table that has a field called "DT" of DateTime type, between others. there's at least 3 or 4 records for each second, for example: No. Record Field1 DT 1 AA 06/25/2008 15:10:01 2 BB 06/25/2008 15:10:01 3...