I have setup a query to look for inappropriate data. I then setup another query to count the number of records in the first query which are then reported on...

Hi Guys, Access 2007 FE, SQL2005 BE Can anyone help me with this issue, I am sure I am making a simple mistake, but cannot see were I am going wrong. I...

Hi Guys, Just looking for guidance of this issue. I have been trying to improve the performance of my BE SQL 2005 database, and have identified a number of...

I have the following query: SELECT .*, .Speed FROM INNER JOIN ON (.ID = .ID) AND (.Category = .Category); Here is what I want to do: The ID and Category...

I need to put in a query dates beginning 9/1/2007 thru 8/31/2008. How do I enter that into the query under date? Thanks

I know this is a simple query, but I can't remember how to do it. I need to count how many times each value repeats in a feild. I need to count the number of...

I have created 2 identical select queries except that one should display records with a value greater than zero and the other should display records less...

Hi there I am having a minor issue with my access. I am linked into our database through Access. All monetary columns have a 15.2 format which means access...

I have created numerous queries in Access 2003. When using the mail merge function in Word I have always been able to click on the browse button, find the...

Elementary question I'm sure. I have made a query from two tables. The fields selected from the first is Site ID, and Sample No. Maybe 20 samples per site....

When i am trying to open the query i am getting the message "Type Mismatch". Please explain how to resolve?

I maintain a database of shipping records which I update weekly. The database is largely used for simple queries about our shipping activity, and is not...

I am trying to make a query where I have one table "call it products sold " that has the price, lbs, QTY of the sku's.... I have a second table "call it...

In Access 2007, I am building a db to help manage a homeowners association. The task is to create a record of association meetings. In this task, I need to...

I have a query that is intended to update the quantity and total cost for items purchased. This query is run after a new purchase order is entered. It’s...

I have three related tables; the primary tblFilm contains info about each produced film. The related tblPresenter contains info about the trainers in the...

I need to calculate multiple values for a field called CSP that will be based on a calculated field called Days. Days is calculated by using DateDifference...

Is there a way to pass a variable to a query? As an example, as a criteria?

Hello I am designing a table with a look up field. When I make a query upon this table, I need to use each of the look up value in the field as a field in...

I am importing a table from another app. It is passed as an excel spreadsheet. I have a routine that "cleans up" the sheet, then imports it into a temp...