Search results

Hi I currently have a report that prints a summary of progress of legal matters for all departments. I have now been asked to provide a separate report for each department, rather than one big report. The departments are contained in a Table. Is there some way of running a macro so that I...

Hi Does anyone know how to create a query, or something....so that the database knows that the 28th August is a Tuesday, (and therefore a working day), that the 25th August is a Saturday (and therefore not a working day), and that 27th August is a bank holiday (so again, not a working day)...

Hi I have the following in a text box on a report: =IIf([ClosingDate] Like "*/05/*",Sum([Expr1]),0) The data it is analysing is the cost of job advertisements per month. We advertise in the Star, Guardian and Job Centre, so Expr1 = [Star Cost] + [Guardian Cost]+[Job Centre Cost]. The...

Hi I have a query which has a formula in it like this: Mon2: IIf([Mon]=0," ",[Mon]) (and then I have the same for Tues2, Wed2 etc - all the days of the week) Note that the formula for Mon is: IIf(IsNull([Test]![Mon Hours]),0,1) and that Mon Hours is a long integer number. What I want to...

Hi I have a form which people fill in (made up of fields from Table1) to record when sick days. On the form, they have to enter the "week commencing" (which is set at Medium Date format); then they have to enter in a first day (which is set at Short Date format). The First Day should be no...

Hi All I have a query that runs based on the contents of a date entered in a form (I will call that Query1). I need to take the data from Query1, and then have Query 2 analyse the data (I want it to tell me where the Count of First Day is more than 5). When I use the query design grid, I...

Hi All Is there something I can write in to a query which will tell me whether the 1 April 2006 appears in between two dates (which are entered by a user?) For example, if they put the first date (which is one field) as 25/3/06 and then they put the end date (which is another field) as 4/4/06...

Here it is: =Count(IIf([Calendar Date]>=[First Day] and <=[Actual Last Day]) ??? Maria

Hi I have a table which has a start date and an end date on it: e.g. 25/10/06 to 3/11/06. I want to set up a query to calculate the number of days between those two dates, but only for the month of October: so it would only come to 7 days (not 10 days). How do I do this please?? Also...

Hi I have a table which keeps a record of days off sick. The table has the field [First Day] = the first day they were off sick, in a dd/mm/yy format and a [Last Day] = last day they were off sick, again in the same date format. I need to have a query that will produce the actual day, and...

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

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

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

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

Hi, I want the user to be able to pick from a list the criteria that they can put in when prompted by a query. At the moment, when you run the query, I have it set up so it prompts for the criteria: [Enter Section:] - so the user has to type in the section. I want them to be able to pick the...

Hi I want a query to generate a "1" if someone ticks the Yes/No box, and a "0" if they do not. This doesn't work: Expr2: IIf(IsNull([Q2(i)]),"0","1") and neither does this:Expr1: IIf([Q2(i)]="Yes","1","0") ???? Arrhh ta

Hi I have a table which has a date field in it, where the default value is Now(). How do I get this field to automatically update in the table to "today's date"? Thanks Maria

Hi I have made up an Access database form for our Sickness Administrators to fill in when someone is off ill. I want the form to only show (on the drop down list of names) the people that that particular SA deals with - for example, Jill would enter sickness records for the Democratic, Legal &...