Hi,
I have read through the posts here and go through articles from MS, but
their solutions/workaround seems not satisfying.
Workarounds they suggested:

Hello, I am having a tough time relearning Access :)  Anyway, I would
appreciate any help that I could get with the following problem.  I have read
through the pass-through posts on this forum and confirmed what I suspected
in that a pass-through query cannot reference tables in ...

Every week, I import a spreadsheet of new transactions into a specific
table.
I click tables / select import table / find the spreadsheet / select the
table for importing into and do it.

I have a table that contains the following columns: ID Record, Phone Number,
Fax Number
Some of the Phone Number as well as Fax Number fields are blank.  I'm trying
to update any blank field in both the Phone Number Column and the Fax Number

Hi
I want to be able to create a report which shows whether a pupil passed their
driving test or not, which I have managed to do (by grouping by Customer_ID).
I then want the report to show on what attempt they passed their test, which

I hoping somebody can tell me how to do this or that it is not possible
in Access.
I have  table (tblIssues) which references two tables, one of clients
(tblclients) and the other a reference to Projects (tblProejcts).

Hi there, I have a table with the following fields:
TripID
LegNumber
LegTown

This is an updated message.  I accidentally sent the original one by mistake
before finishing it.  Sorry about that.
I have a database of customers that I call and want to add a "Call
Again?" field to.  I would rather use a text field instead of a yes/no, but

I have several tables that are linked with a common field, but one particular
table needs formatting to make a relationship possible.eg
table order number shows as AD123.1 (table1)the other table AD1230000( table
2).  I am looking for an expression to truncate both tables to have ...

Since I'm just a novice, I need some help with this.
In a query, I need to have a category on each article.
The Category is based on the size and code of the article.
I have

I need to know how to build an expression or use a date/time function in a
query to show records with a date that is more than 30 days old.

Using MS Access 2003, I want to create a query from two fields. When my
quantity on hand field becomes less than my reorder level field, I want
"Order Now to appear.  What is the proper way to write this ? I was inputting
the information in expression builder as [Product ...

I have a list of employees and several classes that they need to become
recertified for yearly... In the fields I have the due date for their
recerts. Some are due now, some maybe two months ago, and maybe some 9 months
from now. I would like to do a query so that only those ...

Simple but I can't get it:
if [fielda]is null or equal to zero, then [fieldb], otherwise [fielda]

Hey all,
Let me try to explain this. I am creating a query to take the sum of
transactions for a certain ID# in one table and subtract them from the
original fund amount. The problem is, some funds have no transactions giving