How To Include Multiple Queries Into One Report

[newuserthatneedsassistanc]

Name: Ca57858pture.jpg  Views: 26  Size: 224.0 KB  ID: 29560" class="thumbnail" style="float:CONFIG" />

See the TRANSTYPE (Transaction type) field? If I do Criteria: "L" or "P" or "X" for TRANSTYPE it outputs redundancies. And see on the bottom left it says 150 records? That's around how many project numbers we actually have.

If I limit a TRANSTYPE criteria to lets say "L", I get the correct information but I can't see the project records from the "P" or "X" TRANSTYPES, there's only 30 records showing up out of 150.







So what I did was I created 3 separate queries with the same information for all the other fields with each TRANSTYPE criteria, I'm trying to make this into a report that populates all of our project NUMBERS but shows "L" as well so we can keep track of Labor.

[RuralGuy]

Why can't you use the 1st query and just sort and group on TRANSTYPE? Sorting and grouping is a function of the report and not the query.

[newuserthatneedsassistanc]

How do you sort by Transtype in a Report?

[RuralGuy]

Maybe this will help at ~1:15
https://www.youtube.com/watch?v=3301mfErbIc

[newuserthatneedsassistanc]

Well this Query is still giving redundancies

[RuralGuy]

So you got the sorting and grouping to work right? I don't remember you mentioning redundancies before. That can easily be caused by a Join.

[newuserthatneedsassistanc]

Theres supposed to be 82 projects, Non-redundant.

Shown here

[newuserthatneedsassistanc]

Refering to the first image in post 1

[newuserthatneedsassistanc]

It shows 150 but its redundant

It's supposed to be 82, non-redundant

[RuralGuy]

Based on your 1st post pictures:

TRANSTYPE "X" = 52
TRANSTYPE "P" = 68
TRANSTYPE "L" = 30

That totals 150 so I'm a bit confused here.

[newuserthatneedsassistanc]

We want to be able to see every single one of the projects that has a status of a-h (82)

But whats happening is that it's only pulling those with a QTY entered into them. It's excluding the ones without a QTY

[davegri]

Don't understand the problem. First query shows all records with transtype = L, P, or X. That's exactly what your criteria specifies. What do you mean by redundancies?

[davegri]

Well, gee. First you say too many records, then not enough, excluding QTY. Then you bring up STATUS, which wasn't mentioned earlier either.
Maybe you need to start over, explaining WHAT you want the query to display, and what fields you have in the query.

[orange]

Another thing you should be aware of is

Reports have their own Sorting and Grouping features. These may/could overwrite your query options.

As davegri has suggested, it might be time to clearly describe what you are trying to do in plain English. You aren't the first person to jump into Access trying to get Access to produce the report you need. But Access won't do anything you didn't tell it, so you need to describe the what before you jump to how it could be done.

[RuralGuy]

@Orange: AFAIK the Report Grouping and Sorting *always* override those parameters in the query. Just my $0.02