Recent content by mariaw

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