Search results

Hi All, I'm using a stacked bar chart driven off a simple query. It has 15 groups (bars). Everytime I run it, the first bar is reporting incorrect data!! But it is only the first bar, all the rest are fine. It is even different from the accomanying datasheet (in design view). Please, please...

Yes, thanks for your help. With the other fields and joins added, the query is HUUUUUUGE. Kinda satisfying :)

Nevermind... I solved it anyway. By using a subquery in my JOIN criteria, along with a GROUP BY, I was able to perform the query I wanted whilst keeping the SUM features logically separated - resulting in no unwanted multiplication. E.g. Select MainQuery.Field_A FROM MainQuery INNER...

Sorry yes... I'm getting kinda flustered with this problem - Script_Status is the name.

Yes, that's right. I haven't included them in this post because there are alot of them! But other fields include 'pass', 'fail' etc. But they are all within the same table. I haven't renamed the names of the tables... Test_Script holds the script name, and Test_Status holds whether that...

Is this what you mean? I have two queries below... one which returns the test information and one which incorporates that test information with other information (without multiplying any aggregate SUM results). Would this work? SELECT Requirement.Name, SUM(Script_Status.Run) AS...

Well, currently, once I've created an SQL statement that I'm happy with, I copy and paste the expression into the VBA editor and ensure the syntax is compilable. When a user makes a filter selection and hits "go", I take the variables from the selection choices in the interface and use the...

OK, how would that work when trying to filter results programmatically in VBA? E.g, I need this feature because filtering on release is currently determined from the user interface as the user selects it. Thanks for your time.

Oh... I think I get you now. You mean create another query and use the results of it? By that, I meant columns from the same Script_Status table such as 'Passed', 'Failed' etc. But I figure, I can get that column successfully, then the others are just included in the SELECT statement.

Thanks again for your reply. I've tried that and it still gives me multiplied sum results. Could it be something to do with incorrect grouping? Or maybe logical grouping? This is where I start to get multiplied results: SELECT Requirement.Name, SUM(Script_Status.Run) AS Test_Variations FROM...

OK, I've managed to do the join by the following code. However... now the problem I'm getting is that because it is a join over 3 tables... if I add any more joins, it multiples the result by 3!!! Please help!! Here's the SQL: SELECT Requirement.Name, SUM(Script_Status.Run) AS...

Hi guys, The below SQL statement returns a requirement name and the SUM of the number of number of tests run in each test related to that requirement for Release 10. To filter on a particular release, I need to convert this statement into an equivalent INNER JOIN because 'Tests_run' isn't the...

Thanks for your reply DCrake. After you've declared all the JOINs? Or after each join?

Hi guys, What would be the syntax of a join query when you have multiple joins, and need one of them to filter with a 'WHERE'? E.g. SELECT Table_A.Name, Table_B.Age, Table_C.Address, Table_D.Gender FROM Table_A LEFT JOIN (((Table_B ON Table_A.Name=Table_B.Name) LEFT JOIN (Table_C ON...

Thanks for your reply HighTechCoach. I can't access that site from my work, would you be able to summarise? I'm desperate to get this working! Is there any way of taking some kind of snapshot of the data, rather than a full bind to it? Thanks

They're just sharing from one front end. I would give each user their own frontend, but it's not possible given the network constraints. They wouldn't be able to link to the source. Is there a way to do this with a form? That would be just as good... as long as they can see the results of the...

Hi guys, My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem -...

Hi guys, My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem -...

OK, sure. SELECT Requirement.Name, Test_Status.Number_Passed FROM (tblRequirement LEFT JOIN tblRequirement_to_Test_Lookup ON tblRequirement.ID=tblRequirement_to_Test_Lookup.ID) LEFT JOIN tblTest ON tblRequirement_to_Test_Lookup.TestID=tblTest.ID LEFT JOIN tblTest_Status ON...

I have tried with the query wizard... but I think it's too complex for access to generate. For each row in Table A, there's a lookup table (Table B) which finds the associated value. Table C, which is referenced through the lookup table (Table B) has the associated identifier. Table D then has...