I am working on a database that i didn't build,there is so many table and i
want to understand what is/are the unique key for each table,does someone
know a quick way to do it?

Two tables, each with a field called Service_to.  Can't connect them by this
field for various reasons.
I am pulling each customer number from the first table - the customer
numbers are linked.  I need to pull only data from the second table where the

How do I select all the days in the current week from a date field?  I want
to view all the employees hired in the current week using the hire date.  I
do not want to enter the beginning and ending date of the week each time; I
want the query to look at todays date, look at what ...

I've got three queries that work together to combine the results of two
tables.  I've got two queries which sum the values (grouped as required) I
need from two tables.  I then use a final query to pair the values up, using
a join.

I just converted my database from Access 2003 to Access 97. Now when I try to
run my query, it comes back with an error, "undefined function 'MonthName' in
expression". I guess Access 97 does not use "MonthName" function. I need to
rewrite the expression in my query, but Im not sure ...

I want one field in query to return address.  The field looks like this in
query design view.
Address: [Addresses].[StreetNumber]+' '+[Addresses].[Street]+'
'+[Addresses].[Apt]+' '+[Addresses].[POBox]+' '+[Addresses].[City]+'

I have a database with a couple of table. The main table I am working with
(named PR) has one field for the project manager's id number ("projmgr") and
one field for the project supervisor's id number ("supervisor").
The name of the project manager and supervisor are in a second ...

I am having a problem in querying what records have null value in a table. I
know there are 80 Null out of 100 rec.
In a query I say, Where Name is Null, I get 60 null rec. If I try Where Name
is "", I get 70 rec.

Hello wise ones,
I have a table with fields
Student_Name
Age

I have two users confiming one operation on my database and i need to
track the user by defaulting to the current user() i.e. logged on user.
Now setting the default value to Current User() only works if its a new
record, but i want it to work when editing as some of the data would

Please help me with syntax of this nested IIf Statement. I am trying to
track Internal Requisitions Status and report on it at any given time
as the requisition goes through various stages, i.e. raised, approved,
ordered and finally delivered, and can also be cancelled. The values ...

I would appreciate if you help me out on this case here. I am having problem
in calculating 30 days calculation here. An employe is entitled to take one
sick day each 30 days. For example by today he rates 11 sick days starting
the day he is hired by the company. The hired date ...

My client has a “split” architecture Access database – the back end on a
server and the front end on users desktops. All was well until the client
changed to Windows server 2003, from 2000.
Since that change, the ADOX.catalog object takes so long to “load” that it

I'm using someone else's database & I don't have access to make changes to
the records that were returned from our last mailing. The only way around it
that I can think of is to to exclude the records/contacts from the query that
I can revise. How do I do this? Or is there a ...

i have one table with lastname, first name, (10) date fields with a service
and price field connected to each date.
i'm trying to create a weekly sales report so i need a query that will look
at each date field in the table and return the results for the user specified