multiple updates in parallel in access

[gavsath]

hi,

I have a database which lists a number of car rental records, each with the associated length of car rental - e.g. record 1 has rental length of 2.3 days, record 2 has a rental length of 5.2 days etc. etc.

What I would like to do is add a field which characterises each record by the following category
rental length <2 days
rental length 2 - 3 days
rental length 3 - 4 days etc

I can definitely do this by running update queries in sequence. is there a smart way in which I can get the table to update the table all at once? any suggestions gratefully received!

many thanks

gavin

 

[Norie]

Is that all the categories?

I would suggest creating a user defined function, something like this:

Function RentalCategory(RentalLength) As String

    Select Case RentalLength
    
        Case Is < 2
            RentalCategory = "Less than 2"
        Case 2 To 3
            RentalCategory = "Between 2 and 3"
        Case 3 To 4
            RentalCategory = "Between 3 and 4"
' add other categories as required
        Case Else
            RentalCategory = "Other"
    End Select
    
End Function

You could then use this in your query.

 

[gavsath]

i love you guys. don't know what i would do without this site. thankyou

ps how do you learn all this stuff? are there any books you could recommend to learn the code? i have the access for dummies stuff but feel like i could get deeper into this

 

[mdmilner]

How do we learn this stuff?

Why do you think we're answering questions anyways?



Note: Each question above is the answer to the other.

Mike