I've managed to put the grid on screen but it just prints out a blank page
can anyone help me out please?

is there an easy way to get the first day of current month - also need to  
then subtract 3 months from that?
thanks!

My query is pulling records from a master table of my companies clients
(other companies).
But there can be many records for 1 client( a company) based on their
location. what approach could I use to only get 1 record for the comany. here

I currently run a database on a Novell network.  I need to see the current
users that are in my database.  All have login Id's into the database.  Can I
view in Access or do I need to view in Novel?

Dear Access gurus,
I was using since years Access 97, now under XP SP2, without any problem.
However I've just reformatted my HD (viruses...), reinstalled XP SP2, and
then I am no longer able to install Access 97 :

I have Access 2000 and my records are all by individual day date.  I want to
be able to run a pivot table and chart that shows monthly totals but can't
seem to figure out how to write the expression in the query to make this work.
I tried

How do you get AutoNumber to reset itself once you delete a record?  Say that
I have a series of records in a table:
1, 2, 3, 4, 5…
But I then delete record #5 from the table, and later add a new record to

In Access 2003, I am getting an error message: "Invalid Field definition
'RecordID' in definition index or relationship."
This is where 'RecordID' is the name of a key field that links two tables
using AutoNumber.  I have looked at both tables, using Design View.  I have

How can I pass a parameter to a query via code and not user input?
Thaks for all your responses in advance.

Is there a straightforward way to determine which control in a form has the
focus?

I'm doing a basic Access module at college.  I have to create tables and
queries with decimal places.
When I get home and try to set them up on my own computer, I think I've done
it (using the information in Office Assistant), by selecting the field,

How, after entering a new record, can I hold focus on it after indexing.

Having used Paradox 9 for years, can I import my report designs into Access?  
I've transferred all the data.

I have set up a database to perform our scheduling. I have been able to
create an automatic report that throws up all of our units every 6 and 12
months, however want to be able to create a check box or something of that
ilk to indicate when the schedule has been done. How am I ...

I'm trying to open a database at work that I've copied onto a floppy from my
home computer and am getting this error:
'C:\path\etc' is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file