I wonder if you can help me with this matter.
Every time I click the print out icon on the query the was created I got the
following window message:
“You do not have the necessary permissions to use the ‘___’ object. Have

Hi, I am not sure if I'm being thick or not but I am struggling with this.
I have a table with Product and their costs.
I have another table with Products bought when and who by.
I am trying to bing together in a query a list of how much has been spent on

Hi,  
I'm Running Access 2003 using 2000 mdb format and have a database with
linked tables to 2 Access 2000 mdbs.  Database A has the tables to operate
ME!  Database B is only used to insert records into database A.

how to built calendar in ms access so that when i click it will get the date
and save it...

I have a table silimar to one below but with a lot of extra variables.
Essentially, what I need to calculate is the sum of amount for the recent
three months for each month.
ID    Month    Amount

I'm trying to use this code below I saw on this website. When I paste the
code in the column just to the right of the column that contains the words I
want to replace I get this:
The expression you entered contains invalid sytax.

I have a query where I set the criteria as like [enter name]. So when I
anwser the prompt I can enter As* to get the data I want to see which in the
case is Astro, Hobby, West.  How can I do this so the user can just enter
what they want and the wildcard would be automatically ...

I have set up an Access file which includes over 500 records of employees who
have attended a required training class. They have two chances to pass, and
the information is indicated as follows:
Passed first training. (Y/N)

I have a table of names (lots of names! Too many to write individual queries
for...). I want three random non-repeating numbers between 1 and 7 for each
of these names. Output example:
Name1      3

If I needing Manufacturing Shift data,
in my Query grid, i can use something like..
[Forms]![frmMain]![GoShift]....
...where "GoShift" is an unbound textbox on the Form "frmMain".

I have 308580 records in a particular table. I would like to randomly select
20,000 of them. Is there any way to do this in Access 2003? Help!!!

I have a question if this will work.  We use a FoxPro software for our
payroll.  Current data is stored in table tktimcrd.  Quarterly, to reduce the
size of the active database, we are supposed to archive this, which I have
yet to do since we just got it.  That data is stored in ...

Dear Access Gurus,
Please help. I have a database in which I ask the user to put in a date and
then the query should pull all the dates for a one year previous period.
However, all the dates do not show up even though they are in the table. For

I'm building a new query that uses 2 inputs; a query and a table.  The input
query has 3 fields (a,b,c) that combine to be a unique identifier for each
record.  The input table has the same 3 fields (a,b,c) that make a unique
identifier for each record.

Good day to all,
I've a table with some records of events for subjects and on certain dates,
now I need to get a query that returns me the Subject, Subject creation date,
3 months after creation date, Value at 3 months, 6 months after creation