Search results

I have a query that contains Invoices(usually 2 line items per invoice) Taxable and NonTaxable. I need to able to basically export it to excel on multiple worksheets when the Amount of unique invoice number reaches 15. From all my scouring on the internet I can't find anything with this...

So I have an AR report, that currently we track by our MailDate. Issue is some times the maildate is not inputted into the system and it gives the date 1/1/1900. Then I filter my report for Accounts that have that 1/1/1900 in there Maildate then I run an UPDATE query on all those Invoices to...

So I am writing a query that gets last quarter sales and I'm trying to figure out how to make it so that WHENEVER i run it, it will get the last quarter sales. If it helps the datetime column is called DOCDATE.

Hello Again! Im working on another report, an Aging AR report. And Im trying to make a column were it looks at the MailDate and then determines the Age of the AR - Case WHEN [Open AR 1].MailDate > GetDate()-30 THEN 'Current' WHEN [Open AR 1].MailDate BETWEEN GetDate()-31 AND GetDate()-61...

Hey all so I need to convert this daily report I run every morning to T-SQL, however I am having extreme difficulty converting the IIF statement I have in the Where clause of my access report to SQL. Here is what I currently have and works fine - SELECT JJobs.Job, JJobs.RNum...

Hey guys, I'm trying to run a report that I need to run every morning for the jobs opened the day before, However I would it to also give me Fridays/Sat/Sundays Open jobs when I run Monday. While running the report Tuesday-Friday it will only give me the day before jobs.

So I have a table that has basically the history of Statuses of Job Numbers until the status is set to closed(this includes information like date/who changed the status etc). And what I am trying to do is run a query that will group by Job Number and have the second highest date, which will in...