Queries

Query based on 2 parameter in 2 diff tables
Access 2007 I am trying to create a query that will look and pull data from 2 different tables based on a username the user inputs and an object name the user inputs when the query is initially ran. Table 1 shows a user name and the role the user is in Table 2 shows all the roles and which roles are assigned... 13 Jan 2010 14:21

Control Select Query Output Field Type
I have a simple query to generate sales closure rates Invoiced Rate: Format(([Invoiced]/[Ordered]),"#00.00%") where Invoiced & Ordered values are linked from other tables. The query generates the percentages correctly, but the field type is Text. I need the Output to be numeric (yet retain the %) ... 14 Jan 2010 09:03

SQL Statement Insert Into
I need to append data from one table1 to table2 using the field in table3 as the criteria. This field in question is 'account number'. How can I write a sql statement to accomplish this? ... 13 Jan 2010 22:14

IIF stmt in Criteria
I have a query and I have the following in the criteria of the ListOrder column IIf([Forms]![SelCri]![HideNotActive]="Yes",<>45,[ListOrder]) I want the results to exclude only 45's from the ListOrder if the form's control is set to "Yes" Apparently the query does not like '<>45' in the iIIF statement. (It w... 12 Jan 2010 15:13

Populate Table with Fields from Another Table
I have 2 tables, Claims and Transactions. They have a 1 to many relationship, 1 claim can have many transactions. The issue I am having is that we are working backwards. Instead of inputting a claim and linking the transactions to the claim, I am receiving a data feed of the transactions and need to populate... 13 Jan 2010 05:27

IIF Statement - Query Help Needed
I have a table full of items, below is one example from the table. I am trying to do a query that will display the longest dimension (as L1) for each item. Item field is text, all others are numbers. Here is my data: Item = Y10227 ItemLength = 8.375 ItemWidth = 9.25 ItemHeight = 5.125 Here is the field ... 12 Jan 2010 10:41

How to Populate a Table based on Entries in Another
I have 2 tables, TBL - Claims & TBL - Transactions. This is a one to many relationship, 1 Claim has many transactions associated with it. The issue arises in the fact that I receive the data feed of the transactions, and need to populate certain fields into the Claims table. The Claims table contains a uniqu... 12 Jan 2010 10:41

How to concatenate remarks for a given purchase request
In our financial management system, a user can add multiple remarks for every purchase request. So for example, I have a table that looks like Input: Purchase_req_no remark_no remark --------------------------------------------- PRN_100 1 "first remark line for 1... 6 Jan 2010 09:47

Error in IIf Expression
I have an expression in my query to create a concatenated text depending upon the value of control Measurements. If the control is skipped - meaning that there are no Measurements, I'd like to return an expression to that extent. Here's my expression: Expr1: IIf([Measurements]=Null,"The damage is not such that... 6 Jan 2010 09:47

Concatenate same field records into one - FOLLOW UP
Hi Allen (I hope) I used your code and instructions to perform what I needed to - brilliant .... though I now want to change the default separator from comma space to " and " When I adjusted my code to what I thought would work I initially got syntax errors (from memory 5035) though now the code runs but th... 6 Jan 2010 09:47