Search results

So now need to do the same for an Excel spreadsheet and the above working code for test file doesnt work so a tweak is needed

This looks like a solution to what i am looking for but where is the output stored in a table?

Thanks for your help stuck on the qryRank_Crosstab now

Would only ever be max of 2

Customer_ID Order_Date Order_No Item_Code Pick_Bin A14212 19/06/2025 111 444242 5 A14212 19/06/2025 111 444242 9 A55545 19/06/2025 222 24242 4 A55545 19/06/2025 222 24242 5 A87788 19/06/2025 1145 4242 1 A87788 19/06/2025...

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

Thank you that works :)

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

yes that works Query3 Period Expr1001 2. Between One Week And One Month 1 4. Between Three And Six Months 1 5. Greater than Six Months 2

Thanks for the post so i tried this and it didnt work.. SELECT t.Period, Count(*) FROM ( SELECT Switch(DateDiff("d", DateOrdered, Date) < 7, "1. Less Than One Week", DateDiff("m", DateOrdered, Date) <= 1, "2. Between One Week And One Month", DateDiff("m", DateOrdered, Date) <= 3, "3. Between One...

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?

I know this is an old post but did anyone get this working as i need to do the same create a a table with todays date within the title?

currently using find and replace "WeekNo",3123 to "WeekNo",3124

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

Ok thanks, i am, going to use the robocopy and run from a bat file as think that's much Easy to do thanks anyways

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

Running well now thank you :)

thanks also had to change With .OpenTextFile(path, 2) to With .OpenTextFile(col(j & ""), 2) running now...