I'm looking for the possibillity to use the content of a field to create a
query.
What do I mean?
I created a table with a key field an a field called "Formula".

I need to run a query that would pull the same month from different years.
For example, I would need all April information from the the dates I have
entered into a particular field.

I am using access 2002. I have a table that lists a patients age, name and
the dates a number of vaccines were given like
Name
Birthdate

I have a column called Date which is used to store the date when receipt is
created on our system, till today ive been inserting the value using the
now() function but i found that when i try to filter for receipts based on a
date no results are returned, this is due to now() ...

Lets say I have an Access database named Database001.
I have a table called Table001.
In the table I have the following fields:
1: Date\Time (an automated date\time stamp when an entry is added)

I have Office 97 Pro running on Windows 2000 Pro Service Pack 4.
All office applications open except access. Error message you do not have
enough licences on this machine. Its a standalone machine and office 97 pro
is fully licenced.

How can i connect other database to Access (2000 and 2003) without using
codeOr do i have to write code every time  i try  it?
do i have to installa something?
i tried to call a database from Excel and it worked very fine, i even

Here's my dilema....
I am trying to set up a database that will allow different sites to enter
operational data.  Some sample fields in the table:
Inbound receipts

Is there a way to run a saved query like we can run a macro
(docmd.runmacro)from within a VB sub?
Thanks

I've got a problem editing data from a query.  I've got a form with two
combo boxes both linked to different tables.  When the user selects the
values (they can also be both left blank) they click search and this
then brings up a form (which is linked with the query) - basically ...

I am using               Random: Rnd(IsNull(PowerTabDirectory.Item)*0+1)
to pull random records, how do I only pull X number of records?
If I want 5 records - pull 5 random records.
If next time I run the query I want 3 random records - pull 3 random records

whats wrong with this query
select min(dateserial (2006,1,1), (select min([Date])  from dbase ))
The inner Minimum function works fine
(select min([Date])  from dbase )

I have a tabe which records donations but I want to create a summary of
donations received by donor (DonorID) and by DonationYear totalling the
AmountReceived.
How do i do this - query/form ?

I set up a table in Access showing "city, client number, name and balance".
Now I am trying to set up a query that will allow the users to enter the city
they want and then the selected data for that specific city will appear. In
the help box it said to go to Design view and in ...

This may sound simple to you all, but it has me stymied.  I need to give
people the ability to search a query for somthing starting with say q*.  I
can do it in my underlying query, but they are looking at reports so if they
put in q* in my parameter pop up when they run the ...