Search results

Ok my friend- this is not an application I developed my self. Those where its thrown to you resolve before end of week thingy. The guy who developed this seemed to have used the Application.FileSearch - as you noticed is the root of the problem thank you for that.. Now, I need to...

Ok - How can i use the Dir method / vb code directing to the code; Sub Search2() On Error GoTo Search_Err Dim strPrompt As String, strTitle As String ChDir AttachmentPath ' Changes directory to new file path Dim i As Integer With...

Ah ! Apparently FileSearch method was taken off in Access 2007 Any way round it ? Thanks

At run time - when I open the form (frm_Enq_Address_Dialog) - A message box comes up with teh message; "File Path not Found (You entered an expression that has an invalid reference to the property FileSearch)" I clicked Ok - same message came up - Clicked Ok same message came up (3...

Hi, I had an application developed with another developer in Access 2003, our company has upgraded our laptops to Microsoft Office 2010 and now when I open a form (frm_Enq_Address_Dialog) I receive an error on Form load as "File Path not Found (You entered an expression that has an invalid...

Ok - fine but I still need to have that at the last of the list.. Its a business type and I cant ignore it at all. If there any approach I could change the query to consider this. There will always be 1 business type that will not be a winner and I want it to be at the bottom of the list...

Thanks pbaldy- Result; BusinessTypeCombined TotalCount TAXI 3 MPESA 2 KIOSK 1 Nearly there - I dont get the businesstype TUKTUK as the last type available. Why? Thanks

Someone out there should be able to help... Thanks

Tried as suggested; SELECT IIf([QryCalcWPM2].[Score]>1,[QryCalcWPM2].[A].[BusinessType],[QryCalcWPM2].[B].[BusinessType]) AS BusinessType FROM QryCalcWPM2 ORDER BY QryCalcWPM2.Score DESC; Result I received was: BusinessType TAXI MPESA KIOSK MPESA TAXI TAXI I want the query to...

Ok - attached is a sample of the database. Please shade some light for me - the problem is in QryWPMScores2 If you open QryCalcWPM2 you'll notice the; A.BusinessType B.BusinessType Score KIOSK MPESA 0.97 MPESA TAXI 0.97 KIOSK TAXI 0.95 MPESA TUKTUK 1.21 TAXI TUKTUK 1.25 KIOSK TUKTUK 1.18...

ThatOtherQuery - gives wrong results. SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; As with the below data; BusinessCombined Score KIOSK/MPESA0.97...

pbadly - I tried what u suggested .. SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM [B]ORDER BY QryCalcWPM.Score DESC; The database is to huge and sensitive to attach.. any hints

Yes, I did change the query to; SELECT IIf([QryCalcWPM].[Score]>0,[QryCalcWPM].[A].[BusinessType],[QryCalcWPM]..[BusinessType]) AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Results Based on the initial query: BusinessCombined Score...

any help please to formulate this query - am working with Access 2003.

How can I do that please?

Hi, I have a query which arranges the following businnestypescombined; SELECT QryCalcWPM.A.BusinessType & "/" & QryCalcWPM.B.BusinessType AS BusinessTypeCombined, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Results: BusinessCombined Score KIOSK/MPESA1.03...

Hi, I am working with Access 2003. I have the following select statement; SELECT QryCalcWPM.A.BusinessType, QryCalcWPM.B.BusinessType, QryCalcWPM.Score FROM QryCalcWPM ORDER BY QryCalcWPM.Score DESC; Result A.BusinessType B.BusinessType Score A X...

Hi, I am working with Access 2003 and when I try to write this SQl query I receive the error; Invalid bracketing of name [SELECT (Select Count ([BusinessType.. SELECT A.BusinessType, B.BusinessType, MPESA.Cri1, TAXI.Cri1, MPESA.Cri1/TAXI.Cri1 AS MTCri1, MPESA.Cri2, TAXI.Cri2...

Ok, 1) a business type can not divide by itself.. Therefore, A/A, B/B etc are not valid. 2) In TblBusType - you select the top business on the list working your way downwards. It's a more one way flow, the reverse is not required.. I hope I have helped in the explanation.. I cant...

Sorry plog, my mistake!! TblBusType BusinessType C1 C2 C3 C4 A 1 2 3 4 B 2 3 4 5 C 3 4 5 6 D 4 5 6 7 So based on the above, what we are doing really is as shown below; So, we have 4 business types A, B, C and D. Each business type has 4 Criterias. Result1 = (A/B)z1 x (A/B)z2 x...