Search results

Hi all, My problem seems to be on such a basic level, but I can't for the life of me work out why it won't work!! I have creatd a complex for which is a menu page for various reports. I have tried to put information on the control tip text to inform the user certain details. I have entered...

Hi, I have a query that gives an out put of 'worst offenders'. these offenders are in order of on field ascending (number of entries made per week) and another field descending (total sales). It is by the combination of the sorting of these fields that we have an ordered list of offenders...

Hi, I have created a form that is based on a cross tab query. I have a set number of fields in the form (1 day, 2 days, .....10 days). The problem is sometimes when I run the query some fields disappear. for example for no records have an entry in the '2 days' field. When this is out...

Hi, I have created a continuous form, and using conditional formatting I have mde the background colours of the cells change due to their value: <2 2<[value]<4 >4 The code I have seems to work but the whole column of values are the same colour depending on the top entry, other cells are the...

Hi, I have been trying to calculate date difference not including weekends. I found this code to use in another thread, but am unsure of where to put it. I am quite new to using access, so a detailed description would be very useful!!! Here's the code posted: intDaysInPeriod = DateDiff("d"...