Queries

Total count for crosstab query
I am working on a query to show the vendor_name and the total number of pieces the user completed for a certain date. I am pulling the info i need but having problem with the calculation for the totals. TRANSFORM Sum(sku_information.item_type) AS SumOfitem_type SELECT vendor_information.vendor_name, testing_in... 2 Jul 2008 16:01

memo field in the select query
I have a memo field in my select query and only return 255 characters. Do I need specify any return type using select query for memo field? The query is for the report. The report does not show all the information in the memo field. Your help is great appreciated, ... 2 Jul 2008 10:52

Number format resulting from an aggregate query
I get numbers formatted as, 27.0000005960464 41.8999988585711 resulting from an aggregate query. I tried setting the format of the field to General, Fixed and made the decimal place to 1. It still appears the same. I am thinking that the summation gets done after it has done the formatting. -- Sajit Abu... 2 Jul 2008 13:57

Count Distinct Values In Several Columns or Fields
I have a table that has 4 different columns for each customer id: Address1 Address2 Address3 Address4 I am trying to get a count of unique values across these four columns/fields. Any ideas on how to do this? ... 2 Jul 2008 09:50

'Current Row' or similar for query-based combo box
Apologies if this is an obvious question, but I can't find any suitable query function or operator. I have a series of tables with RI enforced foreign keys. When keying data into a given row, I want to be able to limit the combo box values by a value I have already entered on the current (uncommitted) row. ... 3 Jul 2008 15:36

Calculating Working Hours that cross over midnight
Hi, I am trying to make a query work that will calculate hours worked. However, when my working time spans midnight I get negitive figures. My expression to calculate the expression in the Field Line of the query is: workingTime: [FinishTime]-[StartTime] The result is expressed in days To convert to hou... 2 Jul 2008 03:42

Select records by employee
I have a table with about 31000 records. Table as the following fields: Invoice Number, Supervisor, Employee, Action The action only has 3 possible variables - buy, sell, hold. I want to check the quality of the employees work an so I want to somehow query and randomly select: 10 buy, 10 sell and 5 hold... 2 Jul 2008 08:48

Case or IIF?
Might there be a better way? I am trying to pull text from a field in one table and then assign those records to that result. For example, if the printer name contains "gen" it is a member of the "Medical" department or if it contains "acct" then it is a member of the Accounting department - and so on. I ... 3 Jul 2008 14:34

Trying to find values that are not equal
Hi; I am a new user... I have the same field in two different tables. I tried a query to find the records where the values are not equal. I used the expression builder but got zero records which I know is not correct. I tried expression builder using the following: Table_A, Field = RSL_1 Table_B, Field = RSL... 1 Jul 2008 16:27

Update Query to a SharePoint List
I use Access and SharePoint daily, but just switched from 2003 to 2007 versions. I have a list that was created in SharePoint that I have linked into Access. I need to add information to this list and one of the columns that I need to update is a people or groups column type in SharePoint. Everytime that I ... 1 Jul 2008 15:25