Search results

getting a complile errort on If Msgbox ("Import data is ready with todays date click yes to continue or no to abort import.",vbInformation+vbYesNo) vbYes Then

so i just need some code to check a linked table field Importing_Date is todays date, rather than yesterdays which means the linked table hasn't yet been refreshed message box to say date is current or date is not current before the query runs to copy data into access tables?

So the check is just that the refresh date in the linked table is the same date as when its run, to ensure that the user is importing current date data, i already have an index thats stops duplications

Thanks for your thoughts, however i do need this data check as the user would not know that the linked table data has been refreshed so its like a check table data has been refreshed to carry on or check again in an hours or so

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

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