I have a union query that keeps telling me that there is a data type mismatch. When I first run the query everything is okay and it displays the fields...

New at this, so please bear with me: I am looking to merge 2 fields unless duplicated. The fields are in the same row in the same table Female Surname & Male...

Hi everyone, I have a crosstab query attached to a graph on a report. It shows quantity of widgets produced by each employee for a specified period. The...

In a child day care center database at church, I have used the following expression in a PaymentQry to determine a past due amount. PastDue:...

Hi to all expert, I am running kind of a complex query and I want to know why I get the result as a string instead of a number/currency, the math is good...

Any idea why this won't work? TotalDays : nz()+nz()+nz()+nz()+nz() I get an error that say: SubQueries cannot be used in the expression. Any help would be...

I have an Access table with personal information (e.g., first name, last name, birth date, etc.) for thousands of people. The table is sorted by state. I want...

Hi, I have the mid statement to pull the 5th character, but I need the (query) syntax to filter out the ones that are a letter (alpha) -- Thanks, ...

Hello, I've found a wonderful concatenation function at http://www.mvps.org/access/modules/mdl0008.htm. It, however, separates the concatenated values with...

Hi, I have a form called Test. On this form, I have a textbox where I can type query criteria. I would like to be able to type multiple criteria into this...

Is this possible in a query? You have Table A Table B There is a link or join between the two tables. Table A is the main table, B is a sub or secondary.

Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields...

-- I hope this helps you, Dan

Hello, I have a contact table (Tblcontacts) that has fields (FldID, FldFirstName, FldLastName, FldPhone, FldStreet, FldCity, FldState, FldZipcode, Fld0to5,...

Trying to get a query to determine a tax rate based on the province on a record. It should look at the field and based on what is in that field come up with...

My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured...

I have Query1 that returns 2 fields: CatID Step1Decision CatID can be 01 thru 29 Step1Decision can be N,X,P,D,R Query1: SELECT qryGrievances.CatID,...

I am trying to Rank a field based on multiple sort criteria. My query sorts correctly, but the Ranking assignments are not correct. Could someone please...

I have a query set up with a one-to-many left join on two tables in order to pull all records from one table (the "one" side) and the corresponding records...