Recent content by gingerboy

Just realised a problem... forgot that sometimes x might be 2 characters: 1.2.3 10.1.2 1.12.1 The expression above gives me 1.2 10. 1.1 Is there any way i can use the "."? Ta

Cheers, Solved it Thanks Very Much

I have a field which contains a reference code which can be of different lengths: 1.2 1.2.3 1.2.3.4 2.1 2.1.3 2.3 5.3 4.2.3.1 (these are nested categories, i.e. 1.2.3 is part of 1.2) I currently have a query which is grouping by this field, but would like to group by the first two (i.e. x.x)...

How do i use this code? Will it force the capitalisation in the stored record, or does it only format the text in a form? Cheers

Is there a function whereby i can capitalise the initial letter of each word in a field. I have managed to get Access to capitalise the whole field with '>', and using input masks, i've managed to have the first letter of the field capitalised, but i want each word to be capitalised (it is a...

Thanks for the helpful comments guys, I decided to go with the firs one (it seems more simple for me to implement and as the groups only appear in 2 places, editing them won't be too much hassle although hopefully i won't have to anyway. i've manged to get it working and all seems well... cheers

I currently have a query which returns two columns, one detailing the age and the other returning the number of items this is done using a count query I need this data as ranges rather than absolute values, i.e. rather than a list of 17 years 1 item 21 years 1 item 22 years 13 items 33 years 1...