As with my post just a while ago, i have a second question relating to this - I have records Pests such that if a Pest is found in a location - "1" is given,...

I has found some sites with cheap marlboro cigarettes with delivery to usa and europe: === ...

I need a field that'll calculate the days interval between two date fields in the same table. I know I can get this through a query or form, but I prefer to...

You can not do this within a table. You would need to create an update query that does the math and applies it to the table. HOWEVER that is a very bad idea....

I assume you are putting these three names into separate fields? If not you should do. initial: left(,1) -- The 11th day of every month:

My team has been re-writting Access 2000 databases (linked to SQL db's) with Visual Studio and .Net to create ASP web pages (utilizing the same data in the...

Yes, the first, middle and last names are in seperate fields. If I understand your reply correctly, I need to and another field(?) to the Employees table...

Dates go into fields - not the names of fields. You can have a field for start and another for end and then run an append query that creates records for each...

i am creating a payroll package. How do i give the customer the option of using five different companies in the package?? For eg i am use the drop down box and...

Hi all: I'm a newbie to MS Access. I have an Access 2000 database with many tables and users can insert/update/delete rows to any of these tables. Is there...

I am making a database that is meant to calculate the commissions for our salesreps from several sources of income. I have a master form with subforms for...

Hi, I am using the table analyzer to break up a table that has grown too big. I am manually breaking up the tables (versus having the wizard do it). Now...

Dear all, I am a new user of Access 2007. In the samples which were given by the text books or the build-in Northwind sample, the product number is always...

A lady at work has asked me to comment on a database she has designed for hold court case information. Like all newbies there is very little normalisation...

I need help on designing a database that will track daily training and deployment activity. i have something started but it does not have all the "toys" i...

My database is broken down as such: 1. Surveys 2. Clinical data collected for each person 3. Checklists I have received info from Duane H. regarding the...

I have a table with 160 records. I am trying to set up my form so the user can select a record from a combo box, enter the payroll in a text box field and...

I am making a database that is meant to calculate the commissions for our salesreps from several sources of income. I have a master form with subforms for...

I just posted regarding sort order of fields and realized that my problem is that when I specify a text field length of 12 for my question number (it may be...

Hi all, Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in...