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!

multiple query problems

Status
Not open for further replies.
mollow

mollow

MIS
Aug 7, 2001
20
GB
Hi,

Wondering if any of you guys can help me. I am writing a query that takes its data from 4 other queries. Each query works out the direct labour costs using a particular method ( ie one works out the piece rate, one normal rate etc). They run off a prompt box criteria asking for the Job ID.

The problem is that there are occasions when one or more queries have no record of the Job ID and so blank out all the results.

As I am trying to work out a cumulative total for all the queries I'm getting quite frustrated. :p

Anyone any ideas?

Mol
PS, using ms access 97
 
Sort by date Sort by votes


Hi mollow

Check out your join properties. Just right click on the join and the rest is self-explanatory.


Stew
 
Upvote 0 Downvote
Cool

Ta mate, I'll have a play round with it :)

Mol
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
524
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
395
TheresAlwaysAWay
TheresAlwaysAWay
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
303
Swi
Swi
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
364
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
280
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top