Recent content by chris-uk-lad

"The field type on the value is (Double, Fixed, 6dcp). " But anyway, your suggestion of 1000000/1000000 has worked :) thanks alot for the help over the last 2 days.

Hi, I have along list of values of which i need to sum together. The issue i have is, with the list (sorry in advance): 3812.743271 326.475432 236.291316 224.359102 221.09061 221.037702 220.97087 220.913642 220.863603 220.802808 220.737501 220.673351 220.473682 220.390728 220.319768...

Im don't believe round will be enough for the larger values with 6 dcp and i have to sum together 50+ values (as i'm trying to find those that equal zero eaxactly after the sum).

I have a table of numeric values (Double, 6dp, Fixed), when I try to sum these together in a query I get incorrect results (e.g. 100.8 – 100.7 = 9.99999999999943E-02 instead of .01. I’ve tried experimenting with the data type, making them standard instead of fixed, using CDbl/CLng, aswell as...

Thanks for the help, i'm actually running a line-by-line method (while not EOF) but this interprets the full string as being one line, making EOF true and not allowing me to even process the string.

I'd really appreciate if anyone could give mt he slightest direciton of which to follow on this, just has me stumped.

Hi all I currently have a text file which is interpreting a number of columns as one long string, due to carriage returns (Chr$(13) i think?). I have been having trouble trying to import this text file into an MS Access table using VB code but cannot work it out. So far my script will read in...

i appreciate the effort but its not about making sure the 3 and 6 are numerics, i actually need the string to 'look like' ***-****** e.g. 100-102010 its a validation to make sure no values come in that may resemble 100102

Im trying to make sure an incoming string follows the format ***-****** but the below line doesnt awknowledge values that do follow the format If val1 = "***-******" Then Where each * is a number or character. What am i doing wrong with this :s Many Thanks

Hi all, I'm trying to run a validation in some script to check a string and find how many of the characters (max string length of 50) are a space. Thus 'ACC1 NEWTYPE FLEET' would return a 3 is there a method you can suggest? Many thanks

This count (and the following query) worked fine for 1 member but once i entered several more members, it then counted for all members in the table so instead of the count being '1', '2', '3' it became '1', '4', '8'. Is there a way to keep these in sequence upto 5? Ive tinkered with...

Hi all, I currently have a table with values at certain periods. Does anyone know how i can use a query to create a new table that identifies the dates. E.g the first table is like: MEMREF, DATE, VALUE, STATUS AAAAA1, 01/01/01, 10.00, A AAAAA1, 01/01/01, 14.00, B AAAAA1, 01/01/01, 7.00, C...

Thats worked fine, thanks for the info, i just couldnt get my head around how to do it.

Hi all, I am currently running a query which takes values from 1 row, alters them and appends a new table but im now using data which often has several lines per member, where the additional lines contain information not found in the first line. So, for example, i have JAMES, WESTWAY, L17...

appreciate it, will use: ((rset!A1& (String(30 - Len("&rset!A1&"), " "))) Any advice on how to use the same members information on a new line? before switching to the next membrer in the recordset?