Search results

Hi All, I have a form and I am trying to highlight all values that equal the top value. I recently learnt that I can create a query style record in this thread and thought I can apply the same principals. https://access-programmers.co.uk/forums/showthread.php?t=291097 So in the conditional...

Hi All, I created a subfrom that graphically displays the performance of a certain sector / employee in a business. From this I have created a main form which I can select branch (London / Birmingham etc.) the form then displays the Branch details in the header and the detail displays the...

Hi all, I have a form that contains an expression field to display the value of sale. It uses an; IIf([Currency] = GBP, "£" & [ComponentPrice], IIf([Currency] = "USD", "$" & [ComponentPrice], IIf(........ for euros etc. The field worked fine yesterday but today displays #NAME? and if I copy...

Hi All, I am trying create a query that will look at an employees past sales but I want to add a field that will show the employees last sale value / quantity of products and have tried using the DLast function but it only displays a random value which is the same for all employees. Not what I...

Hi everyone, I am new to using access but have managed to build a database that I use to find qualifiers for horse racing based on stats I import for all the racers in the days racing. I have a query which shows the date, time, track, horse and trainer but some races have more than 1 selection...