Running & Setting Up Queries - Page 311

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
Query won't for editing in design view in 2007 by Neil I have a query that will not open for editing in Access 2007 design view. There is an error message that comes up that states the following: " is not a...	February 12th, 2009 07:36 PM by Jerry Whittle	1	198
Extract data based on time by MAY I have a data logger that collects data every 5 seconds from 2 sources. I have imported the data into 2 tables. How can I extract data every 5 minutes at the...	February 12th, 2009 07:28 PM by Jerry Whittle	1	62
Query to Parameter Query ? by D. Stacy SELECT (#10/15/2008#)+TimeSerial(0,,0) AS time_ FROM TblMinPerDay, TblDates; I would like for this query to allow the user to select a data at runtime. ...	February 12th, 2009 07:18 PM by MGFoster	2	82
query that brings a autonumber field by Ben Hi all, I would like to write a query, where I can create an auto number field. That is if my query brings back 100 or 1M records, this field would contain...	February 12th, 2009 07:11 PM by Ben	0	65
beginning and end of event sequences by Dale Fye I am trying to figure out how to determine the beginning and end of sequences of events. I have a field (Report_Date) in my table, and I want to identify all...	February 12th, 2009 07:10 PM by Dale Fye	7	96
query that brings a autonumber field by Ben Hi all, I would like to write a query, where I can create an auto number field. That is if my query brings back 100 or 1M records, this field would contain...	February 12th, 2009 07:10 PM by Ben	0	71
Counting Subquery Syntax by Tal Hello, Could somebody please tell me why I am getting a syntax error in the subquery. This is my first subquery so... I could have the whole thing upside...	February 12th, 2009 07:08 PM by Tal	2	54
How can I get a data and auto-number field to link? by kmt1984 The database is locked down and really the only thing we can do is query the information. Basically I have an account number in an auto-number field in one...	February 12th, 2009 07:07 PM by John W. Vinson	1	59
Group by date on employeeID by J.J. A previous contributor and I were both led astray earlier so I will modify my question to make it easily understood. The structure of the statement has been...	February 12th, 2009 07:04 PM by John W. Vinson	4	54
character length by Ben Hi all, I am encountering a perculiar problem with Access. I have field called flag and it has three different kinds of value. The field is a text type...	February 12th, 2009 06:59 PM by Ben	2	70
How can I get a data and auto-number field to link? by kmt1984 How can I get a data and auto-number field to link? The database is locked down and really the only thing we can do is query the information. Basically I...	February 12th, 2009 06:36 PM by KARL DEWEY	1	56
AlphaNumeric Values by KW1978 I have a table that contains customer data. I want to flag any record that contains no numerical values in the address field. Does anyone know of an easy...	February 12th, 2009 05:51 PM by KW1978	3	74
Counting Subquery Syntax by Tal Hello, Can somebody please tell me why I am getting a syntax error in the subquery? This is my first subquery, so... could be I have the whole thing upside...	February 12th, 2009 05:50 PM by Tal	0	64
How can I get a data and auto-number field to link? by kmt1984 The database is locked down and really the only thing we can do is query the information. Basically I have an account number in an auto-number field in one...	February 12th, 2009 05:21 PM by kmt1984	0	50
2009/02/04-10:49:12.229510 Any hope of doing math? by Rich Any hope of doing math on this level of precision or do I need to break into tiny bitesize pieces for Access? Need to do this in SQL. Don't know if the...	February 12th, 2009 05:16 PM by John W. Vinson	1	61
Join Query Expression by GMD Trying to join employee data from two tables with the employee names in different order. Table 1 has employee name in this order: Brown,John A; Table 2 has...	February 12th, 2009 05:04 PM by GMD	7	104
Nz or Iif by Kristibaer I am in need of an expression that will return a zero (0) if a field value is null. I tried the following expression, but instead of returning 0 in the null...	February 12th, 2009 04:45 PM by Kristibaer	8	74
Removing leading 0s by AccessIM I am trying to link two tables using the field . My problem is that in one table, the PO # includes leading zeros and does not in the one I am trying to...	February 12th, 2009 04:33 PM by Dale Fye	1	322
value displayed repeatedly by J.J. I have a table that tracks work hours from which I would like to extract the total number of hours worked per person per asignment based on the work order...	February 12th, 2009 03:51 PM by J.J.	9	146
Date range return query by D. Stacy Here is my current Query: SELECT (#10/15/2008#) + TimeSerial(0,,0) AS time_ FROM TblMinPerDay, TblDates; The goal is to generate a list of time records in 1...	February 12th, 2009 02:41 PM by Allen Browne	1	57

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