Search results

Thanks Keith, but I should have also told you that I email the reports, rather than print them out, so I need the system to physically generate, say , 20 different reports? thanks Maria

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

Sorry no comprendo....how do I do a filter in a query please? Maria

I can confirm the sum is working...so it's something to do with the if part of the calculation.... thanks Maria

Hi Ok I have expanded it to this (e.g. to tell me the total costs for May): =IIf([ClosingDate] Like "*/05/*",Sum([Star Cost]+[Express Cost]+[Ad Mag Cost]+[GuardianCost]+[Opportunities Cost]+[Job Centre Cost]+[Other Cost]),0) and it still doesn't work? I don't think the spaces are a problem in...

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 Michael (and everyone who has tried to help me :) I have finally sorted it out; unfortunately the only way I could do it was to make sure that if any of the hours (e.g. Mon Hours, Tues Hours etc) was blank, was to put a 0 in it (the number) - and then my formulas did work - sorry for...

the file! Hi all Here is the simplified version - if you look at the Sickness query - undated, you will see the problem I am having... http://www.shrewsbury.gov.uk/Example-system.zip If you download a copy of the zip file, then make it unmark it so it isn't read-only you can play around...

Hi Roy I can't get the database to "zip" so it is small enough to attach; any chance I could email it to you directly?? thanks Maria

nz function Hi again I do want it to return the number 0, so where do I put this NZ function (sorry, not a great whiz on access...) thanks Maria

Whoops I spoke to soon.... What I need the system to do is, if [Mon Hours] is either 0 (a number) or null, then to return a "0"? Maria

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

For Michael J Ross Sorry but it says the database zip file is corrupted; Also, I am on Microsoft Access 97? thanks Maria

Validation Rule Hi Our weeks start on a Sunday, so sorry, the 1st to the 7th April 2007 inclusive will be the week commencing 1st April How would I get it to calculate the week commencing for them? Thanks Maria

Validation rule Hi Thanks for this, but even with a pop-up calendar I am not convinced people will get it right.... How do I "write" the validation rule please? thanks Maria

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

Thanks very much MStef - works a treat!!! And thanks to FoFa for your help too :) Maria

Hello both Thanks for the suggestions; queries for both of you! Fofa: so I assume I make a form where someone enters the date 1st April 2006? MStef: sorry but when I try and open the database (once I unzip it) is says it is an unrecognised format; I am using MA 1997? Thanks!! Maria