Search results

Hi All I am looking to create a stored procedure to run multiple stored procedures. I want the procedure to truncate all tables and upload files and loop where the date is between 2 dates then stop when the last file has been uploaded. The other procedures are the upload and format...

Hi All I have a query which calls information from 2 tables. The tables are linked by ReportID, A Prim Key on one table and not on the other. Now for some reason in my query they join will work once but when I try to base a report on it the join slips and the query goes caput. Any ideas...

Hi Guys Hope you can help. Am looking to start doing websites using wordpress as a cms. Any suggestions on a good host that will provide me with a good amount of SQL dbs and also is fairly cheap. Thanks

Hi Guys I have a combo box based on a query which has these fields Instance ID Report ID Report Name Due Date What I want is the first combo box too bring back a list of report names and the second to return the Due Date for that particular report based on the selection. My problem is I...

Hi All I am trying to populate a text box with a field from a query. After updating a combo box I want the text box below to show the latest value (in this instance a date) in a query for a set field. So Afterupdate, Textbox = Max Date in Field Next Due. Any help would be much...

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]...

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 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...

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 !

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...