Enter Keywords:
1 - 10 of 15(0.016 seconds)
Sort By:
 
Hi all, I am trying to get this spreadsheet to do something and it just aint working for me. I have 2 sheets, one is a list of all users with details on their projects - the other is a list o...
Zones: MS ExcelDate Answered: 05/25/2006 Rating: 9.8 Views: 0
I am attempting to conditionally set a criteria field in a query depending the state of a field on a form.  The SQL Is as follows:   SELECT [Employee Lookup].EmployeeID FROM [Employee Lookup] ...
Zones: SQL Syntax, MS AccessDate Answered: 12/19/2007 Rating: 7.6 Views: 0
SETUP: 1 FORM  "frmForm1" 1 Textbox called   "Text1" 1 command button called "cmdUpdate" Text1 shows values coming from a table: The value is either numeric or text. 1 table calleD "da...
Zones: MS AccessDate Answered: 02/05/2002 Rating: 7.6 Views: 0
I would like to accomplish the following: I have a table called tblMain.  In that table, I have the following fields Name      GCO#      Title The data in the field name is derived from a ...
Zones: MS AccessDate Answered: 04/02/2006 Rating: 7.4 Views: 0
Here is my problem, I have a Query in which users will select items to ship off it with a check box field.  I have another query which sums totals from Items shipped.  I want to bring in the SumofQ...
Zones: MS AccessDate Answered: 03/27/2006 Rating: 9.8 Views: 0
I have a make table query, and I need to enter an 'engineer number' as a criteria.  The trouble is I need to enter a hundred or so engineer numbers!  So - can I store these 100-odd engineer numbers...
Zones: MS AccessDate Answered: 05/08/2006 Rating: 9.2 Views: 0
Hi - hope you can help: When designing a Query with Criteria Perameter, is it possible for the prompt to contain a "Drop down" list from contents of the field in the Table? e.g. A Table c...
Zones: MS AccessDate Answered: 06/04/2006 Rating: 9.6 Views: 0
I am trying to find out how to program lookup functions using multiple qualifying criteria.  For instance, I have the following data in excel in cells A1 to D3, with the answer cell being F1: Pa...
Zones: ProgrammingDate Answered: 02/10/2004 Rating: 7.4 Views: 0
Say I have a few tables in a database, like this: tblStudent (StudentID, StudentName) 1,Alice 2,Bob 3,Charles 4,Donna tblClass (ClassID, TeacherName, SubjectName) 1,Mr. Anderson,Chemistr...
Zones: MS SQL ServerDate Answered: 05/27/2005 Rating: 9.6 Views: 0
Hi - an Access question: In a Table called STOCK TABLE  there is a field called SUPPLIER which is a Lookup Combo Box linked to a field called SupplierName in another Table called SUPPLIER TABLE ...
Zones: MS AccessDate Answered: 04/23/2006 Rating: 9.2 Views: 0