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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expression correct in one query/Incorrect in next

Status
Not open for further replies.
Neenas19

Neenas19

Technical User
Apr 10, 2002
22
US
Hello,
I have attempted to find some previous thread on this, but was unsuccessful. My problem is that I am calculating a percentage in one query
X time/Y time = z% Field name = gobbly%

When I attempt to pull "gobbly%" into another query the expression does not calculate.

When I attempt to do a make table qry, the expression does not calculate?

I have claused out all the nulls and zeros, so I don't think that should be the problem. Any ideas?
Thanks for any help!!
Nina
 
Sort by date Sort by votes
Please show the query and what type of connection you are using - DAO or ADO.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
478
combo
combo
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
141
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Use two sorts in query 1
Replies
7
Views
134
TrekBiker
TrekBiker
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
390
TheresAlwaysAWay
TheresAlwaysAWay
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
274
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top