Hi , What do I write in the expr. box when I want that there "must" be a value in the field and it "must be between the number 0 and 1" ?

This is maybe hard to explain, but I have table relationships in mind such as one-to-one or one-to-many between tables in my database. I enter the...

ok, I have 1 table with too much data: TBL:Vendors VendorID - Autonumber Name - TXT OrderAddress - TXT OrderStreet - TXT ...

What are all the benefits of normalizing tables in a database? I have heard someone say that it only reduces space nothing more. Please advise. Misty --...

I have a time ago designed a database that has been functioning as expected but all of a sudden values in combo box drop lists have disappeared. Not that...

I am having problems with my invoice report. the report is based on a selected query and when i add a new customer to the tables that is in the query, it...

I have a table with all our Sales contractors. It has names and their IdCode. Also, there's a Sales Order table where all their sales will be entered. On...

I have created asmall application in vb.net. Not relevent here I know , but the table structure of one of the tables is. Right now I have three tables,...

This is a three part question. 1st question: I'm creating a database for a pyramid type business. I'm giving each member a unique id by the auto...

I have an employee table which contains employee name and supervisors. The supervisors link to employee table enployee number whick link to itself. How should...

Hello, I want to set up a new database with actual sales figures, budgets and forecasts. The actuals and forecasts are updated on a daily base and the...

Posting question as last resort - been using this forum for long time with wonderful results - great job people. Bleery eyed search - finding no viable...

hi, I want to pull data from more then one field ( as it seems with a combo box with multiple fields listed in a row ) and have it save these fields to a...

I'm working with 2 tables. One contains Table Reservations, and the second contains the People that will be sitting at the tables. Is there a way to...

I own and enjoy MS Access 2007 as a desktop database. Pardon my ignorance - first time to this forum and access databases. But now I would like to put a...

I'm trying to design a database to track build time for equipment and issues by assembly. All equipment has a model, serial and job number to track them. ...

I'm designing a database for a dog club. I started off with something like tblMembers - autoindex - name, address, phone. etc - 2008 payment amount -...

I have a database that records specimen results. It was meant to be a nice simple database so that paper records could be logged and found easily, but seems...

I created a table that lists our Loan Officers and their approved lending limits. The table has these fields: officer name, unsecured limit, secured limit,...

I have a data base developed in access 97, converted to access 2000 and now I'm trying to convert it to 2003 but most of my reports queries and forms use the...