Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-26 : 07:56:08
|
| Shachaf writes "I have a list in which I'd like each ID to appear either 0 or 1 times, when a certain date is selected.Meaning - I can't assign the same guy for 2 shifts in one date.What I try to do is run this SQ statement (created by Acces automation):SELECT Supporters.SupporterID, Supporters.SupporterName, Supporters.SupporterIsActiveFROM SupportersWHERE (((Supporters.SupporterID) not in (select supporterID from Shifts where shiftdate = Forms![ShiftsDay]![Date1] )) AND ((Supporters.SupporterIsActive)=True));But now each time I update a certain guy in a certain date, his name is removed from the list - it does not show where I updated it (which is a bad thing) nor in the list to pick the guys from (which is a good thing).I hope you got my question right - any suggestions?" |
|
|
|
|
|
SQL in access - Dynamic list of a kind