Viewing 15 posts - 1,981 through 1,995 (of 2,452 total)
gcresse (2/13/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 12:53 pm
kschwid (2/13/2012)
It's a weird situation and I wish I had someone here at my work that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 11:45 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 11:12 am
gcresse (2/13/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 11:05 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:59 am
Stephen_W_Dodd (2/13/2012)
On all of my applications, I have a "Splash" screen to announce certain information to the user at startup. I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:53 am
kschwid (2/13/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:42 am
Sean Lange (2/13/2012)
Jeff does a great explaining this here. http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D
and a follow on here
http://www.sqlservercentral.com/articles/Crosstab/65048/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:33 am
kschwid (2/13/2012)
I need to find the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:30 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 10:16 am
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),...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 9:34 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 13, 2012 at 8:12 am
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)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 12, 2012 at 1:47 pm
bitbucket-25253 (2/12/2012)
LutzM (2/12/2012)
Digs (2/11/2012)
Sir, I am an old fart working on a private project...just needed a little help !Thanks 🙂
"A little help" in the meaning of "Give me some fish"...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 12, 2012 at 7:32 am
L' Eomot Inversé (2/11/2012)
bitbucket-25253 (2/9/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 11, 2012 at 11:51 am
Viewing 15 posts - 1,981 through 1,995 (of 2,452 total)