Search results for query: *

I made a parameter form that works great, but when the enter key is pressed it will close the form. I would like the OK button (vba routine) activated if the enter/return key is pressed. Is this easy to do? Peter

This query does not assign 1, 2, 3 SELECT abc.LastName, abc.SSN, DCount("ssn","tblsstudents","ssn<=" & [ssn]) Mod 3 AS C FROM abc GROUP BY abc.LastName, abc.SSN; Results Frank 555-55-5551 1 Sam 555-55-5552 2 Homeboy 555-55-5553 1 Would like the Mod num to be 1, 2, 3 and...

Actually sounds easy, I will try on Monday at work. Thanks so much. Peter

OK,I can see how to get the total records from query, but now to get a report for 3 groups is the problem. Peter

I query a class by class number (08-027), but now I want to break that class down by A, B, or C Group based on number of students in query, this week it could be 80, next week 110. What I am looking at. - Run a query to pull everyone in that class (08-027) - Based on the class size (lets say...

Creating a new DB to track students. I created a Table with like 25 fields for personnal information etc. I also created a Table with 20 fields to track scores for events with a one to one relationship. Question is should I keep the tables split with a one to one or should I just throw them all...

That did it, Thank you very much. Does this site have a feedback section? I try reading the code but I guess experience in using it will help. Peter

OMG! That is sooo close, the results are grouped perfect, status (completed or due is perfect) just getting one error msgbox (Enter Paramenter Value, tblPEvals.Evaldate)and results have Evaldate as Expr1 as blank. SELECT tblPPersonnel.SSN, tblPEvals.EvalDate...

Greetings, this is where I am at SELECT tblPPersonnel.SSN, tblPEvals.EvalDate, IIf(DatePart("q",Date())=DatePart("q",tblpevals.evaldate),"Completed","Due") AS Status FROM tblPPersonnel LEFT JOIN tblPEvals ON tblPPersonnel.SSN = tblPEvals.SSN; **** Make a query showing the SSNs, Evaldates...

I tried what fneily stated and it was a quick fix but I still had duplicates. I am close on the pwise option, the select worked great but my join has issues The first part worked: SELECT tblPPersonnel.SSN, tblPEvals.EvalDate...

I will look over this on Tuesday. BTW, I have always been impressed on the help I receive, thanks. Peter

I have some knowledge on VB, just need help solving a routine, I cannot get the desired results in Access query: Scenario: I have two tables in Access that I joined, Left outer join to select all names and then my sub table all of the evaluations (1 per quarter). I need an access rpt to state...

I have tblpersonnel with SSN (Join one) to tblEvaluations with SSN (many) and EvalDate (1 per quarter) End result, I need to know who has not received an evaluation after a certain date. I want to select All records in tblpersonnel and only records in tblEvaluations where the date is null or...

My concern was having a table slowed down due to too many records, if that is not an issue, then I will just add a field for CurrentEmployee. Peter

I have a database for personnel, the problem is they rotate in and out, so I want to move people who left to a history table. I have an access table of personnel with two related subtables. My thought is have a macro delete the records from the sub table then select the record from the...

I put a network together with 4 computers, using a name in the workgroup to see each other. 3 computers see each other just fine. My problem child - 1 computer: I run through the wizard and it finishes, but Windows XP says the workgroup is not available when I click "View Workgroup computers"...

I have a Lab where students log into W2K to a server, which in-turn creates a profile for them. This fills up my hard drive with profiles and Temp Internet Files. Can I set the Registry to either delete the profile or delete the Temp Internet Files when the user logs off. Pegte

Thanks for the direction, I used Autolookup in query, man you really need the thinking cap on for this one. Pete

First, place your database where everyone can get to it, mine are in a server with a folder named &quot;databases&quot;. This is the backend and will only contain tables! Lets say this is &quot;Apartments&quot;. Copy the existing backend (call it Apartment Interface&quot;), this is the...

Mike Did you try looking at your database in a stored/user model. I manage multiple Access databases by keeping the database tables (called backend) on a server/shared drive and the database forms/queries/reports (frontend) in a different file. With this the data stays in one place and the...