Recent content by tomslacks

Install outlook on the server

Hello all, I am trying to setup a vpn from home to my office. At the office I have a netopia router and a NT server. At home I have a win 2K network and a linksys router. I have setup the netopia router using the guides from their website step by step. When I connect the VPN, the status...

awesome thanks to all

I am attempting to extract the two year (03 from 5/6/2003) from a date column and combine the results with another field and I dont know if it can be done. Anyone know how it is done? T

For those interested this is how I was able to get it to work First query qryMaxDate SELECT t2.JOBNO, Max(t1.CDATE) AS LastCommentDate FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.JOBNO=t2.JOBNO GROUP BY t2.JOBNO; Second query SELECT [Table2].[JobNo], [Table2].[Client], [Table2].[City]...

ok, this is my max(date) query Call qryMaxDate SELECT t2.JOBNO, Max(t1.CDATE) AS LastCommentDate FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.JOBNO=t2.JOBNO GROUP BY t2.JOBNO; Then this to bring it all together SELECT t1.JobNo, t2.Client, t2.City, qryMaxDate.LastCommentDate, t1.Comment...

even if i add the parenthesis I still get the same error. The message box doesnt have the line with the error line like a syntax error normally has.

SELECT t1.JobNo, t2.Client, t2.City, t1.Date, t1.Comment FROM Table1 t1 inner JOIN Table2 t2 ON t1.JobNo = t2.JobNo and [Date] = (select max([Date]) from Table1 where t2.JobNo = t1.JobNo; the statement I using is this, I spelled max wrong in the first post, I still get the same error with...

I have tried your query and keep getting an error "Syntax error. in expression". and when I click ok it sends me to the t1.JobNo = t2.JobNo section. SELECT t1.JobNo, t2.Client, t2.City, t1.Date, t1.Comment FROM Table1 t1 inner JOIN Table2 t2 ON t1.JobNo = t2.JobNo and [Date] =...

I forgot to mention DATE() returns the system date when used.

I think the simple answer is DATE()

Hello All, I have two tables that I am trying to join in MS Access and sort by a date and only return the most current date. Table1 JobNO Date Comment 1 4/2/03 yes 1 4/3/03 no 2 4/4/03 yes 3 4/4/03 no 3 4/5/03 yes Table2 JobNo Client City 1...

Awesome that did the trick, thanks for your pointers T

Have been unable to find if I can create non-printing images with acrobat. I have tried to create and image in Illustrator and make the non-printing and save as a pdf but when I open with reader or acrobat it does not show the image at all. I am trying to create a form that users fill out and...

It doesnt show the job as failed in the job log. I put in a tape around 3pm, come back around 4pm to check that the tape is still in the drive. The job is scheluded to run at 11pm, when i come in on Monday morning (happens during theweek also) there is a error message that has a time of 11pm of...