Running & Setting Up Queries - Page 1058

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
Enter Parameter Value dialog by Phyllis I've built the following expression to add two calculated fields in the same query with an IIf statement. When I run the query, I get the Enter Parameter...	January 5th, 2007 12:23 AM by KARL DEWEY	1	73
Query Problem by [email protected] Hello I have something wrong with my query and i can't seem to find it I want to select put a position number on each of the rows based on "Completed" date I...	January 5th, 2007 12:12 AM by giorgio rancati	9	142
Nest IIF in Access 2002 by Ralph Any ideas why this doesn't work? the first if executes but the second two do not. UseAddressFull: IIf("UpdateAddress1" Is Not Null, & " " &...	January 5th, 2007 12:04 AM by Douglas J. Steele	2	96
Problem combining count function and date criteria by Tim Long Hello, I have a set of clients who are at various stages. In the customers table each stage reached is indicated by a date field: 'Inquiry received', 'Return...	January 4th, 2007 10:13 PM by Tim Long	3	112
INSERT UNION QUERY by Regan via AccessMonster.com Hi, i'm wondering why my insert query isn't working. if i take away the 'INSERT INTO' bit, it selects the right records to insert. But when i put INSERT INTO...	January 4th, 2007 10:09 PM by Regan via AccessMonster.com	3	87
Filter query using checkbox and IIf function by Jonathan Bickett Hi everyone. I am trying to filter my query using a checkbox on a form. In the criteria of a binary field on my query, I am using an IIf statement. If the...	January 4th, 2007 09:46 PM by Jonathan Bickett	2	88
create() is to DDL as select() is to ??? by surf Can some one help me out with the subject matter here, I was asked in an interview and didn't know the answer.	January 4th, 2007 09:07 PM by Douglas J. Steele	1	78
make field accept zero in a crosstab query by mjps I have a crosstab query that is showing blanks for certain cross-section of the query because the data is non-existent. I need to force a zero so I can sum...	January 4th, 2007 08:07 PM by John Spencer	3	74
YTD Subquery problems by equalizer I am trying to create a report that allows the user to select a specific month and year for which to see MTD and YTD sales figures for specific products. It...	January 4th, 2007 07:16 PM by equalizer	4	111
Change Field Value Depending on Date by Achez I did a look around this group to see if there was already an answer to this question...a few were similar, but I couldn't see one that addressed this directly...	January 4th, 2007 07:06 PM by KARL DEWEY	1	88
Limit Records Using Table by Ripper I have qryCounter counting CourseNumbers from tblRegistration. The Course numbers come from tblCourses which includes a limit on the number of attendees to...	January 4th, 2007 06:40 PM by Michel Walsh	1	77
SQL How-to question by [email protected] Suppose I have the following data: student quarter grade ------- ------- ----- Jones 1 A Jones 2 B+ Jones ...	January 4th, 2007 06:18 PM by [email protected]	7	131
Opening Query in Design View by BBran Hello, I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access...	January 4th, 2007 05:53 PM by BBran	0	58
table population via form & query by [email protected] I have a form that I use to populate a table. It works fine after the first entry has been made but not for the first entry. I'm using a formula,...	January 4th, 2007 05:53 PM by [email protected]	2	77
Design View by BBran Hello, I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access... ( 1 2)	January 4th, 2007 05:50 PM by BBran	18	232
Query to group, then get values associated to smallest grouped number by [email protected] Hi, I asked this question a couple of months ago, and got a few replies but I was unable to get the Access SQL/Query to work correctly in the database...	January 4th, 2007 05:48 PM by Michel Walsh	1	118
Combine Fields by FrankM OK, this may be simple but I'm going crazy and can't figure it out. I have a Query that displays three fields, ID1, ID2 and ID3. I want to create a new Query...	January 4th, 2007 05:44 PM by FrankM	2	86
Join Yields Unexplainable Results by Tonk Dear NG, I'm very new at queries, and as you'll see here in a second - my queries show it! I've created 3 queries to do what I feel certain can be...	January 4th, 2007 05:18 PM by Michel Walsh	1	69
Percentile function in MS Access by [email protected] Hi All, I've reviewed a number of posts dealing with Percentile in these groups, and I'm still confused. The one I came closest to acheiving a level of...	January 4th, 2007 04:51 PM by Michel Walsh	2	119
Subquery in crosstab Pivot ... In clause by HartJF Are subqueries allowed in the In portion of a Pivot clause? When I attempt to use a subquery, I receive the message "Crosstab query contains one or more...	January 4th, 2007 04:30 PM by HartJF	2	185

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