Running & Setting Up Queries - Page 1089

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Selecting records based on time. Example: 07:30:00 AM by KellyJoe I have a list of records and I want to select the records with times less than 07:30:00 AM. I keep getting a mismatch error when I try to run it. I'm...	December 3rd, 2006 03:11 PM by raskew via AccessMonster.com	2	88
Update a table inside the dataview of a query by John T Ingato Geeze, I wonder if that makes any sense. I have a table with a list of 1800 stores and store information. Some of the records have missing information. So...	December 3rd, 2006 02:04 AM by John T Ingato	2	112
Triggers in MS Access by WAstarita I know access does not have them but I've read of SQL programming that allows for updates and deletes, appends, ect in SELECT statements. Could someone post...	December 3rd, 2006 12:51 AM by Albert D. Kallal	1	113
If No PO Then Show Part Number by Nanette I need to create a query that pulls up a Part Number from the Part table only if there are no PRs in the PR...	December 3rd, 2006 12:26 AM by Nanette	5	100
MonthName by LCalaway I would like to substitute a month's name for its numeric equivalent in a query. The date field () contains dates like 3/4/1855 and 12/31/1843. I want my...	December 2nd, 2006 10:44 PM by iliace	7	107
Creating calculated fields for a query using data from another table by John S. Ford, MD I have two tables: tblEmployees: EmployeeIDNum (primary key) Name tblEmployeeReviews EmployeeReviewIDNum (primary key) EmployeeIDNum (foreign...	December 2nd, 2006 09:49 PM by John S. Ford, MD	6	97
Whats the difference between DBEngine(0)(0) and CurrentDb by John T Ingato What is the difference? Does "DbEngine(0)(0)" not return a database object, just as CurrentDb does? I have run an action query with: DbEngine(0)(0).Execute...	December 2nd, 2006 08:50 PM by Marshall Barton	1	109
Need Help with an Access Query Problem by Diane Hi! I'm hoping someone can point me in the right direction. I have an Access db that connects to a Replicated db that displays a course schedule on a...	December 2nd, 2006 07:26 PM by Jerry Whittle	3	106
Using MS Excel w/ A Query? by Debris Hello, I have an Excel worksheet that takes basically one piece of data, runs a bunch of calculations, and produces a result. It uses some fancy formulas...	December 2nd, 2006 07:10 PM by Debris	0	87
Update Query, where to begin? by Steve Schapel Fred, I would expect an Append Query rather than an Update Query. Can you give details of how you are doing it at the moment, i.e. SQL of the query used,...	December 2nd, 2006 05:45 PM by Steve Schapel	0	86
Call a saved query from VBA module by John T Ingato How do I call a saved append query from VBA module. I tried using docmd.runsql() and hand typing in the code but I am getting error. The saved query in the...	December 2nd, 2006 05:06 PM by John T Ingato	3	95
data type mismatch errors by dougforester The environment: Access 2003 Windows XP Pro The task: Use Access to extract data from a Quicken report to locate trends in the sales of our (non-profit) book...	December 2nd, 2006 03:55 PM by Jerry Whittle	7	136
Updating calculation of form by FredVN How can a make a calculation in a form object update automatically when data used in the calculation changes. All data is with he same record. This has to be...	December 2nd, 2006 01:23 PM by FredVN	2	107
query parameter ignored - please check my syntax by iliace This one has me stumped. My question is, basically: "For the two departments in question, list all employees who (a) got paid on 11/27/2006, and (b) had one of...	December 2nd, 2006 12:42 PM by Gary Walter	6	137
library MSVCR80.dll by Ingrid After installing Office 2007, Executable 'C:\Program Files\ADSL Monitor\ADSL Monitor.exe had the following unrecoverable error: Could not find library...	December 2nd, 2006 09:13 AM by Ingrid	0	102
Update Query, where to begin? by Fred Wilson trying to post again Fred Wilson wrote: I am not sure what happen here. It did not post right. Fred Wilson wrote: Hello all. I have toyed and...	December 2nd, 2006 03:02 AM by Fred Wilson	0	85
Using an IF statement in an MS Access Project (adp) Query by Ian Bateman I have two fields in my Customer database named Customers.LastName and Customers.CompanyName. I want my query to display the Customers.LastName field if the...	December 2nd, 2006 02:14 AM by Ian Bateman	4	215
RUNTIME ERROR 3190 - too many fields defined...?? by WebDude Dear Access2000 group, My Table_Volunteers has 70 fields. My query_A displays all 70 fields (from table_Volunteers) plus an additional 17 calculated fields...	December 2nd, 2006 12:43 AM by WebDude	4	665
What is the best way to filter out several data types in a field? by Donna I want to eliminate serval types of data. For instance I do not want to show, D,S,V, DV, M, 1, X. I keep getting an error that the string is too long. --...	December 2nd, 2006 12:20 AM by Seth Schwarm	1	96
problem updating a linked table by [email protected] Hi, I'm testing an ODBC driver against Access, and am running into something that might be a problem or might be design. If I have a linked ODBC table in...	December 1st, 2006 11:42 PM by [email protected]	0	62

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed