I am not sure is this is possible since i am fairly new to this. I have a
linked table to an xl table and i was to do couple of things with it.
--One is that i have another table that i compare it to and get the unmatch
records...it's there a way to do this without going through ...

I have been searching for the help of adding a date to a table which is made
from Make Table Query.  I have got the idea of adding a current date on a
form, table automatically; but I can't find the answer to solve my problem.
I have a table of data from download through our Main ...

L.S,
I have a front-end application (MS Access 2000) that uses data from both MS
Access tables and MS SQL Server tables. The SQL tables are linked to the
front-end application via ODBC. I am trying to perform a query using the

Tp pull a monthly report  I have under criteria of Query: "Between
[BeginningDate] And [EndingDate]".  When Prompted I can enter Beginning, then
End Date.  I would like to also include an option where I can leave the
beginning date blank and End date blank to pull all records.  I ...

I have created a crosstab query with the date field as a column heading which
is to sort the date in ascending order from left to right.  It is sorting the
date by the day instead of by the month, then day. e.g. the following dates
were sorted in this order - 05-Apr-06, 09-Jan-06 ...

I have a form that is bound to a table.  I have disabled the record select
and navigation to keep users from going to other records.  However, if I tab
through it, it will move to the next record once I tab out of the last field.
How do I stop it form doing this?

I'd like to be able to round times to the neares hour, where
any value within 13 minutes before, and 13 minutes after,
[TimeFieldValue] would return the hour between those two
extremes.  For example 09:55 would return 10:00.

I have a table that stores different percentages for different people.  The
percentages are stored as numbers so 96% is stored as 96 and so forth.  I'm
trying to create a query that lists all people and the # of times each person
had a percentage less than 95.  I created a totals ...

I have a small table with one field with names, and two other fields (this
comes from a spreadsheet) containing info that SHOULD match. If the two
fields do not match, we need to know. It's not an unmatched query, but rather
filtering out those records where the two fields do ...

I have a form with two subforms on a tabbed control, each tab containing one
of the subforms. My link fields work on the second subform but not on the
first subform. Both subforms have their Link Master Fields set to the parent
form's ID field and their Link Child Fields set to ...

I'm trying to create a query for a report that will show total counts of
inspections and reinspections. I have two tables, Inspections and
Reinspections. For every inspection there may be one or more reinspections.
The tables are ofcourse linked one to many. Each inspection has a ...

Is there a way with a query to calculate a depreciation schedule? I
have an assetID, DateAcquired, PurchasePrice and LifeSpan. I need to
list month end dates (monthly) along with the depreciation amount. I
would like this to display in a subform as a datasheet. It would have

I am working on a small database that is used for tracking donations.
I have two tables, one with donators ( name, address etc)  and one with
donations ( amount, date).
I wish to compare the current month with the same month last year ( that is

I have a form that user enter their info except for an Aisle field (they
don't know where) and then 1 other user needs to go and find all the records
that don't have the Aisle field complete and she will enter that information.
How can I do a query that will only show records ...

Everybody is GOD of himself...because you r responsible for your
career movement....If it is going in wrong way...you have to guide
your self towards right track. If you can't do it, then let the world
impose each and everything on your head...and that too on their wish.