Search results

works perfectly. Thank you very much for your help.

Hi All, I hope this is going to be quite an easy solution, but it has well and truly stumped me. I am trying to sum the row in a access form. There are 3 text boxed called TXT1, TXT2, TXT3. I have added an additional text box and typed the following txt; =([TXT1]+[TXT2]+[TXT3]) Instead...

thank you very much

Hi all, I am trying to create a Multi list to select reports to send by email. I am able to select one report to send but when I change the list box to multi select it doesn't work. The codes I have been using are; Private Sub Command2_Click() On Error GoTo ErrorHandler Dim sAddr As...

I added the replace function. So problem solved. Thank you all Mark

Thank you It works until it encounters an E followed by a number in the code. It then adds zeros depending on the number after the E. For example; 10E3 = 10000 12E1 = 120 9E5 = 900000 Any thoughts?

Hi all, I would like to run a query which takes a code which contains a mixture of number and letter and returns all the number before the first letter. I was using the left function (=Left(([Codes],2)) but sometimes there is one number sometime two. The desired results are shown below...

thank you very much

Sorry I do not really understand your response. Could you please simplify (dumb it down) for me? Sorry.

Hi All, I have a list of dates and I want 1 query which counts the dates between numerous criteria. for example, colum 1; dates between 1/1/14 and 16/02/2014. Colum2 between 17/02/2014 and 15/04/2014. Sorry if this is very simple. I have attached a screenshot. Thanks in advance