Search results for query: *

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two dates. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday's). Any help would be...

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two dates. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday's). Any help would be...

I have built a MS access macro to automatically truncate table and import the data. Does anybody know how to schedule the macro to run automatically and output the file to a folder?? thanks

I have my report set up to group by accout#, all the details have been suppressed and had the summary total added at the group footer (acct#). A date parameter has been added to pull only the data I want in the selected date range. I want to be able to output Month to date total and year to...

I have a MS access table that contain data which I manually compared to find out the status change between the current week and the last status before it got changed. I am looking to automate this process as much as possible. How can I change the query to output the status changes as listed...

I have a MS access table that contain data which I manually compared to find out the variance between the current week balance vs. balance at beginning of the year at parent acct# level. I am looking to automate this process as much as possible. Not sure if Visual Basic or other coding may...

I have a BO report created and the body of detail is pulling from a transaction history table and I was able to use crosstab to break out the total outstanding balance by month. However, the current report is at the customer level. I need to change the report to the account level, but when I...

Hi When I try to run a report this error message pop up Connection or SQL sentence error (DA0005) Detail: Exception: CS, Specified network layer is invalid: ODBC Can anyone let me know what the problem is? Did I setup my MS access odbc data source incorrectly?? thanks Connection or SQL...

Hi When I try to run a report this error message pop up Connection or SQL sentence error (DA0005) Detail: Exception: CS, Specified network layer is invalid: ODBC Can anyone let me know what the problem is? Did I setup my MS access odbc data source incorrectly?? thanks

I am building a report and having difficulties get the data format I want. Below is what I currently have. The report is currently grouped by MasterAcct# and sorted by masteracct# and postDate. I need to know what is the credit limit at beginning of the year and what is the current credit...

Does anybody know with the waitfor time statement, do I still need to hit F5 to execute the query or will the query automatically execute at 10:20 as long as I keep my query analyzer open?? WAITFOR TIME '22:20'; EXECUTE sp_update_job @job_name = 'TestJob',

Hello everyone, I am trying to create a report, which will provide list of active accounts with information such as Account#, total of principal payments made for the last 3 months if there were any. I am having difficulty on creating the formula for the principal payments made for the last 3...

I need some help on duplicate records. I need to be able to output all records to the detail section. I have tried to do the subquery within sql command of crystal report but I haven't be able to do it. Can somebody please help me? acct# acct_status balance A12345 open 100...