Search results

Could someone please help? I wish to create, on a data entry form, a box that shows the total number of entries for today's date. My tabel includes a 'Department' field and I'd like to show the number of entries for the day by each department. Is there an expression that will do this please...

Hello! Could someone please give a bit of help here? I'm using Access 2016. I wish to apply some formatting to a datasheet on a split form. I have a field called 'DEPT' and two others called 'EMAILED' and 'CLEARED' - what I want to build is an expression that means if the 'DEPT' field has a...

Hello, please could you help me? I have a split form and on the datasheet I am trying to format a date column called 'SCHEDULED' (this is the date a specific job will be scheduled for), I have used the expression:- IsNull(SCHEDULED.Value) To flag it as a red box if there's no date given, but...

Hello! New here and pretty much a beginner with MS Access (using 2016), look forward to chatting with some of you - loads I'd love to learn. Rob