Search results for query: *

Hi Golom, can you help with this.. Any kind of help will be greated appreciated. Thanks

Hi Golom, Appreciate your response. However due to the database being deleted and recreated daily, i would like to avoid any queries within Access itself. While i try to run this query i am running into the following errors in terms of syntax. Since the Access errors are not descriptive enough...

Golom, Thank you so much the queries worked. But i am still trying to figure out how i can run both the queries each time the report is refreshed. Can the queries be written in a .SQL file outside of Access and referenced within BO because in BO at a time i can reference only 1 .SqL file. Any...

Thanks Golom. appreciate your assistance. However is there a way to get the complete result in a single query...? Also my qryMatches will change as additional criteria has been added. CODE Select r.requirement_name as [Functional Specs], tt.[Test Name] as [Test Case] FROM...

The sample data Requirementinfo Table Requirement_name ABC DEF ADK ADM Trace table trace element name Requirementname tracedto MNO DEF BOL ADM BMD ADM ..... TestPlan Table MNO BOL BMD DHD DHFFKFL XUXN The output detail of this query generated is...

BO is Business Objects. The database is Access I am using BO to report out of Access. Thanks,

Hi Golom Thanks but i am using BO to create the report. I am selecting create your own query option to create this query. Not sure how i can create a subquery and then the main query? any ideas?

Sorry about that :-) requirement_id comes from requiremntinfo table root_element_id comes from Trace table. Thank you

The sample data Requirementinfo Table Requirement_name ABC DEF ADK ADM Trace table trace element name Requirementname tracedto MNO DEF BOL ADM BMD ADM ..... TestPlan Table MNO BOL BMD DHD DHFFKFL XUXN Basically it works if 1 requirement is...

hello, Here is my query. select 'MNOP' as [Workstream], count([Functional Specs]) as [Total Functional Specifications] , count([Test Case]) as [Total Functional Specifications Covered ] from (Select distinct r.requirement_name as [Functional Specs], tt.[Test Name] as [Test Case] from...

Hi, Thanks for your response. I am writring this as a query in Business Objects.. can u suggest i can take care of the numbers which dont have decimal in my query? coz it is giving me a error in Row 9 which is the error on any whole numbers 1 ,2 ,3 Thanks again!

Hi, I have a text field in an MS ACCESS table which contains a decimal number. How can the number be converted from decimal to integer. Example String = 10.54 Needs to be converted to 10 and can remain a string... Please help asap Thanks,