Queries
in [Access]
|
Criteria is entered in 2 columns, query is only utilizing one setof criteria Access 2007 I have a flight column and a date column. There are specific flights for specific dates I want to see data for. The query is returning the right flights, but ALL dates, not limited to the ones I want. If I remove the flight criteria, it limits my dates as desired. What is the deal? WHY are ... 8 Apr 2010 15:12
Query help please I have two combo boxes. Location and Super1 The location box lets you select a location where a staff member is working at.For example U3 B-days. The Super1 box lets you select their supervisor who works U3 B-days. As it stands right now it will work. The problem is that it will show all Supervisors through out ... 8 Apr 2010 15:12
Search for Words in Documents Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search for words in these engineering documents. How can it be done? ... 8 Apr 2010 12:37
Cutting excess rows I have quite a complicated query: SELECT [Loans - Payment History].DateOfPayment, [Loans - Table].[In Default], [Loans - Table].AmountofLoan, [Loans - Table].[Client ID], [Loans - Table].DateofLoanAgreementSigned, [Tbl Client Information].[Last Name], [Tbl Client Information].[First Name], [Tbl Client Informatio... 7 Apr 2010 18:03
SQL for specific pattern of output? The following example is a simplification to make my question less complicated. I have a database of 3 people: Brown, Jones, and Smith. Each person in the DB has 2 fields associated with their name field: Field “A” and “B”. The values in A and B are either 0 or 1. The following SQL string extracts a query... 7 Apr 2010 18:03
Drag and Drop [Access 2007] Is it possible to be able to drag a shape (rectangle, circle, etc.) from one side of a form to another. (to simulate a simple 'mini blue print'). If so, any link or direction you can send me to accomplish this would be fantastic. If it is possible, is it also possible to rotate the shapes? Thank you VERY mu... 8 Apr 2010 09:30
User Defined Query Function Not Working with Multiple Criteria Using Access 2007 I created a user defined function used in a query that works fine on single criteria but not two or more. These work fine: MyFunction="Open" MyFunction="Closed These don't work: MyFunction="Open Or Closed" MyFunction="'Open' Or 'Closed'" What do I need to type to get this to work? ... 7 Apr 2010 18:03
averaging specific data Hi, I want to average data but I need to exclude the highest value. in other words I have 18,20, 25,32, 10. I want to average 10, 18, 20 and 25 eliminating 32. Any ideas? ... 7 Apr 2010 15:47
Why Won't Variance & Standard Deviation Work Access 2007. I've created a Query and at the bottom of the data, I'd like to run: Sum (which works) Average (which works) Count (which works) Maximum (which works) Minimum (which works) Standard Deviation (which does not work) Variance (which does not work) I do not have any formatting associated with ... 7 Apr 2010 15:47
Query Question... I have 2 tables...Job and Material. I am trying to configure dlookup to return value of 'Note_Text' in table 'Material' based on 'Part_Number' in table Job. DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]") Any help would be greatly appreciated. Thanks David ... 7 Apr 2010 13:31 |