Do not us Count but Sum like this -- =Abs(Sum()) =Abs(Sum()) A 'Yes' is stored as a -1 (minus one) and the Abs function removes the negative sign. ...

Toying with getting a cost system out of spreadsheets and into access. Most the tables are simple and easy to set up, but I'm debating our material blends...

I'm not even sure how to explain this. I have a membership database in which I've created a form for the member's basic data-name, address, phone, etc....

Dear all, As a relative newbie to the art/science of database design, I was wondering if there was any consensus view on whether it's better to use an...

I created a db and in reading now about db structure, I've seen a lot of mention of relationships. My db started out very simple with the tables that I used...

At present I have a membership database with all members held in one table. I have been asked to split this table into two tables - family and individual...

I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering...

I am trying to create a Multivalued Lookup Field. I am using the Lookup Wizard, but when I get to the place where is should let me choose to store multiple...

I am trying to populate a text box on a bound subdatasheet with the most appropriate value for the user to see.. Based on wether the component has a value...

While working on a form design, all of a sudden if I use FORM OPEN I only see the header. FORM DESIGN shows the entire form. How do I fix this?

Help please, I tried to set up an Toner tracking DB, I have five tables so far 1. MakeID, Make 2. ModelID, MakeID, Model (to generate the Model based on...

I have this code on my database that show certain records based on a training modules completed selected by the user from a drop down list. SELECT...

I have a file at work that the boss uses and now has given to me. Only problem is the person who designed the access file to run from the bosses desk top. When...

I was trying to update field size in table design. I get a message saying 'You can't change the data type or field, it is part of one or more relationships....

Hi, This is just for my own education and curiosity. Does anyone know if Access stores it's data records in a fixed length or variable length records /...

These questions are regarding general situations for consolidating data into an Access database. Some data is contained in a database that has been created...

I am creating/editing updating fields in table design. I am trying to change the field size of the first field. But getting message.. 'You can't change the...

I have created a Combo Box in an Access 2007 Database with four possible items from which to select. Is there a way that the Combo Box Cell can display more...

Hi, This is just for my own education and curiosity. Does anyone know if Access stores it data records in a fixed length or variable length records /...

I have a Master Table in a Master DB linked to a few sub databases. The input forms (to update Master table) are in the sub databases based on queries also...