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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Summarizing data into another table
I had no idea that switching the division symbol (/) to (\) made it so that the decimal places were truncated in MS Access. Thanks PHV! By the way, I thought MS Access was in the ANSI SQL family but I guess I was wrong. Sorry about that, but thanks for the help anyway, you've cleared a lot of... -
Summarizing data into another table
Sorry, in the above message that ? at the bottom was supposed to be a Sigma. -
Summarizing data into another table
Thanks guys for the responses. I tried both queries and JarlH, your untested query comes back with an error that I am currently trying to sort out. PHV, this one looks really useful but for some reason my MS Access doesn't like the TRUNCATE function....which is a function I REALLY need. I am... -
Summarizing data into another table
Hi everyone and thank for reading my question, here it is: I have a table as follows stocktrades { symbol Text shares Integer price Double timestamp Long Integer (this is presented in hhmmss format but not using any mask.) } And I wish to...
