Search results

I could be wrong :o but I think this problem is much too complex for a query to handle. Even if you group by zip code alone, more information is needed to assure the logic path you desire. Imagine this mythical city's zip code arrangement: 85000 85001 85002 85003 85004...

Post your SQL statement so that we may have a look. Jeff

Since you will (by definition) only have 2 dates associated to any one ID, I would suggest you alter your table to be: ID, StartWeight, StartDate, EndWeight, EndDate Any reason why this would not work? I do not believe that this violates Normalization rules (and will be alot easier to...

This may get you started: SELECT [fldEmployeeID], [fldTrainingTasksID], Max([fldDate]) AS fldCompletionDate FROM tblEmployeesTraining GROUP BY [fldEmployeeID], [TrainingTasksID] Assign the (sub) Form source to the query above and then link child/parent on fldEmployeeID. HTH, Jeff PS To be...

Pat (once again) makes great points: Nulls will disrupt your calculations, so encase anything that could be a Null in Nz(). Admittedly, the grades should be in another table with a relational reference so that if you decide to have 4, 5, or 15 scores your code could easily accomodate. But if...

As much as I hate to do it, it looks like I'm stuck with this cludge: :eek: SELECT tblContacts.*, DLookUp("fldCity","tblZipCodes","fldZipCode = '" & Left(tblContacts.fldZipCode,5) & "'") AS fldCity, DLookUp("fldState","tblZipCodes","fldZipCode = '" & Left(tblContacts.fldZipCode,5) & "'") AS...

This also won't work: Query1: SELECT tblContacts.fldContactID, Left([fldZipCode],5) AS fldZipCodeRoot FROM tblContacts; Query2: SELECT tblContacts.*, tblZipCodes.fldCity, tblZipCodes.fldState FROM (tblContacts INNER JOIN Query1 ON tblContacts.fldContactID = Query1.fldContactID) LEFT JOIN...

If I understand you right Pat, I think I've tried that too.. Query1: SELECT tblContacts.*, Left(tblContacts.fldZipCode,5) as fldZipCodeRoot FROM tblContacts Query2: SELECT Query1.*, tblZipCodes.fldCity, tblZipCodes.fldState FROM Query1 LEFT JOIN tblZipCodes on...

Try "000-0000"

Nulls cause calculations to return Null. Type these examples into the immediate window: ? 3+4+Null Null ? 3+4+Nz(Null) 7 Therefore, surround your fields with Nz().

You can create a calculated field within the query: SELECT tblStudents.*, ([field1] + [field2] + [field3])/3 as fldAverageScore FROM tblStudents As per eliminating Nulls (if I understand you), you would replace the number "3" with a condition that evaluates each field and if it exists adds 1...

I have a database of contacts (tblContacts). One of the fields is fldZipCode. I have a database of zip codes that contain fields fldZipCode (pk), fldCity, and fldState. I'd like to create an updateable query (to be used by a form) that joins the Contact information and City/State. The...

Use of OnCurrent I can't speak for racemadnss and his listbox issue. For me, I was trying to change the Caption of the Form (to the patient's name) as the user moved through the database. This could only be performed in VBA and the AfterUpdate event wasn't being triggered since most of the...

Had same question. Thanks for the tip. :p Jeff

Thanks for your responses: Kevin_S - I should have made myself more clear. I was wanting to achieve the name changing via code so other (non-programming) users would be able to do it. I was able to get this to work: Private Sub cmdChangeName_Click() Dim sList() As String sList =...

I can't find the answer to this simple question in the archives: I have a listbox based on a "value list" (for example): Red Green Purple How do I change the second item to read "Yellow": Red Yellow Purple Thanks for any help, Jeff

View Word VBA by: Tools->Macro->Visual Basic Editor View Access VBA by: Tools->Macro->Visual Basic Editor Since Access minimizes upon opening the word document, I suspect there is a minimize code in your Access VBA. When you said "i have a link in my database" I presume this means you have a...

I've had limited experience in securing my own databases, but I would perhaps state the obvious and recommend opening the mdb back-end and use the security wizard to now secure the back-end. Warning: I do not know how this will influence your front-ends ability to access the data in the secured...

Dane, I too have an Access database that opens a Word file (actually a Word template), but my Access window doesn't minimize upon closing the Word document. I would check to see if there is any code in the Word VBA that might be causing this. Also, does the Access window minimize when you open...

The constant vbCrLf can insert a line break. Example: strText = "This is line one." & vbCrLf & "This is line two."