Search results for query: *

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.

Let me start off by saying that this is the first time I have ever used MSQL server. My office has a SQL database that a company built for us, and it is stored on our SQL server. My boss wanted me to export this database into an Access database. I was able to transfer the data tables without...

Great, thanks guys. Got it working.

I have a table with 14 yes/no fields. I want to be able to count the number of yes responses that a user has.

Thanks so much for your patience and advice. I am going to give this a try!

Also, I would prefer not to use forms because there are 12,000 records in this DB, and I am assuming that each record would have to be updated if we did this with a form?