Recent content by TechJatt

simple enough...why didnt i think of that?? :) thanks alot though, worked like a charm!

the relevent fields: state (nvarchar), date (date), x (bool) basically, i need a query that will find the number of records where x=1, and display the total for each month and year, so something like: state year month count ------ ------ ------- ------- VA 2002 June...

I am running Citrix on a win2k server, and for some reason, anyone who isn't a Domain Admin cannot do anything in Access. If a database is opened, it brings up the error 'Could not use 'Admin'. File is currently in use.'. This also happens if the user tries to make a new db. I checked the...

I want to make a trigger that automatically sets the date of a field when being inserted. So the trigger goes through and does something like: set tdate = getdate() i cant get it to work through. when i try set inserted.tdate = getdate(), it wont let me. i know that oracle has a 'for each...

I was wondering if there is a way of making a change to Outlook settings across the network for all the users without having to go to each user and do it manually. Specifically, I want to change all the user's settings so that it saves the AutoArchive pst file to the same folder. Anyway to do...

Ok, I'm using xp_sendmail to send reports to users from 2 queries. The problem is that the e-mails are really ugly, so I want to make them just a little more readable. So, my question is, how do you insert a few blank lines in between the 2 queries? I want it so that it'll display the first...