Recent content by gray8015

Sorry to be a pain, but... I've looked up DateAdd in the Help menu, but where do I use it? There is no place in the grouping dialog box to change the standard options? I've not done any coding so I'm not sure how/where to "make a function" either! I'm probably over my head with this stuff, but...

I'm a bit new to this... I'm working on a rugby database listing all games played for the last 150 years. I need to be able to group the report on all games played in a season but the season runs from June 1 through May 31. I can't find any way to specify the start date of a group. (I just need...

I'm working on a rugby database listing all games played for the last 150 years. I need to be able to group the report on all games played in a season but the season runs from June 1 through May 31. I can't find any way to specify the start date of a group. (I just need to change January 1 to...

Wow - You're both brilliant! Thanks so much!

Hi, I'll try to explain this briefly... I have a database that tracks rugby games over many seasons. All works well until I try to create a grand total of points for each player. As the values associated with tries, penalties, etc have chnaged over the years, I store the values based on the...

I'll try to get my head around the last post. I'm a bit out of my depth, hopefully tomorrow it will all be a bit clearer. I noticed that the dates that were returning the wrong value are being read as US dates - mm/dd/yyyy. I'm using UK dates - dd/mm/yyyy. When the date is 28/12/1987...

Paul, THANK YOU so much! I've been struggling with this for ages! There are a few games that don't show the correct season (even though the query shows the correct season), but I'll work on that tomorrow. Is there a simple way to get the resulting "season" back into the fixture table? My issue...

Paul, Well I have more than I had, but not quit there yet! I have the following in the control source of "seasonplayed" on my form: =DLookUp("[SeasonPlayed]","tblSeasonsandValues","[DateStart] < " & [Forms]![frmFixtureList]![Date]) & " AND [DateEnd] > '" & [Forms]![frmFixtureList]![Date] & "'"...

I have Item: [Forms]![frmFixtureList]![SeasonPlayed] Expression: [qrySeason]![SeasonPlayed] (both with data type = text) [SeasonPlayed] on my form has a control source which goes back to the table holding all of the data for each game. I thought this would be more efficient because I only...

My apologies up front for being a bit of a novice. I have a rugby database with matches, players, scoring. etc. Based on the date (txtdate) of a game, I would like to retrieve the correct season (txtseason) from a table (tblseason). (tblseason) has (txtstartdate), (txtenddate) and (txtseason)...