Search results

Hi, I am trying to replicate a simple sumifs from excel to access & struggling to make it work. The data I have is: Ref------ Month---------- Days 1 ----------May 2018----- 12 1 ----------May 2018----- 10 2 ----------May 2018----- 11 2 ----------June 2018----- 30 3 ----------May 2018------ 13...

Hi, I am using the DateDiff function and getting #error when the 2nd date is 31/12/9999 (I know this is the problem but that is how my source data is presented to me). What I'd like to do is replace the #error with 0. The formula I have is: Months: DateDiff("m",[Installation Start...

Afternoon all. I am trying to solve a bit of a problem and hoping someone here may have some advice for me. I have one table of data (contracts) and need to extract from this any instances where the dates overlap. So the logic should be: ref <> ref ok ref = ref and Start...

Hi, I have 2 tables with matching field names etc, let's call them tbl_archive & tbl_update. tbl_update can contain either entirely new records (don't appear in tbl_archive) or updates to records existing in tbl_archive. Capturing the new records is easy with an unmatched query as there is a...

Hi New to the forum with good access knowledge but only limited VBA. My problem: I have a list of account numbers stored in a table and I need to use this list as the parameter to run a single query multiple times. So if the table has 10 entries I want 10 outputs wth each one...