Search results

So I need a query to say "Yes" if a Date is Greater than another, this is what i got but its not working... Expr1: IIf([MaxOf Installation Date]>[MaxOfContract Start date)]=True,"Yes") This is showing "Yes" when the dates are Install Date is 18/05/2021 Start Date is 05/03/2022

Thanks going to add a week No field and use 1 table

Becuase the data changes week on week and we never want to over right any data, also the records are very large so separate tables will be best

So i have a database that creates a new local table which is created using a week number like LocalTable_Week1 I need to get access to have a query/vbs to then move the database from the local table to the oready created blank table for the same week number like Master_Records_Week1 what's...

Thanks for your pointers, i have now created a new table and have a vbs to rename it adding the current week number, and have also changed my code so when i export the table to excel it names the file with the current week number too so all sorted. will share code in a bit

is it possible to rename a table ending with the current week number it was created and or export the table via a query ending in the week number it was generated ?

I need to add to a query an extra column that would say [SN] [SN_REQ] 123 RR554554 If the two above have data in a new field say called "Match" write Yes *** Its ok i have just used an update query ***

Thanks so i need both or two options?

I need to convert this date layout... 2017-10-27 00:00:00.0000000 to 27/10/2017 is this possible?

I need to add a formula to a query to report as if data is found in one column write in a new column something like Machine_SN New Column 23GGGED11121212 BlueShark Brand So machine_SN if its populated - say BlueShark Brand ?

I am looking for a way to consolidate multiple rows into one line for the following results Customer_ID Start Date Last order PkID Last Contact Name 1444 01/01/2022 1444 28/06/2022 1444 323232 1444 Bob Smirth Output required... Customer_ID Start Date Last...

That worked, thanks

So i have a filed that is set as text and i need to convert as follows.. 22/07/2022 12:00-16:00 from the above i need to take the date and time window and split them. 22/07/2022 12:00-16:00 is this possible?

Can i add a button to a data entry form and on clicking it would get the customer details from a customer table, was thinking of as they type the account number it gets the details and auto fills the customer contact, address ect

So i need to have a query to show any customers details that have changed in a master table v a local table Cus_ID Phone_1 Phone_2 Email I have the same fields in both tables i need to have the query look at Master Table (Customer_Master) and Bring Back any records that do not match the Local...

Did the job thanks

Is it possible to have an update query to add a missing 0 to a telephone number

Worked 100% :)

Hello, I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to > [Delete_SetDate].[AppDate] The date in the table is set as 31/03/2022 - i am getting this error if i use this criteria it works >#31/03/2022# But i need to have...

Yeah thats why i have to use the bat file to do that, any other way to call a bat file to run other than SHELL?