Recent content by swimtiger

Thank you to PHV. I appreciate your time and efforts. The quer works just like I wanted it to. Kudos!

Hi! I'm running 2003 here, and the db was made with 2000. I saved the first query as qry1stdate and then ran the second query. Still getting the "Syntax error in JOIN operation." Thanks

I used your query, substituting your values with mine: SELECT A.ClientID, A.PlacementDate, A.Center FROM [AA Job Placements] INNER JOIN (SELECT ClientID, Min(PlacementDate) As CheckDate FROM [AA Job Placements] GROUP BY ClientID) B ON (A.ClientID=B.ClientID) AND (A.PlacementDate=B.CheckDate) ...

OK, I thought this worked, but it did not. I looked at my original post and saw that I did not explain myself as well as I should have. This is what I would like to see in my query results. - Every client who has checked-in. - That clients first check-in date, regardless of center. - The...

AWESOME! Thank you.

Hello, I tried searching so I would not ask a repeat question, but I did not find my answer. Without any further ado: I have a table that tracks clients check-in dates at centers. I would like my query to display a client's minimum check-in date and the center name. When I currently run my...

You could try doing a low-level format of your drive if you are able to first back up all of your data. There a few ways to do a low-level format. 1. If it is a maxtor drive, or if you have a maxtor drive in your system. You can download Maxblast and burn it to a a bootable cd or floppy at...

I would like to create a parameter query that asks for the month instead of asking for a beginning and ending date. Currently, my criteria line looks like this: Between [Type the beginning date] And [Type the ending date] To view the records for July 02, I have to type 7/1/02 and 7/31/02. I...

Ok, thanks for the help guys. You definitely got me in the right direction. Here is what ended up working for me: SELECT tblJobPlacement.ClientID, Max([tblJobPlacement]![PlacementDate])-Min([tblJobPlacement]![PlacementDate]) FROM tblJobPlacement GROUP BY tblJobPlacement.ClientID;

Ok, I ran your query (I replaced examplefield with clientid), and I got the same error message. Syntax error (missing operator) in query expression 'MAX(tblJobPlacement.PlacementDate) MaxUserDate'. Any ideas?

When I run this query: SELECT COUNT(tblClient.ClientID) FROM (SELECT (tblClient.ClientID), MAX(tblJobPlacement.PlacementDate) MaxUserDate, Min(tblJobPlacement.PlacementDate) MinUserDate FROM board GROUP BY user_id) TempTable WHERE DATEDIFF(day, MaxUserDate, MinUserDate); I get this message...

Hi Dodge20, Thanks for the fast reply. I have to admit that I am just learning SQL, so I could use a little explanation, please. I am trying to calculate the difference between the MAX and MIN for a date field. Where does the MIN date fit into your query?: SELECT COUNT(user_id) FROM...

I have a field that contains the date that a client was placed into a job. There are multiple placements for each client, and I would like to calculate the number of days between the first and last placements for each client.

You might need a newer version of Partition Magic. Not all versions work with NTFS. Check with the manufacturer's website: http://www.partitionmagic.com/

This may not be the solution that you are looking for, but you can use Edit, Replace in Excel to remove all of the marks.