Recent content by accessir
-
A
DLookup Question?
Hi James - tried this but it still brings up the same default salesman (if it helps, it returns the first salesman on the table even though I modified the data to say his figures were neither max or min and tried DMin and DMax! Cheers though, I appreciate the help... -
A
DLookup Question?
Hi Brian Thanks for your input here...alas, I have no idea how to join here - I know for example having used htese functions that min is 2 mins and max is 34...but to join these, I have no clue!! Can you help how to join? Cheers :cool: -
A
Pre-POpulate form 2
Cheers...I'll use this and see what I can come up with. Thanks -
A
DLookup Question?
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... -
A
Pre-POpulate form 2
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... -
A
Form Size Always Wrong on First open!
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... -
A
Help With Query!
Cheers for that. I will look at the database structure (I dont really have the best implementation of the tables and its quite complex to explain) but essentially I do have replicated data on different tables because some of it is needed for querying in different ways and I Had figured no easy... -
A
Help With Query!
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...