Recent content by demogorgan

Hi, Thanks for the response - I was trying to think of a way of making this more user friendly. I was hoping that 1 and 2 could be combined as I don't want circa 70 attachements, the summary page has a lot of fields. How about exporting to excel and creating each report as a seperate tab then...

Hi, So I have a report that displays an overview of data, it also contains hyperlinks to other reports (showing greater detail). I want to be able to export this into a format for an E-mail for reporting the info to key people that do not have access to the DB - I have gotten this working...

Hi, Apologies for the delay - life has a way of getting in the way.. I wanted to thank you all for the help, the issue seemed to be the form not refreshing correctly - I now get all the required numbers correctly :) I will certainly look into incorporating the date functions you have...

Hi, I will work on this to send through later as I will need to replace some data. I will clarify - my querys return the required data as far as I can tell anyway. My original issue still remains. I have a form that displays the totals of the querys using DCount using criteria (See...

Hi, I appreciate the time and effort you have taken to create the attached and I will try and digest the details - however my query and current date function seems to work as far as I can tell. Unless you can see different? I am afraid I cannot remember where I aquired this code & I am still...

Hi, My querys show there are 22 days between them as well ? so I do not understand how it can be a date issue ? I am based in the UK and my default date format is DD/MM/YYYY I am confused how this affects the DCount that I was having issues with ? the difference between the 2 dates gives me a...

I am afraid the dates are out quite significantly using the database that was very kindly posted earlier.

Hi, Now I am even more confused, I am trying to digest the other thread currently - however I do not need to exclude public holidays currently as they are all worked, the only exceptions are weekends. I will however look at changing this over to build in future proofing. your query and my...

Hi Mark, The dates are entered using DDMMYYYY - they are all entered using the built in calender. They all match what I expect when I examine the details in the table. I have, however no issues with the dates I can live with having to take 1 day off the totals as I am used to doing this with...

Hi, The first query returns the same totals as my original query - which is correct. The second query does total, again matching the first query. I am afraid I am getting out of my depth here, how am I linking this to the DCount that I need on my form ...

Hi, This just seems to put a 1 next to each record ? Am I correct in assuming that this should count all "1" , "2" , "3" etc so I can then refer to them in the DCount ? Thanks for your help thus far.

Hi, Apologies I am still new to access and SQL this is the code that the query creator used. The query runs against all the orders in the table and then displays the date difference between the order date and booking date excluding weekends. I then get a list of of all orders and then then...

Hi, It returns a number of days in Interger

Hi As below, the query is returning the correct results however. SELECT tblOrder_Details.Creation_Date, tblOrder_Details.Date_Booking_Confirmed, Work_days([Creation_Date],[Date_Booking_Confirmed]) AS Difference, tblOrder_Details.Order_Number, tblOrder_Details.Export...

Hi, Thanks, however it still returns 13 ?