Search results

Thanks for you help with this - that did do something but what I am trying to get is in the table for field 1, I have say for example '00002' (and numbers like that i.e. 00003 however when I created the sql union query they became in column as just '3' or '2'. Please can you suggest what you...

I have the following SQL statement set out in my union query. SELECT [Field1], [field 2] FROM [Table 1] UNION SELECT [Field 1], [field 2] FROM [Table 2] However I need to make field one numeric, so I can have this 00000 format in the column. I think I need to do this by using CAST and...

Thanks Neil - i am going to try that now. However where in the SQL statement would I put that. you know it the one I have set out in my message you replied to . Thanks again. Nats

Format Nightmear I have just tried putting in like this but comes up syntax error. SELECT ([Column name]"00000"), [column name 2] FROM [table name] UNION SELECT ([column name]"00000"), [column name 2] FROM [table name] I also tried just using this ' symbol in place of the ". Do you have...

Format :) Thanks for your reply. I haven't tried that but where would I put that in my SQL Statement? you know when you do: SELECT [column name], [2nd column name] FROM [table name] UNION SELECT [column name], [2nd column name] FROM [2nd table name] Its the first column that I need to...

Hi everyone, Please would someone be able to help me? I have created a union query however, one of the columns, has not picked up the same format as it has in the tables. As in the tables it has this format '00000'. Please woud you be able to advise me how I can change the format on one of...