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...

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

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...

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

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...

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...

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 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...

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 have a main table (Table 1) that I use for login of MOST of our laboratory samples. I have a couple of other login tables (Table 2; Table 3) that keep track...

I have a query with 2 tables joined. Table A is much larger than Table B. Each transaction in Table B contains a group number. Each record has only one...

I have some general questions about the efficiency of queries. My system has a main table with lots of links. The main query I use retrieves every column and...

Need To Know the name of the Fuction( if exist) that give me the Avarege of the Values 0 . ("True Average") Thank u

I need to compare the term date of a given record of a consumer with the effect date of a different record of same consumer. if term date is 1 less than...

Hi, I am working on a project and plan to use Access to connect to SQL server. The developers are worried about time-outs... so my question is - Does Access...

Took my Dad to specialist in Topeka today for his Parkinson's. On wall was chart explaining the steps of a migraine... last step(loosely remembered): "the...

Had this one working in access 2002 now running access 2003..do not know if it matters or not. Get the Errormessage: undefined function 'Mid' in...

Please help construct a query: I have a table that defines an organization chart, main fields a UserID: Text (Primary) FName: Text LName: Text Supervisor:...

Currently doing this using an append query, but this is waaay too cumbersome: I am appending each field with text, one-by-one, from the populated table into...

I've got a calculated field in a query that represents a currency amount, but I can't get it to display the dollar sign in either the query datasheet or in a...