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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
math calculation problem
tony, your a god...thanks!- johnmaio
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
math calculation problem
am calling a field in a query and have to include all the records even if some are columns are blank... the problem is when the column is blank i can not do a matematical expession how do i do a math calculation on a blank field...i just want the blank to have the value of zero then if one...- johnmaio
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
simple summary query solution needed
i am totaling the number of tickets sold by date and have used the simple query wizard to give me summmary data...but it keeps asking me to enter parameter value for each field before it gives me the info i want.....how do i make it just open up to the results here is the sql it wrote...any...- johnmaio
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
