Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alevol

    Chip Pearson's DistinctValues fctn, Run-time error '13': Type mismatch

    Hi All I'm trying to use Chip Pearson's DistinctValues() function (http://www.cpearson.com/excel/distinctvalues.aspx) which should be pretty straightforward (following is just the relevant code): Dim SdqAllIDsSSRSArray, SdqUniqueIDs, BigBoxArray() As Variant Dim LastRowSdq As Integer...
  2. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    Thanks a lot MajP I had tried using the VB code before, but it hadn't worked, and since I don't know VB wasn't able to figure it out. I can see from what you posted tonight that there were extra quotation marks in the second parameter of the getTscore function in your original post, and...
  3. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    Hello again I wonder if you can help me figure out a quite bizarre result I'm getting. I've gone ahead with the overly complicated query, since my database already has data in it and I can't really redesign it right now. The good news is that once these scoring queries are finished I won't have...
  4. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    Thanks a lot for the advice MajP and dhookom. I will definitely check out At Your Survey for future projects. But for this one this has been a lot of help. I am a psychology researcher and not a programer, so my solution was probably much simpler conceptually than it should have been. Using one...
  5. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    Hi MajP Thanks a lot, this makes lots of sense now. There is one table for each one of the questionnaires we use. The one here is a questionnaire that asks teenagers about their behavior. According to scoring rules for the questionnaire, the answers of certain questions are added and this makes...
  6. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    The database is for collecting questionnaire scores related to symptoms. I have a query which adds up the raw scores. Then another query matches each raw score with a statistical T-score, according to a distribution specific to each diagnosis. So, the example above is a little snippet from the...
  7. alevol

    Switch vs Mapping Table (how to use "greater then or equal to")

    Hello All I've been using Switch() in queries, but want to change to the joined Mapping Table method discussed in thread701-1556644 An example of the Switch I was using in the SELECT statement: Switch( Schizophrenia_SeveritySum_Twin1 >= 12, 78, Schizophrenia_SeveritySum_Twin1 = 11, 76...
  8. alevol

    Altering validation rules for all fields in a table through VBA

    Hi all. I'm new to Access and VBA. I have to change the validation rules of every field (except the record ID) in several tables that have about 200 fields each (they were made to for entering the answers of research questionnaires). I'm thinking the best way to do this is with a VB script. I...

Part and Inventory Search

Back
Top