Search results

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.

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

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