Search results for query: *

I have the following line of code... DoCmd.TransferText acImportDelim, "Chart Import Specification", "tblMeterReads", fileName, True, , 1252 I can manually run chart import specification with no problem. When I use DoCmd TransferText it imports all of the records, but skips a field that...

Hi, My work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx, because the default filename from the third party has special characters in it that are not compatible with access import. The import works...

I have a field [Bill Period] as short text. The data is provided to me as such, "11/07/22-12/07/22", which represents a start date and an end date. I extracted the start day and formatted it as a date using the following expression. StartDate: CDate(Left([tblWegoWiseSpikes]![Bill...

First, allow me to explain that I know just enough about Access to impress someone that knows nothing about Access. I'm just getting my feet wet with VBA and do pretty well with queries in design view, but i'm not great with the written form of SQL. I was able to use a combo box value to...

I imported an excel workbook file with 6 columns and 1000 unique rows (=1000 unique records). Using my newly imported table, I created an index using 3 fields and set the index value to unique. I know it to be true that the combination of all three fields is unique in each record and this is...

I have a table with water meter reads every 15 minutes in excel. I want to filter the rows so that only the meter read at 2:00 shows every day. I have tried this using filter and it forces me to expand every day and select the hour. Is there shortcut to select only the 2:00 hour of each day...

Hi, I have created a one to many relationship. When create my Power Pivot Table, every value from the second table is shown for each value of the first. For example. If my primary key is Street Address. Table1 has only one record for each street address. Table2 has multiple records for...

Hi, I have two tables. One has Building Characteristics and the other has utility billing data. Each has a street address field. The building Characteristics table has one record per street address. The Utility Billing data has many records per street address. The street address field is...