Recent content by patnick

Hi, I have a table, t_Expr.Data 25/06/2009 Jefferson Marc Inc 24/06/2010 35.00 Cash 25/06/2009 Equitable Motors 24/06/2010 10,000.00 Cash 25/06/2012 General Indian 24/06/2010 35.00 Cash 25/06/2014 Lincoln Trailer Ins 24/06/2010 20,000.00 Cash 25/06/2015 Lincoln Trailer 24/06/2010 10,000.00...

Thank You Brian!

Could you please help me on this! I have a table T, with values which are mixed of numeric and alphabetic signs. e.g.: 5 - England Greece 2 - USA Germany I want my query to return only the two values 5 and 2 but nothing else. Could you please tell me how an sql should look like? Many...

Hi there, I am stuck and need some help: T_Contacts has a column [Name] and a column [Amount] (Name e.g. Ann-Marie; Mike Turner; Sue Horn etc.) T_Naming has the same names in column [Naming] but sometimes written different (Ann, Mike, Sue) As I have 30 names I try to find an other way...

Many thanks for your help - all of you. I tried it the way datAdrenaline proposed and it works great! You made my day! Thanks a lot!

Could you please help me on this: I would like to convert theText below into a Date and do not find any solution: 0921679 V301239 E060310 97,6% The resulting date should be 06/03/2010 which comes from the text after the E with an added 20.... number for the year. Many thanks for your help...

Many thanks DCrake, but I still have the problem that table2 doesn't receive the information from the combo box: I am working now just with numbers in table1 Then I created the relationship between table1 (OrderNumber) and the blank table2 where the information should be stored. By...

Hi folks, My problem: Table1: with 1 column of names. I created a Form with a ComboBox to select one of these names from the Table. Now I want to use the selected name in a new table (Table2). How do I have to make the link that this name apperas in the second table? Many thanks for your...