Recent content by brin

How is it possible to capture a list of numbers wher met by a ceratin criteria i.e. List of numbers 7 9 5 6 1 6 1 How can i count/show the number of times a number is greater than 4 in this case we have 5. And is possible to add up those numbers?

I am using the following formula to capture all data where the number of days is less than 21 days, this works great . What i would like to do is work out the average so i need to count the values of the numbers captured i.e =Abs(Sum([mo to com]<=21)) 55 14 78 17 66 3 11 21 7 20 12 Number of...

How is it possible to edit a report in preview mode? i basically would like to enter notes once i have viewed the report. Is there anyway i can do this?

Thanks that worked a treat!!

That worked thanks, another question, using the same query how would i say 'is not null' as i have tried this and i get errorrs?

How can i test against a blank field where the field is in a date format? 'ID Received' is a date field I would like to say if 'ID Received' is blank then output 'yes'. e.g. ID: IIf([ID Received]="","Yes","Awaiting") The above doesn't work produces "ERROR".

In the query i have i wish to do the following: I have two columns: Column A Yes Yes Yes No No Column B(date field) DATE DATE DATE I would like to code a script where: if column A was "YES" and column B had a "DATE", then output "****", and if column A was No and Column B was null then...

i have managed to highlight the forecolour on the report by using thre below, what is the code for highlighting the background? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Tenure = "Leasehold" Then Me.Tenure.FontBold = True...

Is possible to highlight using colour a certain field in a report e.g. Report contains following: Name Address Tenure John the Road Freehold John the Road Leasehold John the Road Freehold John the Road Freehold John...

How is possible ot create a history log of Users and Dates of all users whom have accessed the database?

Is there any way of inserting a drop down box in a query without referring it to a form????

I have a querie with a list of clients, is there a fuction i can use where i run the querie and i am prompted to insert a client name for example "smith" and i can get the list of all smiths in the table????

Thank You Milo!

I want to find some data in the past by using the date add function but i don't want to just use static numbers i.e >=DateAdd("d", -30, Date()). Is it possible to run the query then input the days required for the search?

I have a querie with a date field, i would like to run a report where i insert a random number e.g 5 and the qurie shows me results 5 days ago. I know the fucntion , start and end but is there a function where i can enter the amount of days??