Recent content by PlsHlpKat

I am trying to search a binary field on a SQL Server database. I thought I could enable full-text searching for the database, create a full-text catalog, enable full-text search for the specific table (create index, add columns to it, populate it). I think at this point I could use special...

I am using Crystal Reports v11 connecting via ODBC to a SQL Server database. The SQL database has a binary notes field that is showing up in Crystal as a BLOB. I need to be able to search this field. When I try selection expert the field does not even show up to search. I also can not view...

Yes, I understand that but my questions is how can I migrate the user accounts and all of the data to the new machine. Can I have both servers on line at the same time and just move the info across the network? If so how?

I will be replacing an existing WinNT4.0 server with a brand new Windows Server 2003 machine. I have done NT - 2003 upgrades but have never done a server migration. There is only three users at this location. I know on WinNT I can create a PDC and a BDC but not sure how this works for...

I had to install Office 2002 on the ne PC to replace Office 2003 now the files open with no problems. If anyone has any information on this Occie 2003 problem please let me know.

I just got a new dell machine running WindowsXP Office 2003 When I try to access a machine on my network running windows98 and Office2002 I get a blank excel screen the document never opens. I copy and paste it the XP machine I can open the document fine.

Thank you golom! This works great!! Kat

I copied your code word for work and I am still getting all records??? Kat

I have a table with EmpID, Name, Status, Payrate, Effective date, etc. showing employee status changes there is a new record for each change. I need to do two things with the table. 1. A report: I need to do a query to pull the record for each employee that has the latest <Eff date>. 2. A...

My code is not working I am getting Syntax error am I doing something wrong? SELECT[CLOCK #], [Last Name], [First Name], [Hire Date], Status, [EFF Date], [Review Date], Action, [Rating Code], [Increase Amt], [Inc Perct], [Pay Rate], [Next Review], [Department/Team], [Cost Center], [Job...

I have a table with EmpID, Name, Status, Payrate, Effective date, etc. showing employee status changes there is a new record for each change. I need to do two things with the table. 1. A report: I need to do a query to pull the record for each employee that has the latest <Eff date>. 2. A...

Yes I am inserting a new record for each change but I am not clear on what you mean by a time stamp, could you please explain?

I have an HR system in Microsoft Access, one table lists pay rates, merit increases, status changes etc. but I need only the current pay rate and information to show up on the reports and main form. As it stands right now the reports lists every pay rate and status change. I do need to keep a...

Thanks!! That worked!

How can I do a query by Birth month only using the birth date field? i.e. I need a report for all birthdays in January regardless of year.