Recent content by rkrause

  1. R

    SSRS 2005 - count rows when details row has a hidden expression

    Im using SSRS 2005, and i have a table thats getting me my correct data. I have this in my one of my fields: =IIF(Fields!ReceiptQuantity.Value < AVG(Fields!ReceiptQuantity.Value) -14,Fields!ReceiptQuantity.Value,"") and in my details row in the visibiltiy i have this...
  2. R

    Most recent Record on a date field

    Im posting this in a sql forum, so im using SSMS not accesss...
  3. R

    Most recent Record on a date field

    No that works, im just interested in the max function too.
  4. R

    Most recent Record on a date field

    can you display that as an example? im confused
  5. R

    Most recent Record on a date field

    That is what i have, i get 4 records returned. All with 4 different dates, i want the most recent record. select a.sumjobcode, max(a.sumEffDate), a.sumFinalPoints, b.jobtitle, b.DSCRIPTN FROM tblSummary a left outer join vDepartments b on a.sumJobCode = b.JOBTITLE where a.sumJobCode = 'CMTCH'...
  6. R

    Most recent Record on a date field

    I tried using the max but i would get more then 1 result
  7. R

    Most recent Record on a date field

    Nevermind i get where you are coming from, i think that will work. i overlooked your order by.
  8. R

    Most recent Record on a date field

    what if my date i want isnt always the top row.
  9. R

    Most recent Record on a date field

    I am having trouble trying to get the most recent record. heres my query i get no results on this query. Basically what i want is if CMTCH has 4 records over 1 year. I want the most recent record. Example 10-1-12 8-1-12 2-15-12 5-25-12 I would want the records with the 10-1-12 date...
  10. R

    Getting previous Days Data

    NM that didnt work. It worked until we started adding records in the table for todays date 9-21-12.
  11. R

    Getting previous Days Data

    That worked thanks.
  12. R

    Getting previous Days Data

    09/19/2012 09/20/2012 1/19/2011 1/19/2011 1/19/2011 Yes im in USA
  13. R

    Getting previous Days Data

    Im puzzled as well...Im not sure, it should be date/time field.
  14. R

    Getting previous Days Data

    i was able to find this and it seems to work. not sure whats different than ive already tried. SELECT *--,MIN(formatdate) FROM bk_vAPTData WHERE formatdate>=DATEADD(d,DATEDIFF(d,0,GETDATE())-1,0) AND formatdate<DATEADD(d,DATEDIFF(d,0,GETDATE())+0,0)
  15. R

    Getting previous Days Data

    Neither of the last 2 posts got me what i need. Boblarson i still only get 9-20-12 data and not yesterdays 9-19-12 and SQL_hell i dont get any results from you.
Top Bottom