Search results for query: *

I have the following query: UPDATE ParticipantListing INNER JOIN tblPersonal ON ParticipantListing.User = tblPersonal.User SET ParticipantListing.[START DATE] = [tblPersonal].[FCSD] WHERE (((ParticipantListing.[MEMBER STATUS])=". Yes a Member")); When I run this query, it is supposed to...

Hi, I have the following update query that I haven't tried yet: UPDATE tblPersonal INNER JOIN ParticipantListing ON tblPersonal.User = ParticipantListing.User SET ParticipantListing.[START DATE]= "tblPersonal", ParticipantListing.[START DATE]= "tblPersonal", ParticipantListing.Email =...

Hi, I'm trying to write an OnExit event procedure so that if the date in the TxtStart field is 01/01 of any year, then the TxtEnd field will automatically show 12/31/ of that year. Or else, TxtEnd field will automatically show the last day of the month/year for the TxtStart month/year. I...

Hi, I have an afterupdate event on a date field that will make the next date field the last day of the month based on the first date field: afterupdate code Private Sub TxtStart_AfterUpdate() Me![TxtEnd] = DateSerial(Year(Me![TxtStart]), 1 + Month(Me![TxtStart]), 0) End Sub Now, I want to...

Hi, I have a query that displays the ProgPlanD (program plan date) that is between a date range in a form. I would also like it to display the previous and next month program plans. The program plan date will always be one row on the first of each month. Here is my query: SELECT...

I've found something similar to this on the forums, but not exactly, and I can't figure it out. I have a query: SELECT Format(tblProgramPlan.ProgD,'mmmm yyyy') AS ProgramDate, tblProgramPlan.NLProg, tblProgramPlan.STProg, tblProgramPlan.WBProg FROM tblProgramPlan WHERE (((tblProgramPlan.ProgD)...

I have the following query: SELECT tblScr.ScrLoc, Sum(IIf (tblScr.BP,1,0)) AS ["TBP"], Sum(IIf (tblScr.Mam,1,0)) AS ["TMam"], Sum(IIf (tblScr.Osteo,1,0)) AS ["TOsteo"], Sum(IIf(tblScr.PSA,1,0)) AS ["TPSA"], Sum(IIf (tblScr.Colo,1,0)) AS ["TColo"], Sum(IIf(tblScr.Choles,1,0)) AS ["TCholes"]...

Hi, I have a main report that displays 5 winner's names and other fields associated with that winner (like location, email, phone, etc.) in the "justified" format. This is for the staff to locate the winners. Name, location, email, wk phone, cell phone, t-shirt size, etc. I want a subreport...

Hi, I have a form that I want to check a table to see if it has any matching fields (WinTyp and WinD) WinTyp is a text field and WinD is a date field. I can't get the syntax right for "set rs" Private Sub Search_Click() Me.Visible = False Dim rs As Recordset Set db = CurrentDb Set rs =...

I have 8 queries that say how many people participated in a specific program between parameter dates. Here are the queries: qfltOpsPGASP SELECT tblLoc.LocID AS [Work Location], tblGASP.PID AS [Total GASP] FROM (tblLoc INNER JOIN tblPersonal ON tblLoc.LocID = tblPersonal.LocW) INNER JOIN...

Is there a way to display subreport only when "between dates" include certain months? I have a subreport that only applies in February. And another subreport that only applies in Nov, Dec, and Jan. Can I have it only display when the criteria of BETWEEN dates includes those months? Thanks...

I need to determine how many CLASSES there were between certain dates so I can get an average attendance per class. I can't figure out how to go about it. Here is my current query: SELECT qryGrpEx.GExLoc, tblGrpExCls.ClsNames, Format([GExD],"dddd") AS [Day], qryGrpEx.GExTme...

Hi, I have the following query: SELECT Month([WOD]) AS [Month], Count(U.PID) AS CountOfPID, U.PID, tblLoc.LocID, U.WOLoc FROM (tblPersonal AS P INNER JOIN tblFCUtil AS U ON P.PID = U.PID) INNER JOIN tblLoc ON P.LocW = tblLoc.LocID WHERE (((U.WOD) Between [Forms]![fdlgOps]![txtStart] And...

I have a query that I would like to show how many people work out at each Fitness Center site - that do not work at a Fitness Center site. Fields: tblPersonal.LocW = work location qryFCVisitsPID.WOLoc = workout location tblPersonal.FCSite if checked is an FCSite (Yes/No) My current code is...

I have an append query: INSERT INTO tblWIN ( PID, WinD, WinTyp ) SELECT TOP 5 qfltWALKParticipants.PID, Forms!fdlgWALKWinners!txtStart AS WinDate, "WALK" AS WinTyp FROM qfltWALKParticipants ORDER BY Rnd([PID]); That puts 5 winners into tblWIN with a WinTyp = WALK each month. (and other...

Hi, I have a form with a combo box called "ChooseName" that has the following Row Source: SELECT tblPersonal.NameL & ", " & tblPersonal.NameF & IIf(Len(NZ(tblPersonal.NICK,""))>0," """ & tblPersonal.NICK & """ ","") & " " & tblPersonal.SUFFIX AS Name, tblPersonal.PID, tblPersonal.LocW FROM...

I have the following query: SELECT Month([WOD]) AS [Month], qryFCVisitsPID.WOLoc AS WorkOutLocation, Count(*) AS [Distinct Visits] FROM qryFCVisitsPID WHERE (qryFCVisitsPID.WOD) Between Forms![fdlgOps]![txtStart] AND Forms![fdlgOps]![txtEnd] GROUP BY Month([WOD]), qryFCVisitsPID.WOLoc...

I am trying to have a query display the number of visits for a specific location. Does someone have an idea on where I'm going wrong? SELECT [Fitness Center Location] AS WorkOutLocation, Count(*) AS [Distinct Visits] FROM qryFCVisitsPID GROUP BY [Fitness Center Location] HAVING...

I have a report based on a query: SELECT TOP 5 qfltWALKParticipants.FullName AS FullName, qfltWALKParticipants.WalkLoc, qfltWALKParticipants.LocW, qfltWALKParticipants.Dept, qfltWALKParticipants.LocFC1, qfltWALKParticipants.LocFC2, qfltWALKParticipants.PhoneW, qfltWALKParticipants.PhoneH...

Probably a stupid question - but I can't find any information on it. When I run a report, after I close the report, the query is displaying behind it. I don't want my end users to see this. Will this go away when I make a front/back end? Or do I need to do something to the reports? Thank...