Search results

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??

Thanks. But this doesn't seem to work??? Any other ideas??

I am trying to do the following but the counts i am getting are bizzare??? SELECT [Error Log].[Welcome Pack Status], [Staff List].Region, Count([Staff List].Region) AS CountOfRegion FROM [Staff List], [Error Log] GROUP BY [Error Log].[Welcome Pack Status], [Staff List].Region; I only have the...

I have two tables. In one table i have a list of staff members like so: Name/Region. In the other table i have linked the staff list by using the table/query row source type to control the data. But when i do a query count for e.g. member of staff/region/count. I would like to count how many...

Thanks Pat thats worked most appreciated.

Thanks but this doesn't seem to work its displays the data exactly the same way as before. There must be a way to have two counts on one query???? But have the counts in seperate columns rather than rows??