Help, I can't read and don't know how to attach a file... Sorry, some people are finding it easier to push my buttons today.

When creating or editing a post, look down in the Post options section where it says Attachments.

Never time to do it right, but always time to try and fix it. Oh, don't forget, we don't have the resources to bring in an experienced individual to...

How about putting the information in a text file, uploading that and editing your post to remove all the info you posted?

Thanks. Normally I'm pretty good about reducing Boolean...

anthony.green (11/25/2015)

---

Please post create view/table scripts along with sample data for the following tables / views

vw_tblBusinessFinancialInformation - and all referenced tables in the view

vw_tblCompany_BusinessFinancialInformation - and all referenced tables in...

woody_rd (11/24/2015)

---

Looking for a new column with the difference between most recent and it's predecessor. A dataset such as this:

CustomerID, CustomerName, AuditNum, AuditDate, DateDiff

11111, Cust1, 1, 2015-10-01, 0

11112, Cust2,...

j-1064772 (11/24/2015)

---

The need is to compare the revenues of each month with the revenues of the same in the previous year.

For instance, customer 'A' was lost in 2014, so the...

SQL in Access is not T-SQL which is what SQL Server uses. Posting in a SQL Server forum is going to get you a SQL Server answer.

There is a...

Query is correct for Access.

vineetbhargav (11/24/2015)

---

Thanks, i tried this way only thing which is different over here is where condition i place that condition in ON instead of where and that resulted in...

Luis Cazares (11/24/2015)

---

I believe this should be equivalent.

SELECT sum ( isnull ( s.amt_du_ic, 0 ) ),

d.pmt_dte,

r.juris_id,

c.acna,

...

woody_rd (11/24/2015)

---

I have a somewhat unique situation and need to figure out a way to get datediffs from multiple rows of data. I already have a row number value...

ChrisM@Work (11/24/2015)

---

PHXHoward (11/23/2015)

---

They are using it to create an export of the column to a text file. The _ + primary key is how they want to label the...

jasona.work (11/24/2015)

---

GilaMonster (11/24/2015)

---

jasona.work (11/24/2015)

---

ThomasRushton (11/24/2015)

---

Me, I'm heading down the path of nuking the server completely. But I'm in the wonderful world of being able to rebuild and redeploy a...