Search results

Thanks for your suggestion. I could do the sorting as you suggested. That was not the problem. The challenge is in getting the ranking score inserted based on the result of this sort. If you see the attached spreadsheet, the creation of the data in the highlighted column named Ranking is the...

I have a certain set of data that needs to be ranked based on sorting on 5 different data fields. The ranking is based on sorting at 5 level 1. Location 2. Category 3. Unit 4. HireDate 5. Seniority Score The ranking has to be within each Location and within each category and within...

Thanks for your response. I am going to try this solution. Will get back to you if it doesn't work. But before I try this more complex method, let me ask a simple simple question. Currently the Where clause begins with WHERE ((([Forms]![Analysis].[cmbLocation]) Is Null) or...

Thanks for the response. My query returns a set of multiples records. I guess you suggestion will not work that instance.

After trying more complex tricks, I realized this one is the easiest. For some reason it did not work the first time and I discarded this solution. But this is the simplest one. This is how my query looks like now. The change is highlighted in red. SELECT tblLeaveRequest.Location...

I know how to display all the records if no parameters are selected on the form. But my user is adamant about having the "All" option in dropdown menu and he would like to see all the records if that option is selected. Currently, the query would display all the records if no selection is made...

Perfect solution. Worked like a charm. Thank you, Thank you, Thank you... Can't thank enough.

I did try using text box first. At that time my code looked like this. During the runtime, the text box was showing the select statement instead of showing the result of the select statement. Private Sub Approved_AfterUpdate() Dim stApproverName As String stApproverName = "SELECT...

I have a combo box called Approved. If I select YES from the ComboBox, I want a listbox named ApprovedBy further down on the form to get the name of the user logged in. I put the following code in the AfterUpdate event of the combo box, but it is not generating the value in the list box. I would...

The database is too big to attach. It has too many odbc linked tables. Attached is the screenshot showing the datatype.

I tried changing to where instead of having. It still gives the same error message

I did what Bob suggested. It just allowed the query to run, without generating error message but did not fetch any records.

The query works perfectly if I remove the filter from the activity.starttime field. I have to use group by to eliminate multiple instance of the record. I guess I have to keep having clause with the group by.

I am not sure why I am getting this error message. I did use the datevalue function to extract the date part from the field in an odbc linked table Given below are two different version of the queries that tried. Could someone please point out what I am doing wrong. SELECT LOCATION.NAME...