ollyb303
Last Activity: Mar 23 '09, 01:35 PM
Joined: Dec 4 '07
Location:
-
Good idea. Thanks very much for your help. -
Hi Stewart,
I've tried this and I have a new problem...
I should have mentioned that my initial query is actually a SQL pass-through to an Oracle db, so (as I now realise) DateDiff won't work.
Do you know how to write this:
DateDiff("w", [your transaction date], date()).
In a syntax Oracle will accept?
Many thanks....Leave a comment:
-
Stewart, thank you so much!
As I'm sure you can tell, I'd pretty much given up hope of this working!
Haven't tried it out yet, but it looks very promising - I'll let you know how I get on.
Thanks again,
OllyLeave a comment:
-
So I'm guessing there's no way to do what I want to do in this case :(
Think I may have to give up on this idea unless anyone wants to chime in?Leave a comment:
-
Still at a loss with this one.... anyone?Leave a comment:
-
Thanks Chip, but that would give me a daily total for each day in the 6 week date range (if used in the pivot). What I'm after is a weekly total for each of 6 weeks.
Any other ideas?
Many thanksLeave a comment:
-
Just a little bump! Can anyone help me with this? Please....?Leave a comment:
-
Solved this by converting my Nulls to zero on the way into query2 using NVL, then used a simpler IIF statement for the crosstab:
Code:(Sum(IIf(Query2.LOGIN_TIME>(Query2.SCHEDULED_TIME-Query2.EXCEPTION_TIME),0,(Query2.SCHEDULED_TIME-Query2.EXCEPTION_TIME-Query2.LOGIN_TIME)))/Sum(Query2.SCHEDULED_TIME)*100)
Leave a comment:
-
Need help converting oracle decode statement for MS Access
Hello,
I have been using the following expression in Access as part of a statement to query an Oracle database:
...Code:(Sum(CASE WHEN STATS_DAILY_SA.LOGIN_TIME > (STATS_DAILY_SA.SCHEDULED_TIME - DECODE(STATS_DAILY_SA.EXCEPTION_TIME, Null, 0, STATS_DAILY_SA.EXCEPTION_TIME)) THEN 0 ELSE ((STATS_DAILY_SA.SCHEDULED_TIME - DECODE(STATS_DAILY_SA.EXCEPTION_TIME, Null, 0, STATS_DAILY_SA.EXCEPTION_TIME)) - STATS_DAILY_SA.LOGIN_TIME)
-
Dynamic weekly date range in crosstab report
Hello,
I am using a dynamic crosstab report to track performance statistics for my company and I have hit a problem.
I would like the option to track stats daily (for the last 7 complete days), weekly (for the last 6 weeks) and monthly (for the last 6 complete months).
Daily and monthly are not causing me a problem - I have used the following code to construct the query:
...Code:strXT = "TRANSFORM
-
: )
Cheers! It's all going well now...Leave a comment:
-
Thanks for the suggestion NeoPa.
As you predicted it didn't work! But thanks all the same : )
As FishVal predicted, I am progressing much faster than I did with the code originally, the code is tighter and the whole thing is looking improved so far.
I'm making incremental backups every few hours this time!Leave a comment:
-
Thanks ramprat. This did work to recover the table data. However I had already been able to do this using stellar phoenix.
TBH the tables are not the issue here as the application is actually a front end for an Oracle database so the only tables are a few temp tables with very little data in them.
The bits I can't recover (forms, reports and code modules) are the bits I really need!!!!
I've started recoding...Leave a comment:
-
Thanks FishVal. I thought that would be the case.
Bugger.Leave a comment:
-
Thanks for answering.
I'll write some code while I wait for the second coming then!Leave a comment:
-
Fair comment.
Is there no hope of recovery then?Leave a comment:
-
Corrupted database. Recovery possible?
This is a long shot...
While I was working on an Access 2000 mdb today (using 2002, but 2000 format), Access unexpectedly closed itself (I have no idea why, I was just running a fairly standard query). When it tried to reopen the mdb, I get the message that it is corrupt - specifically:
"Microsoft Access has detected corruption in this file. To try to repair this corruption, first make a backup of the file. Then,... -
Fixed it.
Removed the CDate([Nom_Date]), replaced with just Nom_Date and used the criteria Between CDbl(Now()-183) And CDbl(Now())
Thanks for your help.Leave a comment:
-
As it happens, the Nom_Date field does include a time value as well, though this is not crucial to the query so I tried using the Date() function call instead and TBH I noticed absolutely no difference. The other macro/query I mentioned previously also includes a time value and I am using the Now() function call succesfully there, which compounds my belief that it may be related to the CDate expression.
Thanks for the reply,
...Leave a comment:
-
I have just had another thought with regard to this:
I am using the same method to export data from a different linked table in the same database; that is I am using a query which has the same:
Between (Now()-183) And Now() criteria for the date to narrow to the last 6 months.
The only difference is that with this query I am NOT using the CDate expression as the date in the table is in the correct format.
This...Leave a comment:
No activity results to display
Leave a comment: