Recent content by digit

Hi i have table like this : ID SIZE 1 SIZE 2 SIZE 3 SIZE 4 1 12 14 16 18 2 12 16 3 14 4 5 10 12 I need to be like this : ID SIZE 1 12 1 14 1 16 1 18 2 12 2 16 3 14 4 5 10 5 12 I know that this is very easy but im new. Can you help me.

There is a different types. I need to separate words where is separated by ","

Hello, i have a column with a data Like: Hristo,Vankov Marty,Hristov Ivo,Petrov Hristian,Todorov So my question is how can i split two names in 2 differnt columns: [field1] [field2] Hristo Vankov Marty Hristov Ivo Petrov Hristian Todorov Thank you and sorry...

Thanks, but then how can i store that?

Thanks Many thanks, but how can i write this in a table? Is it possible?

Dear Friends, im very new in MS ACCESS that why i wanna aski you a question. I have a form with 2 text boxes - currency wich is [Amount] and [SubAmount] from table Amounts. How can i create a text box in this form wich can Sum [Amount] and [SUbAmount] in a text box and display. Thanks Veselin

Many thanks It works!!!

Dear Friends, im new in Access but if someone can help me please let he do it. I have a column with data as a samle "8405071214" How can i give from this digits the information like 07/05/84 Thanks

Dear Friends, is there someone who can tell deside my problem. I have the table with columns: ID, Date, Days, Total 251 25.01.2004 5 254.68 $ Where Days 5 is how many days i was have the same sum. How can i make an inquiry : ID, Date, Days...

dear friends, is there someone who can tells me how can i separate more digits. Examples: 112244554455,54 1234567897898,57 128761237836,89 So, from first digit i wanna to get 55.54, from 2nd - 898.57, from 3rd 6,89. And to make 2 colums - 1st only first 10 digits - 2nd column - the other...

Re Thanks, but can i do with ACCESS?

Is there anybody who knows how can i make my MDB to starting automaticaly in every friday

I have a query : pol: IIf(Right(CStr(CInt(Mid([EGN_zastrahovasht];9;1))/2);1)="5";'æ';'ì') but when i try to start it access give to me "Undefined Right function" Any idea!!!

re to convert into currency!

Is there someone why can tell me how can i convert a Digit in a Word??