I am trying to export a field 1.1367 to .TXT pipedelimited. When I export the value is automatically changed to 1.1300. Any suggestions on how to make the...

Hi Everyone Somebody suggested that I could use update query to add all values from one field to another one. I want to add autonumber values to a numeric...

I want to format a field in a table to take either dates or text. Now if I format it for "short date" it won't let me type in text ie: N/A or not needed. ...

I am working on a fossil database in Access 97 and an stumped on how to build a conditional relationship. I have 3 main tables (age, specimen, and fossil)...

I'm faced with a unique problem. many-to-many self join I have a list of drawings. some drawings include subdrawings and those subdrawings can have more...

This message is for John, but, of course, I'd like anyone to respond. John, I'm having trouble understanding the lookup tables concept that you described in...

I have created a database using Access 2000 but what I want to do is create a main page, so when you open up the database, the first thing you see is a page...

What is the correct answer to this function in MS Access: @Prompt(,,,,)

I have a master database called "Master List". It contains ID, Name, Address, phone, etc. I have a detail database called "Transactions" It contains, ID,...

I have designed a survey using asp and MS Access In this survey, currently, I am storing all the results in two tables. SurveyResult - (9 fields) for storing...

Any suggestions (including "out-of-the-box" solutions) can you recommend for creating a web based time recording tool that is not based on calendar days (ie...

I am setting up a database of customers and I want to assign each customer a unique password. Can Access automatically generate this for me. I want...

Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this...

I am trying to build a table and one of the fields requires the user to make more than one selection from a drop down menu or in a list. I know it is easy to...

Suppose I create two tables to store information. I want to desing a form where I can have the fields of both tables. I want to know how to access the fields...

I have tried numerous ways of setting up this subform and each one has presented with shortcomings. Maybe someone has a suggestion of a better way of...

I calculated downtime using a query and now I need to change negative numbers (not downtime) to zeros. Please let me know how I can do that. Thank you

I have been assigned a task to create a database and need some advice on the correct design. I am not new to Access, but nowhere near an advanced user. The...

Im designing a database application that will be built using a SQL Server backend but I couldnt see a managed newsgroup for sql server table design so, as Im...

I have added the 2002 Template Wizard to Excel and I'm creating records in an excel database but I can't create records in an Access database. The...