Search results

  1. C

    Sum(Round) gives incorrect value.

    "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.
  2. C

    Sum(Round) gives incorrect value.

    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...
  3. C

    Incorrect Sum on Doubles

    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).
  4. C

    Incorrect Sum on Doubles

    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...
  5. C

    Import Text file into VB(MS access) issue due to carriage returns

    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.
  6. C

    Import Text file into VB(MS access) issue due to carriage returns

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

    Import Text file into VB(MS access) issue due to carriage returns

    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...
  8. C

    Incoming string follows specific character format

    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
  9. C

    Incoming string follows specific character format

    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
  10. C

    Check Number of spaces in a string?

    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
  11. C

    Pick out dates and organise in specified columns

    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...
  12. C

    Pick out dates and organise in specified columns

    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...
  13. C

    Combine 2 rows into one?

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

    Combine 2 rows into one?

    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...
  15. C

    Writing table valuesd to specific positions

    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?
  16. C

    Writing table valuesd to specific positions

    Hi all In the below example, can anyone tell me how id A) Specify what position in the text document A2 is written? I want it next to A1 but starting at a specific position B) Force A3 to be written on a new Line, without moving onto the next member. Do Until rset.EOF = True...
  17. C

    VB DCount per ID instead of whole table?

    Hi all, Im trying to count the number of records i have within a table (per unique ID) where the content = "Y". Ive not been having much luck though, i was trying DCount but it only counts the number of ALL records within the table where Archieve = "Y". I actually want to count all the "Y"...
  18. C

    Max Seuqnce number with a Unique Reference?

    that works, dunno why but it does lol, only appears to be the reversal :x, thanks anyway :)
  19. C

    Max Seuqnce number with a Unique Reference?

    Hi all, Im having trouble with a database query, i have a table that has a large list of Reference numbers, sometimes duplicates. These are indicated by another column that counts the number of duplicates (sequence of the numbers). Ive been trying to create a quey that will retrieve the...
  20. C

    SELECT INTO error (probably small overlook)

    Currently have a series of select into statements which work fine for example: SELECT * INTO R_Tab1 FROM TABLE1 WHERE ID = USER_ID AND Grouping = USER_Grouping AND Ref = 'NewLine'; This is placing the whole line of the record into a variable. Now the issue im having is a select into which...
Back
Top Bottom