Search results

  1. V

    Group By in a Median Query

    Can you provide an example in how to add additional grouping levels (to the Function Module and to the Query)
  2. V

    Group By in a Median Query

    This is great. Thanks! Is is possible to group by multi levels in the query?
  3. V

    Group By in a Median Query

    MedianF Grouping I was able to get your function to work but I noticed that it only returns the value of one type (t1, t2) in the table. Is there a function to have the query return the median value for each type and show ALL median values by type in the same query (refer to original sample...
  4. V

    Delete Query Message.

    I am very novice with visual basic. Where do I put this code? or is there a way to put this step into a macro?
  5. V

    Convert text field to number field but keep leading zeros

    I need to keep the leading zeros due to it being the employee's ID/SS#. Also, I already tried the formula below in Excel and it didn't work (and this was the only thread I could find regarding this question)--- =Format(YourNumber, "000000") When I enter this formula, I receive a #NAME error...
  6. V

    Convert text field to number field but keep leading zeros

    I need to convert my text data to a number but when I convert using the VALUE function or use "format cells" to the numbers category, I loose the leading zeros. I need to keep them for sorting purposes. What formula do I use?
  7. V

    Compare value with nextrecord in Query

    I have never worked with bookmarks. Can this be done in a query? If so, can you tell me how to do this?
  8. V

    Compare value with nextrecord in Query

    I probably didn't give enough information. My reason for comparing the values between rows is not to find duplicates so the "findduplicate" query will not work. Maybe I should explain further what I am needing: I receive an import from a database where the data comes in as follows: Name...
  9. V

    Compare value with nextrecord in Query

    Is there a way to compare the value in one field with the value of the same field in the next record? I can do it in Excel by using the following formula: =If(A1=A2,"Match","No Match") But I need to be able to do this in an Access query? Any ideas?
  10. V

    Need help with left margin in Access Report

    Your suggestion worked. Thanks so much!
  11. V

    Need help with left margin in Access Report

    I have two text boxes (Text1 and Text2) in a report. When the value in Text2 = 0, I want the left margin of Text1 to change to a new position on the report. I tried the code below: If Me.Text2 = 0 Then Me.Text1.Left = 3.5 Else Me.Text1.Left = 2.5 End If This didn't work. Does anyone know how...
  12. V

    Change left margin in an event procedure

    I have two text boxes (Text1 and Text2). When the value in Text2 = 0, I want the left margin of Text1 to change to a new position on the report. I tried the code below: If Me.Text2 = 0 Then Me.Text1.Left = 3.5 Else Me.Text1.Left = 2.5 End If This didn't work. Can anyone help me with the...
  13. V

    Conditional formatting, please help!

    I am needing this answer as well. Did you find a fix for this problem?
View older results
Back
Top Bottom