Queries

IIF/UpdateQuery/AppendQuery???
This morning I got help with the IIF statement but now it got a little more complicated (to me): the original: If StdPrice = 0, give me "rebill" If Part# ends with "OSP",give me "outside processing" now in addition i need: If StdPO > or = 0, "Performance" If StdPO < 0, "Economics" This is what I did:... 9 Jul 2008 18:52

Dues Query
I have a employee database. In the database, union members are a subset of employees, as such their "member status" is "member" or "member-LOA" while non union members are identified as "non-member" or "retired". Periodically the membership dues change for all members; non-members are not affected. When dues c... 9 Jul 2008 16:48

Queries and reports
Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The... 9 Jul 2008 16:48

Append query for data recovery
Hi, newbie here. I've recently lost a lot of data from an Access database. I've since recovered it, and would like to combine it with additional data created since the loss. I thought an append query for each affected table would do the trick, but I'm having problems appending the linked fields (some are AutoNu... 9 Jul 2008 16:48

Crosstab Parameter Decleration
Hello, I have been researching this for couple of days and with some trial and error managed to build this croostab statement. Unfortunately my parameter declaration gives me an error: Invalid bracketing of Name '[Forms]!Overview![ExecDash]' The purpose of this paramameter is to requery the crosstab on th... 9 Jul 2008 18:52

Concatenate in a query - Access 2003
I have a table which refers to two groups of salesmen, District Managers and Sales Service Managers. DM's are over SSM's and both are referred to in the table. The table only holds codes for each salesman which then refers to another table which holds all salesmen's info. This table seperates first name from ... 9 Jul 2008 15:46

Help with calculation flow days
Hello, I got a query that I try to calculate the number of days at several operation, but not sure how to go about calculating in query. In the query I got the field for order#, workcenter, oper#, finishdate and other. I would like to calculate number of work days exluding holiday at each workcenter. sample ... 9 Jul 2008 11:38

Query INSTR function?
I'm using a query and need strip out data. Here is an example of the data I have to work with: 85123147/RS08 85123147W/RS08 TEX-M/SS09 I need my query to strip off everything after & including the "/" so that I get the following results. 85123147 85123147W TEX-M Do I accomplish this using the INSTR fu... 9 Jul 2008 12:41

Deranged Calculation
I'm not sure this is going to make any sence I need to take the Sum of these amounts in table A and B grouped by Account # separetly and then compare them , grouped by account #, with some data from Table C though whilst still keeping the sum of A and B separate. The problem is that when i put the data together ... 10 Jul 2008 11:20

Query ??
Dear All I have a table with the following fields which I have uploaded from a spreadsheet ID Number Reference Type Reference There are two reference Types, NI Number and Silverlink Number, The Reference is then the number itself. If there is more than one reference type then there are two records in t... 9 Jul 2008 13:42