records

Hello, I am trying to write a delete query to remove records from a table based on records in another table. There is a common field and I want to delete records in table 80 that have no matching records in table 01 (Below). The query works just fine but when I switch it to a Delete Query, it...

I have a data file of say 60,000 records and each record are up to column K. I need to combine every 3 rows as one row into a new worksheet. Input rows will be: A2 to K2, A3 to K3 and A4 to K4 Output will be on a new worksheet will be from: A2 to AG2 This formula will be for entire worksheet...

Hi, I have a problem that I need to delete the table records before I paste data into it. The problem is once I delete all the records, Excel VBA (BUG?) will not recognize it as a ListObject. Does anyone know a workaround? This code...

Hello: I have a large table where I need to find and then highlight the records that appeared for the first time last month. In case of the sample below, that would be to find records that include Resource C. Thanks for any ideas! Date Resource <tbody> 4-30-19 A 4-30-19 B...

So I'm trying to create a query that will produce an average (totals) column based on the TOP 3 records associated with two other key field values. Basically an average of the three most recent events. I can easily create the query to do the OVERALL averages, but whenever I try to use the...

Hello I want if there is a change in price it should reflect in new records only but should not disturb the previous records with old prices. a link of my file in the drop box is given below. https://www.dropbox.com/s/uq3fyn1snj1ah5y/salarzai%20petroleum.xlsm?dl=0 Password for opening/...

Hello I want to clear some doubts about sorting the following code sorted perfectly Just 1. When rows of records are entered after sorting. Then want to sort it with new records it does not sort. I dont understand Why ? 2. So when do i need to sort. Any particular criteria required for...

I'm doing a very simple report. I have a bolean field that I converted to 0 and 1 using sql CASE. In the virtual view is defined as an Int. When I create the Crosstab, the values column is the column RevSup that I converted to 1 and 0. For some reason is not summing all the records that it...

I have a main form named "frmTagEntry". The Subform is named "subTagEntry". I want to be able to view all of the records in the subform in datasheet view and have them linked with all of the records in the main form in formview. Basically mirror the form in split form view but using a subform...

Hi Team, I have recorded below macro i want to select previous day date and delete all the records but the date remains same when the macro was recorded, Please could you help me with the code to delete previous day records in column X1 and their associated rows Thanks...

I have an excel file as the sample file share link . I would like to have a macro for arranging the shee1 to sheet2. Then I want to compare the sheet2 with another workbook named book1 sheet named Data1 for Invoice No, Item Name, and party name. If work book Data1 don't have such records then...

I have a situation where I want to delete all records in a table - I don't want to delete the table - just the records. Is there a way to do this in VBA (click button event) My table name is "ModelGeneral_vluItem1" Thanks! I really appreciate the help.

I have a very large table of 3 million records that I need to export out of ACCDB in chunks of 500k records at a time. They are sorted in a particular order so their Primary IDs are not sequential. I can easily export out the first 500k by setting the Top Values property to 500,000. Is there...

Hello and thank you in advance if you can help, I am using Excel 2019 on a PC. I am still quite new to Access, so I would appreciate any guidance to resolve this issue I am having, and I will apologize in advance if any of my explanation is confusing. I have a database that is 1,115,1867...

Hello all I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro? Thanks in advance for your information.:(...

For a database I'm working on at work, I've been asked whether it'd be possible to implement something along the following lines: a drop-down box that lists the last 10 accessed records for a user. It doesn't matter whether they were edited, as we often consult the database for information, and...

Hi, I have a file that contains a great number of records as a single, long line of text. The records are delimited by a tilde (~), and the fields within the records are delimited by an asterisk (*). I have second file that is a summary for records in the first file that have some kind of...

Hello to everyone I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?

Hi, I have spread sheet and wants it to be in new order. Existing sheet Records <tbody> Roll No Name Ph1 ph2 ph3 ph4 ph5 ph6 1 abc 0300 677 748 2 def 767 87 3 hij 88 88 88 88 88 88 </tbody> New look i wants as <tbody> Roll No Name Ph 1 abc 0300 1 abc 677 1 abc 748 2...

I need some help. I'm really new to SQL. I’m not sure what I'm missing here and why this isn’t working. Background: I have 2 tables related by an “ID_Key”. Each table contains an ExpDt field which represents an expiration date. These expiration dates may be different between these two...