Recent content by access11899

hi vbaInet, I've tried to implement your solution but with no luck I mean that when I opened the code window I did not know what to do Then I found on the internet another solution. Create a macro that opens the report and then 1. Go back to your form. 3. On the Toolbar at the top hit...

Thanks vbaInet, Now it's working. There is only one point. Is there any way to run the report from the form? What I mean is that at the moment 1) the user has to fill in the form and to keep it open 2) and then click on the report. What I would like is to fill in the form and then see the...

First of all thank you to CBrighton I have tried to implement your solution but I get exactly the same message #Name? I can select in the data source the fields now but I still get #Name vbaInet it is very kind of you. Please see the db in the attachement Many Thanks

Hi vbInet, Thank you again for your answer. I have called the text boxes from and to this is the query SELECT summaryTable.Account, Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 AS WORKED_HOUR FROM summaryTable WHERE summaryTable.Date Between...

Hi vbaInet, Thank you for your answer. 1)I have created the form and the two text boxes 2) I have modified the query SELECT summaryTable.Account, Fix((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 AS WORKED_HOUR FROM summaryTable WHERE summaryTable.Date Between...

Hi I'm a beginner I have a problem in displaying two parameters in a report The report is based on the following query: SELECT summaryTable.ACCOUNT, Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 AS WORKED_HOUR FROM summaryTable WHERE summaryTable.date...