HELP...Deadline!!

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I am frantic. Have a deadline looming for Tuesday and my
reports are not professional - and another problem.

Problem 1)
I need to do a Where clause situation in a query - between
two tables. Where field a in Table 1 = field a in Table
2. How do I do this in an existing query?

Problem 2)
I list all of my departments with details, then a
department total. The last department per page shows but
the corresponding department totals end up on the next
page. How do I fix this.

Problem 3)
My page header contains the title of my report, department
name and names of the detail fields (name, hrs, fee) ...
But on the very last page (Grand Total page) the last
department name is shown again. How do I make this appear
blank for the grand total page?

I do have more questions but this would be a huge help!!

Thank you!!!
 
I am frantic. Have a deadline looming for Tuesday and my
reports are not professional - and another problem.

Problem 1)
I need to do a Where clause situation in a query - between
two tables. Where field a in Table 1 = field a in Table
2. How do I do this in an existing query?
Click to expand...

With a SUBQUERY, if indeed that's the right way to do it - which I
rather doubt!

The syntax (for a subquery which returns a single record) would be

WHERE fieldname = (SELECT SomeValue FROM SomeTable WHERE <criteria
that limit the retrieval to one record>)

If you want to retrieve all records that match multiple hits use

WHERE fieldname IN(SELECT SomeValue FROM SomeTable WHERE <criteria>)

Typically this situation is better handled with a JOIN of the two
tables rather than a Subquery, but without further details it's hard
to tell if that would be true in your case.
Problem 2)
I list all of my departments with details, then a
department total. The last department per page shows but
the corresponding department totals end up on the next
page. How do I fix this.
Click to expand...

Where in your Report are the totals?
Problem 3)
My page header contains the title of my report, department
name and names of the detail fields (name, hrs, fee) ...
But on the very last page (Grand Total page) the last
department name is shown again. How do I make this appear
blank for the grand total page?
Click to expand...

Use the section's Format event to blank it out.
 
Back
Top