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...
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...
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] =...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.