Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DeviousDi

    Remove Parameters in a Command - Help Please!!

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

    Remove Parameters in a Command - Help Please!!

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

    Does Excel have an 'IN' ?!

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

    Does Excel have an 'IN' ?!

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

    Cross Tab Suppress Totals if only 1 line of Data

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

    Previous(fld), is there another way?

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

    Cross Tab - Adding and Extra field

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

    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"...
  14. DeviousDi

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

    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"...
  17. DeviousDi

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

    Previous(fld), is there another way?

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

Part and Inventory Search

Back
Top