gcresse (2/13/2012)

---

The temp table would not be wide enough. I need the ability to calculate running percents on each component in the final product, and often times there are...

kschwid (2/13/2012)

---

I will try to look into those things. Thank you for all of your help.

It's a weird situation and I wish I had someone here at my work that...

hmmm....without having your db in front of me, it is very difficult to help you further.

one idea....is there a "start up / splash" form that is called when the Access...

gcresse (2/13/2012)

---

I just read this article about SQL Server 2012's new features (http://blog.tallan.com/2011/12/08/sql-server-2012-windowing-functions-part-1-of-2-running-and-sliding-aggregates/) and I'm thinking it *might* solve my problem, as long as I can join to other tables....

ok...what does query "z_log_refresh" do? the "open query" at the bottom of attachment.

am getting a bit OOMD on this...my Access "skills" were based on VBA not the wonderful...

Stephen_W_Dodd (2/13/2012)

---

Apologies to Chrissy for butting in again, but to add:

On all of my applications, I have a "Splash" screen to announce certain information to the user at startup. I...

kschwid (2/13/2012)

---

One of the Report Applications (in Access) that I am looking to recreate some of the reports from, does have a refresh button. I look at the buttons properties...

and a follow on here

http://www.sqlservercentral.com/articles/Crosstab/65048/

kschwid (2/13/2012)

---

--Local access tables initially populated from the SQL DB (this is where I am stuck and trying to figure out how these are populated.)

I need to find the...

as per your previous post......in Access design view...switch to SQL view...cut and paste following...assuming you have provided correct table/column names...if not modify as necessary

SELECT Q.col1, Last(Q.col2) AS Top1DATE, Last(Q.col3) AS...

What I need to accomplish. I am supposed to be basically recreating their reporting in SQL Server RS 2008 (will get installed in a couple weeks with SQL 2008 R2),...

try this

SELECT Q.col1, Last(Q.col2) AS Top1DATE, Last(Q.col3) AS Top1QTY, First(Q.col2) AS Top2DATE, First(Q.col3) AS Top2QTY

FROM (SELECT col1, col2, col3

FROM tableA

WHERE col3 IN

(select top 2 col3 from tableA as S

where s.col1...

DECLARE @CurrentDate DATETIME

SET @CurrentDate = GETUTCDATE()

select @currentdate

select YEAR(@CurrentDate) * 100 + MONTH(@CurrentDate)

select YEAR(Dateadd(MONTH, 1, @CurrentDate)) * 100 + Dateadd(MONTH, 1, @CurrentDate)

bitbucket-25253 (2/12/2012)

---

LutzM (2/12/2012)

---

"A little help" in the meaning of "Give me some fish"...

L' Eomot Inversé (2/11/2012)

---

bitbucket-25253 (2/9/2012)

---

Wine, beer ugh. Give me good old Kentucky Burbon on the rocks ,, no water no soda .. now that is a drink fit for...