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 bkrike 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: *

  • Users: gingerboy
  • Content: Threads
  • Order by date
  1. gingerboy

    Separating Out Fields

    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)...
  2. gingerboy

    Formatting of fields

    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...
  3. gingerboy

    Group age data into age ranges in access query

    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...

Part and Inventory Search

Back
Top