I am trying to put 3 or more data bases. For example:- one item sells today but tomorrow does not sell but I need that item # with "Value 0" How can I print...

After just upgrading MS Access 97 to MS Access 2003 my queries that use linked ODBC tables stopped working and now I receive the above error message. I know...

Hi Guys, I have been thrown into this so please forgive me. I have a table called Users. This table contains the following fields: SMTPAddress, Firstname,...

I built a database and all in all postal codes starting with zero it is dropping the zero. I don't know what i'm doing wrong. Please help!

Help I need help on how to insert an "IIF" formula to each field or cell of a seperate row of 250 rows in an access database table not the query. I could not...

I guess I need to rephrase the question. I have an option group with 4 buttons and each button is given a value from 1 to 4. I need to have those values show...

How do you separate field contents into two different fields? (opposite of concatenate)

Ello! Im beginner so need some help and answers plz. To make it short: Imaginary dbase.. I have 3 tables: Authors, Books, Cathegory (book...

When running the following query in Access 2002, I am able to see my results in the data sheet view, but upon attempting to save the query, the...

I have created a bibliographic database using Access 2003. Here some tables queries, and forms are designed. Some fields have null values. I provided the...

query = "Select * from AssociateDetails where Project_Name ='" + drop_proj_name.SelectedValue + "' and Competency_level='" + drop_comp_level.SelectedValue +"'...

I have query which collects the total expenses and income per month from two tables which works fine, now I want to add a third table to collect the total...

Help................. I have a probelm with seperate Access databases merging when PDA's are sync'd back to handbase. I have created a a handbase database...

Hi I have a Access database which store data from my weather station. I am struggling to write query which will give me the maximum temperature in the last...

How to compute two date equal?year?month?day? Example: #2006-02-23# - #1990-01-24# =16 year 0 month 29 day

When running a query that then exports data from 'Access' into 'WORD', any fields in date format are always changed back into the American system (m-d-y). This...

I have a Form that allows me to enter the date in one field and the day of the week (as a 3 letter day) into another field. I want to have the day computed...

I'd like to be able to return a text cell value from a table that includes fields for "start date", "end date", and the text value that I'd like to find. My...

I need to calculate how many cases have been open for 11 months. How can i do that in a querie.

I have a table which contains sequential dates that are one day apart from each other, in order to see entries for the last five days, I have used...