pinkpanther6666
Board Regular
- Joined
- Feb 13, 2008
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
Hi All,
I've got a dsum problem and hoping somebody could help me please
2 Tables set up as below
tblmain
Week,Team,Player,DS,DD
tblFixtures
Week,Team,HDa,AWa
HDa is Home Darts
AWa is Away Darts
frmFixtures
What i need to do is for the Fixtures form textbox called HDa to have a total of [DS] + [DD/2] pulling the data from tblmain based on the values of Week and Team in frmfixtures
Many Thanks in Advance
Steve
I've got a dsum problem and hoping somebody could help me please
2 Tables set up as below
tblmain
Week,Team,Player,DS,DD
tblFixtures
Week,Team,HDa,AWa
HDa is Home Darts
AWa is Away Darts
frmFixtures
What i need to do is for the Fixtures form textbox called HDa to have a total of [DS] + [DD/2] pulling the data from tblmain based on the values of Week and Team in frmfixtures
Many Thanks in Advance
Steve