I'm trying to create a scatter plot with Access 2003.  I have a table
whose primary key field contains numbers representing timesteps. There
are three other fields that contain data corresponding to each
timestep. I want a scatter plot with time on the horizontal axis and

I have a query, LocationQuery2:
SELECT Count(GeneralTable.LocDesc) AS totalRatings, LocationQuery.LocDesc
FROM LocationQuery
GROUP BY LocationQuery.LocDesc;

I'm having a problem as follows:-
My table holds a supplier name, date and some check boxes for the state of
each delivery that turns up.
I want to produce a graph that shows by supplier/date range the percentage

I need to add a field to a report that will identify the person that printed
the report.  What I would like to do is add a field that will display the
Windows login id or computer name or something related to the computer or
person printing the report.  Any help would be greatly ...

I have three text boxes on my report, which I would like to 'join'
together, for example...
text box 1 = "abc",
text box 2 = "def",

I have a report header where I want to show the company name.  If I use the &
it treats it as an operator and will not print it.

I have a form for data entry and I want to add a command button that will
print a one of 2 reports for the current record. What determines the report
is the value in the field FrameQty. If the value is 6 then I want to print
Traveler6, if the value is 4 then I want to print ...

How do I employ multiple Where conditions.
Example
strWhereCountry = "Country = Forms![frmRptMenu]!cmb_Country"
strWhereRegion = "Region = Forms![frmRptMenu]!cmb_Region"

I am attempting to create multiple conditions when opening an access report
but with conditions based on different fields:
This is my existing code but I keep receiving an error; I believe it
pertains to incorrect syntax:

Help!!
I have a system with multiple forms that have buttons that produce reports.
Well i did have, until the buttons stopped producing the reports!
Access will now not even let me create a new report from scratch!

I have a query that displays a course ID and a calculated field
TotalTime:[endtime]-[starttime]
When I create a report based on this query, I can get all of the detail
information correctly, but it does not total the TotalTime column correctly.

I have a report based on several subreports. However I need to sort by
Ascending on my date field and my User field. I have tried it in my query and
sorting/grouping etc and nothing seems to work. Am I missing something. Any
help would be appreciated.

I have a report with a group header on the Create Date field of the table. In
the table some records have duplicate order numbers. How would I be able to
count unique order numbers by Create Date?
Thanks, in advance, for any help.

I am using MS-Access 2003.
I need to print a report every Tuesday, at 0900.
Can someone point me to some examples or samples???
Thank you,

I need some help if anyone has any ideas. I have a preprinted form that I am
trying to generate a report to put the data into when printing. The form is
laid out like this.  
1 include margin at top and bottom. Leaving 9 inches in the middle. The data