I have created a database which tracks inventory and calculates and monitors  
turnover.  In my query I have 4 columns that are put in by the user in a form
linked to a "Transactions" table:  Issues, Receipts, ProeprtyNumber and
TransactionDate.    I created a field (InvLvl) which ...

I need to calculate a log of a number in Access,
easy enough in excel but I'm getting a different answer in access,
my [tvc] number is 60
in excel the log is showing as 1.778* =log(60)

Bonjour,
Il m'arrive un truc très bizarre.  
J'ai une requête que j'utilise depuis bien longtemps maintenant, mais pas
régulièrement.

We are converting several databases from 97 to 2003 and mail merge stops
working after the conversion. I does not see the parameter queries that have
been previously written to merge with.  Also I will not let you write new
parameter queries in access 2003. I simply does not ...

Here is an error I've received in Access 2002:
Reserved error (-7748); there is no message for this error.
Any ideas?

I am converting a Access 2k project and going from a LAN using a total access
2k solution to a offsite SQL backend with my Access 2K as a front end.
I posted a few days earlier and John suggested that I add a field of
TIMEStamp to my sql table.  I did this and it seems to have ...

I moved the backend to a SQL server and now this is not updatable from my
Access 2K front end.
Can this be made updatable?
SELECT dbo_tblOrders.[POD Sent], dbo_tblCustomers.Company,

I have been using a pass-through query to populate a report based on a table
from a database external to Access. This works fine, however now the
requirements have altered slightly and the results of the query need to be
written into an Access table and I have no idea how to ...

Hi, was wondering if someone could take a look at my SQL statement and tell
me why my query isn't working.  I thought this query would be straight
forward, but it doesn't work.  What I'm trying to do is run the query so that
the invoices from Bourne Hall Clinic, NewCampe Medical LTD ...

I have clients that want to view patient diagnosis' like this
Patient              Diagnosis1, Diagnosis2, Diagnosis3  (upto10)
Is there a way to construct this in a query?
my tables are:

I have normalised my database and some of the fields are now linked to lookup
tables via ID numbers. My problem is this .... when I want to run a select
query the select  parameter must now be the ID number rather than the data in
the field. This would be very difficult for the ...

I have worked out the query to return the Latest Appointment per client, but
i would like it to also return those records that dont have a date recorded
yet.  Im just not sure how or were to use the Is Null funtion.
Code is:

Suddenly I have no fields listed when I try to use the Access Query wizard.  
At the same time I am unable to export reports to .rtf documents.  I presume
that these are linked - any ideas why and how to fix it?

Is there any general guildlines for preventing getting this message, granting
that I do have a very complex query?
I have a half dozen or so  queries in a series (one dependent on the
previous and so on) - My only  cwork around I have have now is having to copy

Can I do this?
FROM         dbo_testInformation INNER JOIN
                     dbo_testAdministered ON dbo.testInformation.Test_ID =
dbo_testAdministered.Test_ID INNER JOIN