Search results

Thanks! Works like a charm! I appreciate the help!:)

and I have the SQL for both queries, can you PLEASE help to convert the pendingcrss (select query) to the crosstab?? I need it to be a subreport on a main report. Becuase of the SQL in the crosstab that references the select, the report see's it as forgien. Select query: SELECT...

The query works like a charm! Thanks for all of your help! Is there a way to provide feedback for your account?

Thanks for the quick response! Where do I place the iIf statement, in the select query, or the crosstab? You will have to excuse me, I am very new to access. If you can break down the steps that is great! I did get the dateDiff to work and place that as a column (days) in my select query.:)

I am really perpplexed with this one. Right now I have 4 separate queries running from one table (counsedetails) that show the status of a request (status) and the date that the status changed [status change date] so I know a count of what claims (claimnumber) has been pending over 5 days, 6-10...