Recent content by captainquigers

I was using the function builder in Access and unfortunately don't have the option of using the split function. The InStr and Left commands worked fine though. I'll have to start looking at using VB to manipulate data. It looks far more flexible. Thanks for the answers, Cheers.

Cheers mate. That works a treat.

How would I go about removing unwanted spaces from a text string and all text to the right of this? e.g. "xx1 pl5605" -----> xx1 "g8 jj77" -----> g8 I've tried various combinations of trim and clean but can't get them to work. Please note that there can be any number of spaces but I...

I have a table that contains a single field. The data in the field is a contact salutation for an account holder, e.g. Mr Bob Smith & Mrs Julie Smith I need to create a new table with this information normalised e.g. Original Data Title1 First Name1 Surname1 Title2 First Name2 Surname2 The...

I have several tables with the same schema containing monthly financial data. I would like to create a form so that users can select which of the tables are queried when requesting data. The naming convention for the tables is as follows; 200404 200405 200406 The contents of each table look...

The function you would use is Left (x.x.x.x,3) This would give you the first 3 characters of the sequence i.e. "x.x" If you group on this it will give you the answer you are after.

How would I roll up records based upon which band a value lies in? The data looks like this; Field1 Field2 1 48.25 2 12.68 2 98.16 7 12.36 8 67.46 12 46.64 15 45.89 And I would like like the query to output; Field1...