Report and Quires

[phimz196]

I have three quires that are unrealted but i want to add all of the information in them to one report. Can i do this? How?

 

[Norie]

I have three quires that are unrealted but i want to add all of the information in them to one report

Why?

Are they really totally unrelated? No common fields at all?

 

[phimz196]

They are counts(*) of certain values..

 

[Norie]

Well rather than using queries in your report take a look at the DCOUNT function.

 

[phimz196]

DCount tells me to use it in a query. How is this any different?

 

[Norie]

What I mean is to have an unbound report ie not based on a query.

Then have textboxes that display the values returned by DCOUNT(s).

 

[phimz196]

This is my SQL. How do i wright this in DCount?



SELECT Count(*) AS ABMWendy
FROM Expediting
WHERE (((Expediting.CompanyName)="ABM Commerical") AND ((Expediting.Requested)="OEM Print:B - Wendy Wright") AND ((Expediting.DateSubmitted) Between [Forms]![Expediting Report Range]![Text6] And [forms]![Expediting Report Range]![Text10]));

 

[Norie]

Try something like this:

DCOUNT("*", "Expediting", "(((Expediting.CompanyName)="ABM Commerical") AND ((Expediting.Requested)="OEM Print:B - Wendy Wright") AND ((Expediting.DateSubmitted) Between [Forms]![Expediting Report Range]![Text6] And [forms]![Expediting Report Range]![Text10]))")

I think you'll have to have this form open - Expediting Report Range.

Are the other queries the same? What table/query are they based on?

 

[phimz196]

The other queies are the same. I know that i will need to have Expediting Report Range form Open. It is based on the Expediting table.

 

[Norie]

The other queies are the same

I have three quires that are unrealted

I'm confused.