Assuming you have the table structure indicated. A query like the following will show you everyone that played on a specific date. SELECT Players.* FROM Players Inner Join GamePlayers ON Players.PKID = GamePlayers.PlayerID WHERE GamePlayers.GameDate = #2007-12-22# In the design view (query grid) -- Add both tables -- Drag the PKID field to the PlayerID field to set up the join -- Select
hi John you are on the right track to solve my query but!! when and where do i fill in the dates. so far i have created a table players ID pk primary key full name text tag No unique No for each player a second table game players game date date/time player id number(not auto no pk) full name text tag No number i have created a unique index between
Bill, I noticed that the code I had originally suggested for parsing your data failed to capture the playoffs and superbowl. That is corrected in the code shown below. Also shown is a slight revision of the code that Mary suggested, combined with some extra code for capturing overall streaks, home streaks, and visitor streaks, as well as Mike's suggested code. Both results from both sets
Bill, I'm still not sure that I understand what you are looking for. See if you can use the following to do the desired calculations: data want (keep=week Game_Date team opponent at w_l); retain week Game_Date; format Game_Date date9.; length team opponent $3; infile cards truncover; input dataline $80.; if scan(dataline,1,' ') eq 'Week' then week=input(scan(dataline
Bill, If your data are space dilimited, and include the irrelevant headers as shown in your example, then something like the following might work: data have (keep=week GameDate Team SU); retain hold_dataline week GameDate record_number; infile cards truncover; informat dataline $80.; informat hold_dataline $80.; informat Team $50.; informat week 2.; informat SU $1.; informat
