I've read on this group that it's possible to create a Crosstab/Union query. However, this doesn't work: TRANSFORM First(yrSales) SELECT "Sales" as Graph FROM...

This seems very odd to me, I'm trying to concatenate two fields in a query. Expr1: & - = #Error but if I reverse it works fine? Expr2: & - = Kennedy-27 I...

How to I remove nonprintable character from a text field in MS Access (2003)? I found the CLEAN function that works in Excel, but it is not available Access.

My data is scan data that shows the LabelID, Scan Date Time (SDT) and an event type for each scan. I want to find each unique First SDT that corresponds to...

In my db, access 2007, I have two tables setup "Input" and "Payment_Details". What I want to happen is when a user enters an item into the the "Input" table...

I have created a crosstab query that shows in column A the SKU of a product (ex. AAA011/3) The cross tab columns are different distribution locations, and...

I've got a report based on a query that will count records within a certain group(field). I only want to print those records for groups(fields) totaling...

I'm not sure how to do this. I need to create an exception report. So, I need to create a query for the report. The query must 1. search for all accounts...

I have a query that returns all records pertaining to a particular payroll period for employees. I need to make a new query that will total the number of...

Hello to all, Is there a way to run an update query that will change text that's all capital letters to only capitilize the first letter in each word. For...

I found a few articles online that said a persona can use a parameter inside of a crosstab query, so I know it can be done, but I can’t figure out how to...

I have a query that has the following information. ID Title Probability Impact Exposure Numbers located within the Exposure value vary and in some...

Hello, I have three tables that collect data. Each has an operatorID field. I then have a table that has the operatorID and the operator's name. ...

I have two tables Main and Keyword. Main has a Description field. Keyword has Keyword and Key field. I want to be able to create a query that returns Key...

I have two fields in Tbl STUDENT, one is Home State (H_STATE) and the other is Work State (W_STATE), i need an update query that changes all records to...

Hi Folks I need to generate a fairly long SQL string to run as an action query - I do this in code. General select is simple enough, but using several...

I have a “Find Duplicate Query� that is using another Query for its data (basically taking many fields from a table and selecting the few that I need for...

I have a table where the date displays as "20080618". I would like to change it to display "Jun 18, 2008". Is there a way to do this? I looked at the...

Is it possible to add a leading zero in front of a letter? For example C81 would look like 0C81. Thanks in Advance, Lisa W.

I have had a problem parsing a time-fields contained in NMEA-data (record-type: $GPRMC) in an Access-query. My original data source neatly had output every...