In a design consult, i have three fields, the first one is result of a group,
and the others are sums from fields of two tables.
Here is the SQL:
SELECT COM_SERV_COM_TOTAIS_1991.Quadra,

In AC2007 how do I print the structure of a table. Specifically
the field names. I searched help and hunted a bit with no success.
James

I have been tasked with converting our Excel Statistics workbook into an
Access database.
Our department (a records department) tracks statisics on each task - how
many records input, how much time per record, total time per task, total time

Hi everyone ! I would appreciate anyone who could guide me to develop this
database.
Let me make it simple and short
Database name    : PE

I am creating a clinical research database and I am having trouble with some
of the design logic.
Each Protocol has a unique Budget.  Each Budget includes all the Visits
required for the study as well as which medical procedures are completed at

I have an older version of access I wrote macros to capitalize first letters
in a field. EX :  25 Lee Street      The command would automatically make the
L and S upper case .  I cannot find how to do this in the newer versions of
Access.  My older command would capitalize all ...

Hi there!  I am hoping someone can help me weed through this mess of
relationships and set up a logical structure.  Hopefully I can lay this
problem out clearly.... I think the answer may lie in creating place holding
"blank" values to help the grouping, but I am looking forward ...

I have a table where client services are recorded.  Many services are linked
to another table which lists checks used to purchase these various services,
such as food vouchers.  With each check, we purchase hundreds of items and
number them to have some control over the inventory ...

I need to collect confidential data at many remote independent sites
(physicians offices) and periodically gather this data centrally.
Using Access as a platform (Runtime?), any suggestions on approach?
e.g. I know that I can create a password protected Excel file from within

I would like to keep my db as "Add New Records" only.  But I need to have the
USER to be able to go back if they don't have the information at the time to
complete the record at a later time. ( EDIT mode).
Is it possible to create an Event that would put everything in EDIT mode ,

I created table with a mix of number, date, and text fields.  The table
contains 172 fields.  I was able to save the table and add records to the
table.
Now I'm trying to change the property of one of the text fields, from a

I want to design a database to record steps to learning a subject
So far, I've got (basically)
TblStudent
StudentID

Does anyone know how I can add an auto number to my existing table that would
start with a number of then 1. For example 50, 51, 52 etc..
Thanks in advance for your help

I created a database containing travel records years ago in a flat file
format.  My new format now has a form that allows the user to select from a
drop down list in order to input information.  Is there a way to transfer
information from the old flat file to my new format?

I need an Access 2003 attendance database.  Do you know where I might find
one?  Thanks!!!