Search results

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 ?

Hi, So I am using DCount on a unbound txt box to total results from a query using criteria based on a number of days. I.E count all records with "1". The query is displaying the correct number of results for "1", in this case 14 - however the DCount is displaying 13. I have also tried this on...

That got it - thank you very much!!

Hi, Thanks to the assistance of yourself and others, this is now working :) - I did have to change the "-1" to "1" to get it to work but now it does what I need. thank you very much for your time and the breakdown explaining it that really helped, I am slowly getting my head around access :D

Hi, Apologies - I was posting from my phone and I missed your response. I get a syntax error with Elseif Me.Order_Complete = -1 Many thanks Demo

Hi, debug.print strFilter returns nothing that I can see? MSGBOX returns "False"