Query coming up blank

[diggy8]

I've only recently started using Access, so this could be an easy fix that I'm just not seeing:

I need a report to display the number of projects that are Started or Completed in a given time period and also show how many pending projects are currently in one of four status options. I have the user put in a start and end date and using that I use two queries to count how many projects were started or completed in that time. Then I run another four, one for each of the other status options and count how many of each of those there are. These just go through a table, group the status options and count who many of each there are. When I run these queries by themself, it's fine, they give the correct values. But when I put them into a report, Access gives me an error that it can't connect the record sources the fields are from. So I tried making yet another query that would combine all the other queries for use in the report, but that comes up blank.

Does that make any sense? Any suggestions on how I can streamline this and get it to work?

 

[gusbrunston]

Hi Diggy:

Since the querries all work when you open them one after another (right?), why not put them in order into a macro that will open them one after another?

Or do I not understand?

Cheers, Gus Brunston An old PICKer, using Access2000. I manage

http://www.rentdex.com.

Suggestions welcome. padregus@attbi.com

 

[diggy8]

Thanks for the response, Gus! The queries do work when they're run seperatly. But I need the results of those queries in a report. When I put the query's field in the report, it should run the query and return that field, correct? But when I do this, I either get #NAME or nothing at all depending on whether I put an equals sign in front of the control source. In either case, I don't get any error messages.

Thanks!
Jamie

 

[diggy8]

Ah! I fixed it! I didn't have a record source for the report.