I have the following VBA code that is supposed to insert values into a table based on a select statement and a variable. lngID is a variable that is being...

I have two tables, one is for employees and the other I use to track crime report numbers. I need a query to total the number of arrests, warrants, adults,...

Hi, I'm not sure whether this is the right group. If not please point me to the right one. I have a database containing a table for each month and each...

I have a query for an address list from two seperate query/tables which have this kind of setup: Table: Field: Data: Main St, W1 11 Main St, W1

Here is the query. SELECT Nz(Count(a.com_num),0) AS Total, a.com_type FROM a WHERE (((a.date) Between forms!! And forms!!)) GROUP BY a.com_type; It...

I have converted an Access 97 database to an Access 2003 database. I have queries that include the value of controls on a form (i.e. StartDate & StopDate)...

I am trying to construct a crosstab query to display product competition for companies in a region, including reporting what cities do not have companies...

Greetings all, Here is my issue. I have 3 fields containing several rows of data retrieved and calculated from its Table. The query responds with several...

I have a query that pulls back all records that have a 0 value. It works fine. The problem is that I have a few records that contain a 0 value that I...

Hi all: This might be a foolishly simple question, but I was wondering if there is a way to get Access to include the name of the table a given query field...

I have a query to import and export a file into Excel. It is received each day with the name of the file and the current date in the title and it also needs...

I use Microsoft Graph2000 based on crosstab queries to visualize monthly sales. I cannot figure out how to include zero-sales months in the queries (and hence...

To simply the question I have a orders database with the following fields: Order Number Model Number Options. each record contains the same order number for a...

I want to select an incoming mail message from a known sender and have outlook refuse delivery with notification to the sender.

Hi Need to select records where a batch is completed Batch is made up of "Items" which are complete when field has a value in it. I need my query to select...

I have 6 tables, each table has a Yes/No field called that specifies if all questions (calculated on the Excel input template) have been answered. I also have...

I'm trying to determine why a crosstab query is returning different results on some calculated fields than it did some months ago when it was first run. The...

I'm at a loss for this one... I was working on designing new queries for a database that is on going, so I saved it as something else and played around in...

I have copies of an Access2K app that run in two locations using tables from the same backend database (Oracle). The app includes several append queries, all...

Using Access 2003, I have a Union Select query to combine information from two separate tables. In one of the tables there are two records that in one field...