Search results for query: *

I thought that there would be an easier solution like doing the parsing while reading from the file and before porting the data into the access table..... I will try it out and see if I can do the left and Trim while readingthe file , line by line Thanks Nikos

Hi to all I have a text file which looks like the following 1,6345 1 2,0514 2 2,7129 2 5,8571 1 6,6885 1 7,7595 1 8,3747 2 9,2340 1 10,7079 2 11,3166 3 13,9199 2 14,1235 3 etc...

I have a form based on the Data of a Table A(class Left Right. Then I try to Enter in the form the total records of a Table B(Time NumberofCust) When I nsert the textBox holdind the =Count(B!Time) in the Reports Header I get the message Enter Value for B!Time and when I Insert the textbox to the...

Thanks your tip was very nice Actually All I needed was [Expr1001]/SUM([Expr1001]) which solved the prob... Nick

ok I found it out .... it can be done by modifying the text box properties that holds the value... It may be useful to smn Nick

The title counts for All I need!!! I have an expression and I get numbers like 1,11101091 etc I need to round the number or truncate the fraction part... I would really appreciate any help Nick P.S.> I couldn't find anything in the expression editor...

Hi... I have a report bounded to a query which returns two fields class,Expr1001(both included in the Report)[3 Rows]. I Also have another query that returns Expr1000.[1 row] (the Expr1000 contains the sum of the 3 rows of Expr1001) In order to produce percentages % I need to produce the result...

Hi to All I hace a data file containing just 3 Numbers. something like 1 2 3(1 space between Numbers(all positive)) The file has to stop at the end of the third Number(no spaces or newline vhars after that). I read the file from a Form I have build in Access, I change the values of these...

Yes I was a bit umbiguous out there. I mean 10.12(instead of 10,12) and actually refering at a time point. The Second Table Contains the (continuous) Time duration for each Class, while the classes can be repeated... The end Value for each time period is the first of the next one (in maths...

Hi to All... I have the following Table(Not fixed length) Table A: Time Class ------------- 10,12 A 11,2 A 12 B 13 B 14,3 B 15 A 16 C etc... And want to produce a more synoptic table with the same info B... Table B: LowBound UpperBound...

Hi to All... I have the following Table(Not fixed length) Table A: Time Class ------------- 10,12 A 11,2 A 12 B 13 B 14,3 B 15 A 16 C etc... And want to produce a more synoptic table with the same info B... Table B: LowBound UpperBound...

Ok I just not have any previous experience in recordsets , and thats the reason I need a push... Nick

Hi, to all members This is my first appeal to the forum...but I think its a tricky problem... I have a table of the following form Time DataClass 1.2 A 1.3 A 1.4 B 1.5 C 1.6 D 1.7 D 1.8 A 1.9...