I am using a form to retrevie data from a query. I followed the steps to create a combo box on a form from http://www.fontstuff.com/access/acctut08.htm. I...

I have a query with fields showing below. Mfr Model 1984 1985 1986 1987 1988 1989 ...........................2008 I need to sum the field from 1984 to 2003...

Every time I open a saved word document, the following box pops up: Opening this document will run the following SQL command: Data from your database will be...

acheter achat zocor canada bon marche zocor de Simvastatin soft achat zocor belgique au rabais au belgique acheter votre acheter zocor un Achat de acheter...

I have 2 queries that generate 2 reports, both queries ask for "starting date" and "ending date" these reports are always run together. Is there a way where...

I am new to Access. I am using the MS "How To" to assist in creating a form to supply parameters to a query. Thus far all controls on the form are working...

I have currently added about 2000 multiple choice questions ( and a few True false ) to my database. collum 1 has the question number in it then in the...

I have this SQL Delete * from table where customernumber = 153 And now I need to delete more that 200 customers from my table. Insted of running the SQL 200...

I'm getting the following error when I run a query from an Access 2003 application using links to a SQL Server database. The column prefix 'db.tbl_Gaps' does...

I have a form bound to a table of available tests for a summer Credit By Exam Session. I created a query that finds only the tests that were signed up for...

I have one table that contains city state and zip. I have created another table that has each of the unique values of above and another "code". One of the...

I want to create a query that searches for words in multiple columns. I currently have it set up using Like "*" in the criteria for one column and it works...

I need some help designing a query that calculates a specific date from the hire date of an employee. For example: an employee is hired on 05/13/08 and 3...

In a pass-through query we are calling a stored procedure. How do we pass forms data as a parameter to the Stored Procedure. I tried this Execute...

while creating a query using a grid, what is purpose of using "where" . This comes up when we use Totals. can we use a criteria just below the field which has...

Hello in a field of a table lets call it F1 of Table1, there is data entered but with "spaces at the begining or the end of the text. And maybe more than one...

If i create a Querry between two data tables is it possible for me to also show the items that do not match. For instance I set up the relationship to show...

Hello all. Please see the SQL below of the queury I am building. The queury worked fine until I set criteria to count only fields that contain the word...

Good morning. I posted this question yesterday, but failed to give a good description of what I am trying to do. The SQL below is my attempt to group a list...

I want to Append data from an existing table ( Safety supply transactions) into a YTD table ( SUPPLIES USAGE YEAR TO DATE) including only new records based...