Search results

  1. M

    Challenge with Access2000

    The previous Nth Select related string was getting too long so I chose to start afresh. I can't seem to get either of the attached codes to work with Access 2000. These were working fine as long as I was using Access97. I've tried using "Dim dbs As DAO Database" instead of "Dim dbs As...
  2. M

    Delete Special characters

    My Phone field has values like (626) 123 5555. How can I delete the brackets? All Help is appreciated
  3. M

    Crosstab Query

    A CrossTab Query needs minimum 3 fields [Column Header, Row Header & 3rd field is used for calculations: sum, add etc...] Can a CrossTab Query have multiple Rows & Columns that use the same field to calculate? All help is appreciated.... Regards,
  4. M

    Crosstab Query with Multiple Rows & Columns

    Crosstab Query with Multiple Rows & Columns A CrossTab Query needs minimum 3 fields [Column Header, Row Header & 3rd field is used for calculations: sum, add etc...] Can a CrossTab Query have multiple Rows & Columns that use the same field to calculate? All help is appreciated.... Regards,
  5. M

    Update Query

    I am trying to run an update query. Am using Date/Time field to define a criteria for this query but Access97 returns "Data Type mismatch error" every time I try running the query. The field I'm trying to update is a Text Field. The Criteria statement allows for an update if the Date for that...
  6. M

    Update Query

    I have a table where I want to selectively update records. For e.g. let's say my table has 1000 records with appended "Record Type" so my 1000 records can be grouped into 4 equal parts of 250 records based on "Record Type". I intend to be able to append "Record Types" to the smaller groups...
  7. M

    Select Query

    I've got a field with all kinds of data, e.g. 1235*285 10*258 1234567 89898750256 I need to select fields: without any special characters, where the field has 7 numeric characters as "1234567" above All help is much appreciated. regards,
  8. M

    Strip Leading Spaces

    Apologies for bringing this up again!! I could really use some help with "How to lose leading spaces in a string" Thanks for all help
  9. M

    Record Match Query

    Here's what I have: 1. Field1 with Names 2. Field2 with their IDs 3. Field3 with another list of names where some values might be equal to or similar to Field1 4. Would like to populate Field4 with respective IDs from Field2 where Access deems either: Field1 = Field3 OR Field1...
  10. M

    select odd or even records

    Can someone guide me in writing a query so I can select either all Odd (1,3,5,7..) or even(2,4,6,8...) records from my table. I have a Sr# field with "Autonumber" format. All help is appreciated. Manu
  11. M

    Nth select

    Is there a utility which can select records using "nth select" so an even representation can be selected from a given data set
Back
Top Bottom