Search results for query: *

To make things clearer, I mean that if the data is on an Excel sheet it has headers across the top signifying "grand total in the country, total in each organisation below that, and total at each site below that", and also has row titles for the various groups of people.

OK, its Friday pm and I've probably fried my brain which why I can't see how to do this: Creating a new table in an existing DB to hold data on different groups of people's training profiles. I've got upwards of 15 different groups and they need to be split further down by trained < 5 yrs...

Its 4pm on Friday afternoon.... my Caring Quotient is dropping by the second ;-) Thanks anyway evilmouse :-)

One requery macro later and all is good. Thanks for all your help.

I'm guessing that I need to requery the form....??

Thanks again Dan, but with this bit thats why I'm confused. Report is based upon query that asks for JobTitle & LetterName, plus includes address details set up as fields in query whcih are also named in report. Parameters are displayed in form, yes. Form is open, yes. Criteria in my query...

I'm still having a problem. The report preview is now loading up fine upon clicking the preview button but no data appears to be being passed to the query and thus the fields that should be filled in are blank. Code behind the preview button is, as suggested: Private Sub PreviewReport_Click()...

Thanks Dan. That seems to have done the trick. Now to sort the problem with my underlying query. THe road goes ever on.... :)

Is there a problem with section of the code DoCmd.OpenForm strDocName, , , , , acDialog which seems to *require* that the form be closed before the code will continue?

&quot;I'm wildly curious what the blnopening datamember accomplishes..&quot; Heh, spot the rookie. And by that I mean me. OK, I'm trying your advice but so far no joy. I'm hgetting unknown macro errors. Is there a particular point of insertion for forms!form1.visible = false ?

Hi all First post so be gentle :) I've currently got a temp job building an Access DB for client to include details of various contacts, site names etc. This will be used to craete batch letters, send out reports and the like. I'm unfortunately stuck at the batch letters. I've built a query...