Search results

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)

Hi the structure is as follows:- TABLE: tbl_clinet details which has the unique Client ID, name, address etc TABLE: tbl_claim data which has the fields show above - including (A)Application Form and AF date (B)Start-up declareation and SUD date (C)Applicaiton Form (Post) and AFP date this table...

Event A Event B As you can see I am using the same core data, but the different filters are needed. The main problems is that my clients may attened different events ( I am using the term events as its easir to understand) so Client Joe Brown on 31/07/07 may go to event B Fre Smith on...

*Note on the above** my append query (have have created 4) will list all those in each event, but will also duplicate those people who have attended more than 1 - How do I now Merge these duplications?

Ok let me explain I have a list of 50 people who may have accessed events A,B,C at different times but what I want to do is to put a date in my form, run the quaery which will list all people who have Attended A,B or C When I do my normal query, I put the fields in, but if I put a date filter...

Importing over 9000 postcodes is not a problem, but listing them on a combo will not do what I want. I would like to be able to input my own postcode (not from the list) and then if its in any of the lists it will automatically update a field to say that the post code input is in area 1 and...