Recent content by DeviousDi

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