Search results

Hi Gemma This works better, but it doesn't seem to like it if q44 is blank? It counts the blank as a "yes"? Maria

Hello I put this in: Count([Q43]="yes" And [Q44]="yes"/Count([q43]="yes")) (because the answers are "yes" rather than true but its says that I "cannot have an aggregate function in the expression"??? Any idea what else I can do :) Thanks Maria

Yes that's right; some people said "no" to question 43, but "yes" to q44.... it just gets better and better...!

Close...that gives me 200%? it needs to be 100%? Thanks

Hi I have a questionnaire that I have to analyse, where people answer Yes or No to a question. In my report, I have the following (to show how many people answered "yes"): sum(Iif[q43]="yes",1,0))/Count([ID]) - this produces 25% (which is correct). What I want to do now is, for q44, out of...

Thanks guys- got it working how I want it now - had a revelation at 3am in the morning... Cheers Maria

Hi I am using Microsoft Access '97 and I need to generate a report that will be several pages long. I know how to add page breaks, but the report footer will only allow me to put so much info in - about 2 pages worth - the report is going to be quite a lot more than that. I tried using the...

Hi I have a form that people fill in where they can choose from 4 boxes (and they can tick as many as they want - it is a yes/no box) I have tried to write a formula for a queryto show where none of the boxes have been ticked.....this doesn't work: =(IIf(IsNull([Q3(i)]) And...

Hi alastair69 I did think about doing that, but I wonder if there is anyway of having that come up in a dialog box - e.g. so when it says Enter Week Commencing: you can tell it you want it to be the week commencing 15/10/06 and anything before it? Maria

Hi I have a query that I run which currently picks out everything for the week commencing X, where X is entered. E.g. when you run the query, it comes up with a dialog box saying "Enter Week Commencing:" - and if you put in 15/10/06, it pulls all of the records that have been put in on that...

Fab!! Thanks Byte Myzer - that worked!! Maria

Hi Gemma Yes, it is testing everybody for a 365 day period, and highlighting the ones where they have been off sick 5 times or more in that (random) 365 day period. Thanks Maria

Database Hi Michael I'm afraid even if I chop down the database, it is too big to attach....have you got an email address?? Maria

Hi Michael I can't open the zipped file for some weird reason.. ARGHHH! It says unrecognised file format when I unzip it. and the [Forms]![Section]![Section] still doesn't work.....Section is the form name and Section is the combo name.... I put the [Forms]![Section]![Section] in the...

Hi Gemma I need it to be able to do it over a 365 day period, which might be, for example, from May 2005 to June 2006? Maria

HI PDX Man Sorry I don't know how to post the query .....but i have done it by getting it to count up the number of entries in a table?

Hi ByteMyzer I have put this in (see below): the table that I want to delete from is called NIL RETURN - but it says there is a problem with the FROM clause...? If I put brackets round the Nil Return after the AS, it still doesn't like it?? DELETE Nil Return.* FROM [Nil Return] AS Nil...

Hi... here's a good one... I have created a database which allows people to enter in when they are off sick. They have to enter in the FIRST DAY of sickness and the LAST DAY of sickness. All of this information is stored in one big table - SICKNESS TABLE. There are no other date fields in...

Using a form for criteria in a query - fao Michael J Ross Hi Michael Thanks - I now have a form that will show the "list" of sections. So how do I make the query pick that form up? I have tried =[Forms]![Section]![Section], with and without the "=" - but it doesn't work.. Maria

Hi Is there a way of finding duplicate field entries in a table and a query: e.g. In the Sickness Query (which contains, say 10 fields), in the Section field, it says "Benefits", and in the Week Commening field, it says "15/10/06" And then In the Nil Return Table (which only contains the...