Search results for query: *

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...

Hello All, I am using BE 8.5 on a Sony backup device with WinNT 4.0 server. On fridays I do a normal back-up at 11pm. for the last several weeks when I come in on monday morning the backup has not started and has kicked out the tape. I get an error stating unrecognized media, I push the same...

I cant get my samba shares to work. I can see my linux server in My Network Places (win2K with AD) but I cant see any shares. I am getting an IP address from DHCP and my Linuc server is registering in WINS . When I try to get on to the Linux server in My network places I get an error box with...

Hello all; I am a Linux novice and am trying to setup a red hat 7.3 Linux file server for my Windows 2K & Mac OSX home network. I have tried several simple smb.conf setups and am able to get online with the Linux box. My linux box is getting a address from DHCP but i cant see it in the...

After posting the question, I have decided to implement all XP pro, I am not a big fan of XP but I found that from between the time I setup the computer for the new user to when I posted this question (1 week) the user had uninstalled file and print sharing. He claimed he never uninstalled...

Have this really annoying problem. I have a win98 client on a single WinNT server. Using Dhcp, the Win98 client is able to logon to the network, use the network folders, I can ping the Win98 client BUT I cant see the Win98 client from other computers or the server. There is an account on the...