Recent content by batman1056

thanks IF you can get this working on a different database, can you post that here, I will then utilise your database, and import all my data and recreate the forms, and drop in the reports. Should only take a few hours to get it up and running but at least this report will run tba thanks

Genious! Fantastic - now I know where I went wrong - put the expression in the wrong place, I used your layout - many many thanks This worked exactly how I wanted. - BUT it does not distinguish between the two areas - in your database - go into the queiry - and tick newcastle and sunderland...

(IIF([Application From] = -1, DLookup("[A]","tblcosts","tblcosts.district = [district]),0) + IIF([Startup Declaration] = -1,DLookup("[B]","tblcosts", "tblcosts.district = [district]), 0) + IIF([Post Start] = -1, DLookup("[C]", "tblcosts", "tblcosts.district = [district]), 0))As...

Thanks - working on your solution and will post it how I get on. - Re - name - I took it years ago after the first film, like the dark appraoch of the film, reminds me of the dark Knight series in the graphic novels. Quick question not sure if this is an easy answer or hard answer In my...

ok.. this is the report layout - please note that the names have been changed and also the tick box's do not appear on each line - hopefully you will be able to understand what I am doing for the values of A,B,C I can create a table with these in - this is not a problem so If I created a...

I have a report which lists clients I have supported and I get paid per client I have supported and depending on which area the client lives I get paid a different value (i.e. Newcastle or Sunderland) My report (from a table) Shows a fulls list of client names with district and yes/no...

HELP The key report names as are follows [district] is the main place [application form] = A (yes/no field) [startup] = B (yes/no field) [post application] = C (yes/no field) I created a text box and created the following formula on the line if([district]="newcastle",if [application...

great I will try this later and post any problems with calculating it Thanks

backgound:- I have a report that lists people from different areas i.e (field called : district) Newcastle Sunderland In each line of data it will show if that person has for example been to event A,B or C (yes/No) Fields called (A,B,C) Is it possible to include a formula at the end of this...

what is "FROM table INNER JOIN on YourOtherTable" also the dates - I could use a reference to a form - i.e I could choose a date in from then have this query look for that date - is this correct i.e. WHERE (event1field BETWEEN FORM![datecheck]![datefield] AND FORM![datecheck]![datefield]) OR

I have tried various methods - still having issues with it. Another Question - I have created a Query that counts the number of times "Yes" appears in a list - the answer for example is -72 I then show this data in a menu as a top line achivement figure - this is not a problem, but when I...

How do I change it so the value of YES = 1 and not -1, I am trying to count the number of +1's in a report and I keep getting -1 Help

Ok.. I try this version In the menu - choose claims then in the date box choose 31/07/2007 this should show u want I mean also 30/08/2007 and 31/09/2007 are 2 other claims Thanks

Yes. that is correct - BUT if a client goes to event B and no other event then I need to capture this data If they only wen to A then I need to capture it - so yes its redundent but No also as I need to be able to record it too

I have attached the database - with 4 clients as you can see from the Queries - you can see what the 3/4 key areas I need to see in my final report. Ideally The monthly claim will show me which customers have has pre-start, start-up application from and event (see queiry)