I've created a crosstab query to summarize the results of a poll. The user
wants to know the total number of respondants. The method the poll software
uses to identify a unique respondant is "respondentID". I have 11,000 records
in the results table, but only 1000 (or so) ...

What's the character code for the return key?   The syntax is Chr(     ).
Thanks.

Hi, very new to VB with Access, trying to run a simple
report that will list all projects in my dbf of 347.
Copied my report from another report that checks for the
project status.  Renamed my new report and removed the

I'm sending the contents of a form to Microsoft Word as a merge file. The
code for this procedure is from http://support.microsoft.com/?kbid=210271 It
works great except for removing the bookmarks which gives me an error.
The line that hangs is as follows

Trying to input the minimum value from  2 calculated text boxes, CPU and CPL,
into the CPK text box.
All three text boxes are in the report footer.  The CPU and CPL text boxes
are calculated from values from the report detail.

I use the Stephen Lebans A2KReportSpecs.mde
to export to Word a graphic Access report.
In Nederland, it works very well.
But in France, treatment is excuted,

I am getting an error in doing this
I have a text box in a Sub Report and I am trying to get its value to a text
box on the Main Report
=[Reports]![Report2]![txtOutdate]

I have a report:
Description           Profit
LMOBG0825             $300
and a subreport:

Can we add subreports and reports totals together...I
posted a previous request and I have looked through
previous postings and I cannot find anything thta can
help me...I would like to know if ti can be done and

Are there Access controls or add-ons to display appoinments (date, start
time, stop time) in a calendar view?
Best,
Christopher

Hi, there.
I recently created a DB in Access to store some member info but instead
of having the reports in Access, we want to create the reports from the
DB directly into Excel Format. Is there a way to do this? I know there

On my report i did a conditional format on 1 field
like: Field Value = equal to "F" textcolor RED
This works, however not all fields which have an F are shown in red some
have some not??

Hi. I posted this a few days ago and Newbie initially
replied but has now gone quiet. Can anyone else help
please?
I want to control the visability of a reports

I have a report grouped by type of task. Now it shows first all task1 then
task 2 Is it possible to show it by task1 task2, task1 task2 etc.?
example:
task1

  I have got 15 columns in a report, because of this report is going into 2
pages. My requirement is that all the column should appear in one page, and
if the column doesnot fit into one page then it scroll should appear instead
of report appearing in 2 pages.