Problem with query

Mudface · May 1st, 2002, 02:50 AM

I have a query set up on a master data Excel sheet to extract various columns and put the details on to a 'Timesheet' (again Excel). My problem is that the project nos are not all being pulled through. Some of them are a mixture of text and nos (eg XXX123) while others (the ones not being pulled over) are just five figure nos. Does anyone know a way around this? Thanks in advance for any help.

Mudface · May 1st, 2002, 03:22 AM

OK, sorted it (I think

). Use text-columns on the existing data, format the column as text for any additional data added afterwards. Jeesh.

Jack in the UK · May 1st, 2002, 01:36 PM

Hi Mudface

sorry mate did not see this else could have advised worth remember t to c cover many issues in downloads.

watch them arrows lines can be off the mark thou:

May 1st, 2002, 01:36 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Mudface sorry mate did not see this else could have advised worth remember t to c cover many issues in downloads. watch them arrows lines can be off the mark thou: __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 02:50 AM	#1
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I have a query set up on a master data Excel sheet to extract various columns and put the details on to a 'Timesheet' (again Excel). My problem is that the project nos are not all being pulled through. Some of them are a mixture of text and nos (eg XXX123) while others (the ones not being pulled over) are just five figure nos. Does anyone know a way around this? Thanks in advance for any help.

May 1st, 2002, 03:22 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	OK, sorted it (I think ). Use text-columns on the existing data, format the column as text for any additional data added afterwards. Jeesh.