Search results

Hi Folks Im trying to return a value whereby I get a result that shows me the salesman with the LEAST time on the phone for Campaign 1 - so, Im running this: =DLookUp("[Salesman]","CallsTable","SalesCampaign = 'Campaign 1'" And "LengthOfTheCall = DMin") However, it doesnt work :mad: I...

Hi All I have 2 forms whereby one piece of info I hold on the first form is sometimes the same as that on the 2nd form but not always thus, what I want to do is this: USER COMPLETES FORM 1 in full...no problem USER then (optionally, doesnt always happen) presses my command button to launch...

Hi There I've set (via the properties) the size, location etc of all my forms and essentially all are sized to a specific size and all are centred with auto centre etc. However, the very FIRST time I open any form (via a link on my home form) it opens full screen....then, when I close it and...

Hi Folks Ive been tasked with creating a database for a colleague and have done everything except managed to pull together some more complicated (For me) queries into 1 result - to show in a simple little form/table and ideally a graph too. Basically I have 2 tables I need to pull a lot of...