Hello, I have a crosstab query called "qry_case_cross_crosstab" that runs against a table just fine however I need to change it so that the results are...

I am importing an excel spreadsheet that I need to normalize so it can fit into my database. Since I will get a new spreadsheet every month I will need to...

I have the following expression but want the criteria to include 2 fields: IIf(IsNull(),2,1) If HR is null AND NARC is null I want a 2 otherwise a 1. ...

This is very strange. When I build an IIf expression in query design view access (2003 first, and then upgraded to 2007) is changing the commas to pipe...

Hi, I've got a problem with a query, mainly how to get the right value of . I have two tables (simplyfied) with the following fields: TABLE 1 (tblEntries):...

ow do this in access =RIGHT(A3,LEN(A3)-FIND("\",A3,FIND("\",A3,FIND("\",A3)+1)+1)) A3 being a field in access

The government agency where I work is changing the way it tracks labor cost. We used to use a flat hourly rate for every employee. Now we are going to use...

Have some content on how to create complex queries, atleast suggest good books if you cannot put one on the web ---------------- This post is a suggestion...

I'm getting this error message and the codes below, trying to export an Excel table into a text file. Code is also below. Run-time error '3011': The...

Our organization provides a Supervisory Report to more than 80 school districts, state wide, annually. Each report must include the districts contact...

Hi there ! In a query I have the time the activity started and the duration . I would like to create the field TimeStop:+ Activity started at 12:00, the...

When I create a new query and pull in an existing query, all that shows is a * and all the fields in that query are not listed. When I open a query based on...

I have a query with multiple columns of numbers and several hundred records. I would like for the query to return one row, containing averages of each of...

The excel sheet that is used to import into the database uses 90601 as the date format, which represents June 1, 2009. I would like to create a cross tab...

Hope this comes over ok. I have a query retuning a rows with a number of fields in it. Where the return of a certain field is 'x' I don't want it returned....

Hello, I can successfully create a 12-month rolling average based upon data in this...

I have the following Access query, everything is as I want it to be apart from duplicate PID_No's. Is it possible (within the same query) to group by PID_No...

I am attempting to use the IN expression along with a parameter to filter a query. I am using the criteria seciton of the criteria grid. Example: IN (). ...

I have a table that records adjustments to player accounts. It lists the date, time, amount and includes a "comment" field. The problem is, the comment field...

I am using Access 2007 and trying to join two tables by matching a partial field on one of them. Problem seems to be that if the RonsList. does not have a...