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