I have an output field in my db that lists  [SumOfBALANCE] however, when
performing a later function it turns out that if this field is blank I get a
blank result.  The fields won't sum a # field w/ a blank field.
How do I create an if  [SumOfBALANCE] = "blank", then  ...

I have a table where the "natural" primary key would be a combination of four
fields.  And for a while, we worked with it that way.  Then I became
convinced that a meaningless autonumber primary key would be better, and I
reconfigured the system to work that way.

I have a access data I'm doing a mailing
went into (report) and (labels) put the zipcode
comes out as "123456789" instead of "12345-6789
any idea the (input mask) shows the zip as 12345-6789

I'm building a database to track uniform inventories. I have one table that
shows what was issued and another that has what the employee has on hand. I
want to be able to enter the name of a new employee on one table, but have
that name transfer to the other table automatically. ...

I have the following tables:
1. Equipment: ID, Description, Manufacturer, MachineSerial
2. EquipService: ID, EquipID (lookup), date, Responsible
3. EquipStandardization: ID, EquipID (lookup), date, Responsible

Hi, a student of ours is currently creating a simple DB using Office 2003 SP1
on WinXP. Her classmates are doing very similar DB's which are all around the
2MB mark. This one student however, has a DB of 43MB and rising. She has no
complex images in, and only 5 or 6 in total.

I think I've run myself up a blind alley... hope someone can redirect
me in a more productive direction...
I have an existing system for tracking real estate Acquisitions - an
Acquisition

I am attempting to build a database that will generate a task list for
multiple workstations.  I have tasks that need to be completed either daily,
on a certain day of the week, or mutiple days of the week.  I am unclear how
to associate the task(s) with the appropriate frequency ...

I have a table that links salesman to 12 months of commission he made. when I
run a query for 12 months of the year I realise that there are missing months
for some salesmen. It’s simply because they didn’t make a commission in those
missing months .And therefore those months in ...

I have an instrument that records the amount of oxygen delivered to
individual cells (which I have 24 of). The instrument creates a txt file for
each cell thus there are 24 files for each run (a run can last several
months). A new row of data is appended to the txt file every ...

I don't know how to get to my inbox when i click the place where theres an
envelope it takes me to newsletters not my inbox. I really need to read my
e-mails but i don't know how to.

I'm making a library database for a small non-profit org, and I need help
streamlining the database to be user-friendly.
The books are organized by several things, including "Primary topic" and a
related shelf number. For example, primary topic "Parenting" has numbers

We are doing a presentation on Team Canada Hockey for a class, is there any
way to get a background that relates for powerpoint?

For many years I have been using a ledger based on the Northwind sample
database, and this has the structure:
tblLedgerAccountType.
tblLedgerAccounts.

My problem is I have a report in Access. When I export it to word not all of
the document appears in the final output.
In my report I have fields in the detail section and the group footer
section. I copied and pasted text and a table from word into the page footer