Search results

So i am looking to add a check to a process that copies records from a linked table into another, but i want a pop up to check if the data withing the linked table is the same as now.. something like.. Import data is ready with todays date click yes to continue or no of the date is not yet...

Hi, Looking for some help i need to split the results of file Pick_Bin into two separate columns where the order ID is differnt Table fields are: Customer_ID Order_Date Order_No Item_Code Pick_Bin Looking to get output like this.. so where the Pick_B results are 1 or 2 split into new columns...

Hello, I am looking to have a query total two different fields from two different queries and then subtract one from the other, its working when query 2 has data .. SELECT Q1.[Postcode Area], [Q1].[PR1]+[Q1].[Non_PR1] AS Q1_Total, [Q2].[PR1]+[Q2].[Non_PR1] AS Q2_Total, [Q1_TOTAL]-[Q2_TOTAL] AS...

So i need to create some bulk emailing, using the subject and body stored within a ms access table Table would look like Subject Body I want to use VBS to send email using the data within the table, is such a thing possible

Hello, So i need to have a query output the total figures of orders by age brackets as per the below. Number < week old Number >1 week but < 1 month old Number >1 month but < 3 months old Number >3 months but < 6 months old Number > 6 months whats the best way to do this please?

so i am looking for a quicker way to update some excel workbooks. I have the data in pivots and use the following to bring the data into the workbook required, each year i have to update each cell to bring in the new years results it takes hours to do and its mind numbing too...

Hi so i am looking for a way to automate copying file from a network folder to a local folder, using say a table that logs the last file date copied? was thinking FileCopy "some_network_drive\*.txt", "C:\importing\" but this wouldn't copy the last few days but all in folder so guessing i...

Hello, So i need to have the query show one line per customer order, the fields i have are as follows Order_Date Order_Number Product_ID results i see is Order_Date Order_Number Product_ID 25/06/2024 592572 RRW01 25/06/2024 592572 RYTA02 i would like to see then...

I am looking for a better way to import txt files rather than me having to select the file and then import all the files are within 1 folder

Hwllo, so i am trying to confirm a date string and format as date 20231129 would be 29/11/2023 what's the best way to confirm via query

I am trying to get this working i have a pivot that is showing at the moment three month columns. I want to count the number of rows within the pivot that have data which is a number =COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals) =COUNTIF(R10:R150000, "<>")-1...

Hi So i need to remove the prefixed number from "ACC/0014471211" to "0014471211" whats the best way to do this with a query?

how do i copy this formula to all rows =COUNTIF(A:A,A112911) if i drag it it changed the row number =COUNTIF(A:A,A112912) =COUNTIF(A:A,A112913) =COUNTIF(A:A,A112914) =COUNTIF(A:A,A112915) and so on..

So i need to break up a report that is provided in a continued string of data.. A1215455545444444842121212121212121TTTRTR2TR2TY2212121212212122121 The data will need to be broken out as following.. Record type String 1 Always "A" Supplier ID Numeric 5 XXX01 where XXX is the 3-digit...

So i now need to have some code to get the latest date from three possible fields Field names are Phone Email Text, this is what i am looking for as the outcome Phone Email Text Latest Contact 12/05/2023 21/10/2023 21/10/2023 01/11/2023 31/10/2023 01/11/2023

So i am trying to bring back in a query the results of all call made after another date field or is null, but its only bring back null records, even though we do have calls with dates i am using "Contact_Date" >=[Start_Date] Or is null

So i need to add leading zero to a set of numbers within a table that i imported into databricks from a CSV in doing so i lost the leading zeros, the format of the number should be like this 0999 0010 0009 i have 999 10 9 i tried this UPDATE Test table name SET IID = '0' + IID...

I am looking for a way to have the form highlight any names that greater than in characters First Name <20 Surname <30 any pointers please?

I am trying to get this to work in a sub form, to highlight the customers number in red and yellow background but its not working, the field in a text field DCount("*","Customer_main","[Service_Number]=" & Chr(34) & [Service_Number] & Chr(34))>1

So some of the data that comes from another data source has duplicated records for the same customer i need to have these combained into one query record. I have tried to use the "Unique values" but its still puling the same two records for the same customer?