Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DSUM worked in Access2000, when upsized to SQL 7.0, it fails
Curently using MS Access 2000. My expertise is using MySQL and Web pages on a Roxen Web Server. So Access, while sometimes very easy, and a good proving ground for figuring out SQL statements, is still rather foreign.- wspivak
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
DSUM worked in Access2000, when upsized to SQL 7.0, it fails
Actually tried that, w/o success. Went and created a view, and put the subform into my major form. Same idea, not exactly what I wanted, but it works...- wspivak
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
DSUM worked in Access2000, when upsized to SQL 7.0, it fails
I created an Access2000 database with a DSum in a form: =DSum(" [Commission] + [Metal]+[Diamonds]+[Setting]+[Labor]+[Misc]","Calls","[Calls]![ContactID] =[Contacts].[ContactID]") Worked/Works perfectly. I then upsized my Access program to SQL. Among the small...- wspivak
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
