Hello all,
It is my first post :) (http://1universityofphoenix.blogspot.com)
I want your thoughts on this:
Do you feel that because your parents may have supported you when you were younger, that you "owe" it to them to support them now?
(Pay the bills they run up etc, just because they did it for you when you were younger and unable to work)
Thanks. :) (http://buyamoxicillin.blogspot.com)
Parents can have one or more children. I want to return the youngest child of those parents with more than one child.I have [QryParent&children] that returns all the parents and all the children. I have used this as a sub query in [QryParents>1child]. This uses "In (SELECT [ParentsId] FROM [QryParent&children] As Tmp GROUP BY [ParentsId] HAVING Count(*)>1 )" as the criteria in the ParentId. This returns all parents with more than one child and gives the name and DOB of the child.I now want to return just the youngest child for each parent.An ideas?
View 1 Replies View RelatedI have modules and procedures. A module can consist of one or more procedures. A procedure can belong to one or more modules.
tblModules
--------
ModID
ModName
tblProcedures
----------
ProcID
ProcName
ModProcs
--------
ModProcID
ModID (FK)
ProcID (FK)
In a listbox I have a one or more modules selected and will construct the SQL in the AfterUpdate, presumably.
How to get a query to list only those procedures that belong to all the selected modules? To get into the result list a procedure must belong to all the modules that were selected. The code below gives me all the procedures that belong to at least one of the modules selected. I need ALL.
Code:
strIN = Left(strIN, Len(strIN) - 1) ' list of ModID's of selected in listbox
strSQL = SELECT tblModuleProcs.ProcID
FROM (tblModules INNER JOIN tblModuleProcs
ON tblModules.ModID = tblModuleProcs.ModID)
INNER JOIN tblProcedures ON tblModuleProcs.ProcID = tblProcedures.ProcID
WHERE (((tblModules.ModID) IN(" & strIN & "))) "
ORDER BY tblProcedures.ProcedureTag;
I have a large database of students and parents which charts their weight, waist circ., lifestyle etc. When I then create reports, is it possible to change the colour of the entry so that I can differentiate between students and parents results? In other words, can I have all student entries in red and all parents in black, for example? At the moment, when I try to change the colour of one of these, the entire column changes to that colour and I don't know how to amend my reports to do this. Please see attached.
View 2 Replies View RelatedI have a table for a multiple parents linked to a child table. I need to figure out a way to only allow 1 parent to be coded as primary, 1 as secondary, and then the rest as other... I thought about making Primary/Secondary/Other a primary key. But then I can only have 1 other. I would have to make a finite number of parents that could be entered and I want an infinite number.... My end goal is to have a report that only has a primary and second parent on it, but the rest of the parents still exist in the table...
*Child_ID
Parent_First_Name
*Primary/Secondary/Other