Search results

Namliam, Take your point re Threads! And a Big Thank You as your advise has solved by problem. Don't suppose you could have a quick shifty at my 'Query to select a record with highest value' thread as I am getting nowhere with it. Dave

With help from others on this board (thanks!) I have created a combo (1) whose RowSource is based on a query that uses the contents of another combo (2). It works when you open the form (combo 2 has a default value), but does not work if another combo 2 value is selected by the User. It...

OK, getting there. The above selects the Max by Group. The end result I am trying to get to is a Query By Form where a check box on my form (cbLatestIssues) will cause the latest issue for each title to be shown. If Check Box ticked: Title1.......... 003 Title2...........002 If Check Box...

Using DMax("table","Issue") selects the highest value ie: Title1.......... 003 But I want: Title1.......... 003 Title2...........002 I guess I need some sort of criteria, but I can't figure it out. Dave

Hi, I have a table with identical groups of records except for the IssueNo. Issue number increments for each instance of the record: TitleID.........Issue Title1...........001 Title1...........002 Title1...........003 Title2...........001 Title2...........002 How can I select...

Look at the example dB in this Thread. It helped me a lot and I believe this is what you are looking for (query by form). David aaahttp://www.access-programmers.co.uk/forums/showthread.php?t=78326

jal, Thanks for that...I have just read up all about join and it has solved my problem. Cheers

I have a cbo query for the row source that selects once of each instance of ProjectID in the table tbRFIs: SELECT DISTINCT tbRFIs.ProjectID FROM tbRFIs I would like it to select once of each instance of the ProjectNo in the cbo. The relationship of ProjectID to ProjectNo is in another table...

Namliam, thanks, I really did not think/know that I had to add the table twice. It is now is working. Thanks

This is was my first approach. So I had an Application table: ApplicationID........ApproverID..........ReviewerID And a Person table: PersonID......Name And created two relationships: ApproverID-PersonID and ReviwerID-PersonID But not matter what I do, I cannot create a query that...

Access Query I have a table of Applications (ApplicationID) and each application has to be reviewed and approved. I have a table of people in my organization (PeopleID) and I have a table of roles: RoleID, ApplicationID, PeopleID. For one Application, Role table has two rows: Role...