I need to share my database on the company network with initially about
6(ish) people and
I have already set-up workgroups and permissions (on my pc). What is
the best / easiest way to let them access the database? Can I just copy

Any suggestions why I am getting the #error with this
Margin: Nz([gp],0)/Nz([discount1],0)/100
This happens if the field discount has a value of 0

I have the following running total working in a query, only problem is I
need it to total only the group from the Control field selection.
RunTotal: Format(DSum("Minutes","subtable","[Control]<=" & [ContAlias] & "
"),"0000.0",0)

Hi I've been banging my head with this for some time.
I'm converting Joe Celko's nested sets into Access, and I have it
working, but it's so inelegant, I'm convinced there's got to be a
better solution.  Basically a nested set is a hierarchical

I am a very new user.  I want to code the values of a new variable based on
the values of an old variable.  For example 1 and 2 in old variable become A
in new variable; 3 becomes B in the same new variable; and the value 4 and 5
in the old variable becomes C in the new variable. ...

I'm creating an accounting database.  
I'm running into trouble when I calculate  totals such as the amount I owe
on several bills.
The system stores data to several decimal places and calculates totals based

I have the following running total in a query works fine but I need the
Running total to work on the selected Data. When I enter the Control critera
I get the running total of the whole table. I need it to give me a running
total for only the selected records.

I have a table that is grouped by postal codes first 3 digits, and I
need to know how many customers are in each catagory of postal codes. I
could use count but there are multiple invoices for single customers,
and if I just use count it will count those multiple invoices as two

I have one table for vendors, one for customers and one for countries among
others. The two first have a field "countryNo" and the forms have references
to the country table via combo boxes for registering the addresses. It works
as intended for both tables.

I'm trying to create an SQL Statement in code:
So far I have the following:
SELECT A.MASTER_PROJECT_ID, B.SITE
FROM [MASTER_TABLE] AS A, INNER JOIN [CONSTRUCTION_TABLE] AS B

THANKS TO MICHEL WALSH & JOHN VINSON i think i'm a step closer.
but i still need help trying to count consecutive records >=1, restarting
count at o when there is a record <1.
i renamed my "bal" field to "field"

I don't know if this is a query problem or a report problem but here
it is.
I have 4 tables (invheader, equipcharge, laborcharge, payments) they
are all related to the invheader through the invoice number.

How to create two parametre in one query. l hope it will  help users to get  
data for a month or for a year
Thanks in advance

I am looking for a function.
it's like IF() in MySQL.
suppose a table,
[sample_table]

I have a table with pay periods as a field.  I can sort these records by pay
period.  Is there any way to evaluate the next record, in order to create a
field in a query which tells me whether the gap between pay periods is 1 week
or 2 weeks (through evaluating the next record)?