I have a table that has several columns of information about employee performance at the company I work at. From this table I made a simple query that shows...

I need to create a query that will return records from a table, but this records will be selected based in the position on the table, for example every 10th...

Hi: I'm trying to create a query that retrieves the oldest dated record. Scenario: Battery rotation program. User inputs dead (discharged) battery from...

I have a query to calculate commissions that has multiple IIF's. It's going to have many more IIF's and I was wondering if there was a way to use a word...

I cannot seem to find out how to update columns in table (a) from table (b) in Access 2002. I do it rather simply in SQLServer however I am having trouble...

is there any type of "And/Or" operator? thanks, Rob

I have a database of customers and their orders. there is a line number field for customers that order multiple items. the first product gets a line number of...

Hello, I have a complex question. I have started the process of this solution by creating the basic query: SELECT DISTINCT tblCustomer.area, ( & " " & & "...

I'm using a make table query to select records from one table that match certain criteria. I've added in other tables as i want to exclude records from some of...

I would like to run a query on a memo field that will show all occurrences of one word in the field. Is there anyway to do that. Jana

I pulled in the "applet" from Duane Hookoms link on Rogers Access Library and I'm impressed but I ran into a little problem with calculated fields in that they...

Good Morning, I NEED HELP. I have a survey form designed and field out by 712 people. The consist of check boxes for either yes/no answers or multiple...

Having difficulty getting sub queries to work. I have 3 fields ASXCode, ImportDate and Close. The result should select 1 result. First I want to select a date...

Hi, I would like to create a product as a summary - but there seems to be no product function. I toyed with the idea of using logarithms, but sadly there is no...

I'm trying to do a select query that has 36 fields and 18 comparisons in the WHERE clause. When I run the query I get the message: "The Microsoft Jet...

Hi I work in a hospital and have a table of patient data including two columns - one showing the date the patient was referred and another showing how...

Here is the SQL for my Crosstab : TRANSFORM IIf(IsNull(Count()),0,Count()) AS DaVal SELECT Background_Table.Country FROM Background_Table,...

I have made a small change to a complex query. The query runs ok. However, when I try to save it, MS Access just shuts down. The query is not saved. The query...

I am trying to get the minimum value of three fields and cannot get it to work like excel. In the query, I tried using FieldName: Min(++. Does anyone know...

I have a query that Pulls 5 separate tables together. Table A has the major portion of data, and the Primary Key = to all the other Primary Keys. I bring 2...