Search results for query: *

Hi Dana, Tried the replacement, comes up with the error: Database connector error: 42S22[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Column Name 'SYSDATE'[Database vendor code:207] Came up with this when I tried other things! Thanks Di

Hi, I'm hoping someone can help, because my knowledge of commands is severely limited! I have the following command, and all I want to do is remove the two parameter fields, datefrom and datetill, and replace them with the current date, the datetill parameter, and the current date -7 days, the...

Hi Skip, I'm a little confused here! (Not hard, trust me!) You say to replace: ('DISPUTE DETAIL'!$H$5:$H$4999<>"T702")*('DISPUTE DETAIL'!$X$5:$X$4999<>"S01") with: NOT(ISNA(MATCH(Val,MyList,0))) After I have created my list, but how does this work when there are two different columns being...

Hi, I have the following formula: =SUMPRODUCT(--('DISPUTE DETAIL'!$J$5:$J$4999=SUMMARY!$CU1)*('DISPUTE DETAIL'!$X$5:$X$4999<>"S01")*('DISPUTE DETAIL'!$H$5:$H$4999<>"T702"))+SUMPRODUCT(--('DISPUTE DETAIL'!$J$5:$J$4999=SUMMARY!$CV1)*('DISPUTE DETAIL'!$X$5:$X$4999<>"S01"))+SUMPRODUCT(--('DISPUTE...

Hi, I've had a good rummage round the other posts, but don't seem to be able to find any help on this one! I have a cross tab that shows how long various queries, in days, have been in the database. Column heading: Query Status Desc (various status's) Row Headings: Dispute Type...

Hello All! Thank you so much for all your help! I've finally managed to sort it out using various bits and bobs from this post. I'd buy you all a drink, but I can't, so stars and virtual drinks for all!! Thanks again Di [cheers]

Hi, I have a cross tab report set up like so: QueryStatusDesc Total Dispute Status Sum@Days Sum@Days CountQuery.id CountQuery.ID Under the CountQuery.id total I want to add my own calculation, the average. Basically the figure for...

Hi Pete, I know I can use the previous function in the detail section, the problem being is that its a summarized field, and so won't allow me to sum it, average it or anything else, and that's what I am desperately trying to do! This is the SQL code: SELECT...

Hi Dell, I've done the calculation, but the field that's been created doesn't hold all the data, its missing dates. If you look at the example above, all the records are missing the first two dates - the new field, and in the first case, none at all! How can I get these to populate? Thanks Di

Hi Del, Did the changes, and used this code: SELECT query_status_changes.query_id, query_status_changes.id, query_status_changes.old_standard_query_status, query_status_changes.new_standard_query_status, query_status_changes.date_changed, debtors.debtor_number, query_status.fixed...

Dell, Can I also ask why you have said: when qsc1.query_id is null then 0 query.id will never be a null. The only null that could be possible is the first date difference between the 'old' query status and the 'new' query status. Thanks, I'm just trying to understand Di

Dell, Sorry about the code, but when I changed the query you gave me, with the changes to told me to make: SELECT query_status_changes.query_id, query_status_changes.id, query_status_changes.old_standard_query_status, query_status_changes.date_changed, debtors.debtor_number...

Oh dear, I owe you a HUGE apology! I'm missing a field. Its in my crystal report, but for some reason its not in the SQL code. This is the proper code SELECT "query_status_changes"."query_id", "query_status_changes"."id", "query_status_changes"."new_standard_query_status"...

HI Del, I used your code, and the days_between comes through as all 0's. I haven't changed anything yet. Sorry for being a pain, I am trying, honest! Di

eeeekkkkk!!! I've just had a real look at the data, and all my 'days_between' are coming back as 0!!! That's not right! So much for getting all the pesky gremlins out of the system! Di

Hi Hilfy, Thank you so much! Got it to work with the following code: SELECT "query_status_changes"."query_id", "query_status_changes"."id", "query_status_changes"."old_standard_query_status", "query_status_changes"."date_changed", "debtors"."debtor_number", "query_status"."fixed"...

Hi Hilfy, Another day, minus the bat costume and its still not having it! Here's the error message: database connector error 420000 the multi-part identifier q.id could not be bound database vendor code:4104 and the same for q.debtor_id, q.query_status.id, q.standard_query.id...

Hi, Thank you all so far. I've tried the last post, now its coming back with this error: database connector error 420000 the multi-part identifier query_status_changes.query_id could not be bound database vendor code:4104 Its Halloween, maybe I should be expecting all this?! I am dressed as...

HI, Have tried the above, but removed the 'where' line, and keep getting the error: failed to retrieve data from the database details 420000 query_status_changes.query_id is invalid in the select list because it is not contain in either an aggregate function or the GROUP BY clause database...

Hilfy The code would be bloomin fantastic, if you don't mind? The field I basically need the 'days' for is "query_status_changes"."date_changed", to show how long its take to move from one "query_status_changes"."old_standard_query_status" to another. Here's the code if it helps!! SELECT...