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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data Type Mismatch in Criteria Expression problem
Leslie, thanks for your continued interest and help. I am at home now and unable to try your latest suggestions but was interested to see if you had replied to the thread. I am going to go into more detail here and give some examples of data and expected results. First some tables with sample...- bournes
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Data Type Mismatch in Criteria Expression problem
Thank you Leslie. I haven't been able to spend a lot of time on it today but when I did I couldn't make your sql work. After working on the punctuation I got an error message indicating a syntax error in the FROM clause of the last join. I didn't have enough time to work that out. I am...- bournes
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Data Type Mismatch in Criteria Expression problem
I've checked the threads and the faqs but haven't been able to get my query to work right. The basic sql is: SELECT DISTINCT T.AcctNum, T.Date, T.Time, T.SiteId, CDbl([Qty]) AS Qty1, tblAccountDiff.EffectiveDate FROM (qryTransactionFieldsForQueriesWithPriceDateAndDiff AS T INNER JOIN tblPrice...- bournes
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Automate Excel2k subtotals from Access2k
Thank you both, that is helpful. Bear- bournes
- Post #4
- Forum: Microsoft: Access Other topics
-
Automate Excel2k subtotals from Access2k
I am exporting to Excel sales information and would like to automate subtotals in the target worksheet. Can anyone advise me how to do this? Thanks, Bear- bournes
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
