Recent content by electricbanana

Hi Bob, Many thanks for that. It does the job and I've learned sth new. thanks again eb

"%zz%" try "*zz*" I'm not sure what the % sign is for tho.

Thanks for your reply Wiklendt, 1. the numeric value will be only integers, its basically engine displacement. 2. the left 2 columns show data thats in one of my tables and the 3rd column is what I want to calculate with the query. 3. The algorithm: If <125 and scooter then SC125, if less than...

Hello, I've been working with access for some time now on and off but never really got to grips with functions. I have a table with one field containing numeric data and an adjacent field with text data. What I want to do is create a calculated field to create a set of categories. I want to...