Search results

  1. W

    Hello From NJ

    I have some knowledge of MSAccess, but I will like to used vba in some projects that I have in mind. I used to work with SQL server, but I have not used or written any sql for about 10 years.
  2. W

    Mapping Previous record to next record

    Thank you Arnelgp. The sql work, but I had to exclude the ORDER BY yourTable.Per_No; because the output was order by Per_No not by grant number. Thanks you.
  3. W

    Mapping Previous record to next record

    Hello I'm trying to map a previous Fractional value next record. I believe is like adding the carrying forward to the next record. Original Table Query Output Grant id Per_No Vest Date Shares Fractional Grant id Per_No Vest Date Shares Fractional 12345 1 6/15/2021...
  4. W

    DUPLICATE RECORDS with different Id

    I did the the first table, when I join them to the original table I getting the same results of the original table. I tried doing a crosstab query but when I put the id as column is not the solution.
  5. W

    DUPLICATE RECORDS with different Id

    Yes, but how will i be able to pull them into two columns?
  6. W

    DUPLICATE RECORDS with different Id

    I under stand the how to do the duplicate query, but I don't understand the second query.
  7. W

    DUPLICATE RECORDS with different Id

    I have a table with duplicate record on SSN but the id is different. I need to create a query that will have ssn and the id side by side. please see sample. Table1 SSN ID 123456789 l654 123456789 T458 Query output SSN id1 id2 123456789 l654 T458
  8. W

    New Member

    Thank you for the code. As I mention I'm just learning VBA. I understand some of the code. For example I know this code is for a comma delimiter file and that case statement is where the fields are being populated. I kind of understand the if statement, the one thing that is throwing me off...
  9. W

    New Member

    I copy text files from the server to my desktop. I'm using windows 7 and 2010 msaccess. the files are pipe delimiter. Sorry I'm new to using forum and I was not able to find a thread General or VBA. CorpID|EmpID|GrantNum|GrantDate|Grant/Award|Granted 100|9996532|45687|27721|G|1000...
  10. W

    New Member

    Presently used MS to do file comparison by creating queries. MY objective is to create a vba code that will be able to filter data from the file before importing to a table. Example importing a file with a million records, with a field indicator for the type of record. The indicator values...
  11. W

    Hello, I'm a new member.

    I used MS Access to do a file comparisons. I import and export data very often, but presently I been running into issues because the files I'm importing are too large and the queries are taking too long. I will like to start using VBA to performs this task. My present objective is to be able...
Top Bottom