Search results

I am a heavy Business Objects user and coming back to access has meant changing my syntax. I have written an IIF statement with DateAdd but its returning an error. I would be grateful if someone could have a look and let me know what I need to change ! Thank you ! NextDue2:IIF( [Completed]...

All of those frequencies are possible Gemma but the main are Daily, Weekly and Monthly. Thanks

Hi Husky Thanks again ! Could you perhaps point me in the right direction with an example. I have a frequency column and day of the week column i,e, monday reports etc.

Thanks for the reply Could you perhaps provide any example, as am a little unclear on what you mean. Also I have a variety of frequencies such as weekly and monthly !

Hi All Is there a way , by just having a start and end date I can calculate all the instances of a report over a period of time. My manager wants to be able to see what reports are due on a certain day. So if I have the Report Name, Frequency=daily weekdays, Rpt Start Date and Rpt End...

Hi Gemma What my manager wants to see are reports that are due on a certain day. I would like to see if there is a way of doing this using a start date and frequency rather than input every single report due for the year

Hi Camerpn The reports are due on a cycle from a start date. So I presume I would have to put a start and end date in for all reports in that year as you said. When someone completes a report I would like that stored in the db with a new due date added to the report information. Thanks

Hi All I am trying to create a database that will allow us to record and monitor all our regular reports. The main functionality required is - Recording when a report is delivered - Reporting on if the report was late etc - Being able to look into the future to plan work loads by looking...

Having regained my brain and asked a colleague I have used the or function in access. However I would love some advice on making the database the best it can be. I will post in another section to get some answers on how to achieve this.

Thanks for the help I have only just started and your probably right as I am trying to get access to do what some other software can do and report from a data source. Ok well the table structure is PrimKey Report ID Report Frequency Team Report Location Procedure Location Month 1 2 3 4 5 6...

I am trying to create a log to show when reports are due. I have set up a form for managers to fill in and then imported that into access. What I am trying to do is plan for a whole year the reports that are due. So in the first 5 columns I have report information etc then 31 columns with...

Hi All I have a query which I want to use as the basis for a report to bring back information on reports due on a certain day. I want to create a parameter query to search 31 columns to find the dates linked to the reports. What is the best way of going about this ? Thanks !

Thank You Rabbie I will give that a go and see what happens ! Thanks !

Hi I am trying to create a record log in Access 2000 for all our regular reporting. I have created the input side no problem but I am have an issue over calculating due dates. The reports can range from daily to Annually with different frequencys inbetween. I appreciate I will have a start...