Search results

So many options I didnt even know exist! Hehe! I will have a play around and see what best fits my database. Cheers Mike! :cool:

Thanks Mike I will have play around with DSUM's. Sounds like they could be quite useful. Thanks again for your help. I would be stuck (and probably unemployed!) without guys like you. Daz

I have sorted the above problem by creating another calculated field in the query. I created the following: TestField: IIf([DayCalc]<0,0,[DayCalc]) The above will display a '0' in the results if the value of 'DayCalc' is a negative number. Thanks for pointing me in the right direction...

I have found the exact field where I need to put this IIF statement in, unfortuntely the field in the query calls upon a function in order to calculate. Here is the field in the query.. DayCalc: HowManyWD([LowerDate],[UpperDate],tblPersonalDailySchedule!Day) What would be the syntax to...

Thanks David/Mike I have just got back from lunch - so will give it bash. I will post back asap. Thanks Daz

Hi Mike That worked perfectly! Many thanks. I have one more question (not sure if this should go into a new post). If I have a negative number in the currency field, I would like the SUM function to ignore it - better still if there is a negative number - is there anyway it can show Zero...

Hi I have a form with a sub-form embedded within it. On the main form, I have 2 date fields, when a user enters the dates - the subform updates and shows records applicable within those dates. One of the fields in the subform is a Currency field. What I would like to do is to show the...

All sorted! Thanks David. I really appreicate your expertise. :) I created the Upper & lower date fields in my query put the calculation in - and it works perfectly! Many thanks!! Daz

Ok, I am struggling implementing this in my database. I am going to continue to try this afternoon - hopefully it won't drag on until the morning. As soon as I have sorted this (or require further assistance!) I will post back. Thanks for your help with this. Much appreciated. Daz

Exactly!! Thank God for people who can decipher my nonsense! I will give it a try and post back shortly. Thanks for your help!! Daz

Hi I think the code you gave me would solve the problem but unfortunately - the Day of the week is manually selected from a combo box. (Mon, Tue, Wed, Thu, Fri). A user would select which Taxi Firm and what their schedule is for the week: From [EffectiveDate], every [Day] - go to X...

Many thanks for your reply. I will give it a try now and postback. Thanks again

Hi everyone Can someone advise me what I can do to fix this problem please? I have a query which calculates how many days between two date fields which works great. I use a module to do this and call the function in my query. The database is for Taxi Scheduling. If a user selects a...

Hi Chris Many thanks for your help. I simply put the addtional fields/info underneath and used a page break. :o Cheers!

Hi Chris Thanks for your reply - I will give it a go this afternoon. Thanks again Daz

Hi Thanks for your reply. I have deleted the duplicate post. I have attached 4 pics. The first one is Page 1 of the report, the second one is Page 2. The 3rd one is Page 2 for subsequent records - this is how I would like the report. Page 4 is the design view - the red line shows where...

Hi Please can someone help me with this? I need to create a huge report which spans across 4 pages. The report has many fields in it. Pages 3 and 4 of the report is just static text. Pages 1 and 2 have lots of fields in them based on the query it is based on. I have done this in the...

Does anyone know of this is even possible? Many Thanks Daz

Hi Can someone please help me - what I would like to do is have some fields on a report pre populated by some details a user inputs on a form. The form has a combo box for Religion. On the report I have a list of all religions with a tick box next to each of them. I would like the...

I tested it and replaced the dates with fields from my query and it works great! Many Thanks for your help! :cool: Daz