A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
'new record' grayed out in query by Mary
Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now,...
December 1st, 2009 11:13 PM
by Mary Go to last post
0 182
'new record' grayed out in query by Mary
Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now,...
December 1st, 2009 11:13 PM
by Mary Go to last post
0 186
'No Current Record' error in Group By query with outer joins - SOLUTION by Allen Browne
This problem has been posted several times without a solution. This post is really so that anyone seaching at groups.google.com can find an answer. JET can't...
September 8th, 2005 05:12 AM
by Allen Browne Go to last post
0 162
'NOT IN' vs ' ALL' by Sarah
greetings to all An SQL fragment I use is... WHERE tblValues NOT IN (SELECT ... The query runs properly. I have noticed that I can get the very same output...
February 14th, 2010 11:00 PM
by Sarah Go to last post
4 167
'Not in' Query by John
Hi, I have a few tables and want to run a query, but am not sure how the sql will work out. I have a table that has a list of students, and a results table...
May 24th, 2004 05:16 PM
by Newbie Go to last post
2 850
'Not In' query not seem to be working by John
Hi Access 2000 SP3. I have a Clients table which has 5400 records.When I run the below query to return all records in Clients table that have matching keys...
September 7th, 2008 10:33 PM
by Ken Sheridan Go to last post
6 110
'Not In' Query Slow - What are my alternatives? by User 2084
Hi All, I'm teaching myself the basics of database design using Microsoft Access. I have a query that is really slow for large data sets. I was hoping someone...
April 25th, 2005 08:54 AM
by Van T. Dinh Go to last post
2 72
'On The Fly' Queries by Martin
Hi I am trying to create a query that can be updated 'on the fly'. What I want to happen is for the user to select an option from a pop-up box and then the...
(Multi-page thread 1 2)
August 25th, 2004 09:35 AM
by Martin Go to last post
10 223
'operation must use updatable query' message by mscertified
What is wrong with this query, when run it gives 'operation must use updatable query' message? UPDATE tblSchools SET DistrictID = (SELECT ID FROM...
November 21st, 2008 06:05 PM
by yungmunk79 Go to last post
3 112
'Query must use an updateable query' by [email protected]
Hi, I'm trying to not create temporary tables and nest a query as the value of a update, sql as below. UPDATE SET .RecNum = ( SELECT max( .RecNum) FROM ...
April 7th, 2006 04:19 PM
by OfficeDev18 via AccessMonster.com Go to last post
2 83
'rem' ing a criteria in query by alecgreen
Hi Just wondered if its possible to REM out a criteria in the query design grid? so basically the crieria still there but not actioned. Thanks Alec
March 26th, 2009 03:40 PM
by Bob Barrows Go to last post
2 223
'Second' aggregate function by neeraj
I have two fields Fld1 and Fld2, I want to group by Fld1 and find only the second occurence of Fld2. I know that I can find the First and Last but when I...
April 17th, 2006 06:42 PM
by Tom Ellison Go to last post
1 77
'select all' as option in a query? by Jerome
My users need a query based on 3 criteria: Criteria 1: A, B, C or all of them Criteria 2: A, B, C or all of them Criteria 3: 1, 2, 3 or all of them I'v got...
August 8th, 2006 09:26 AM
by Jerome Go to last post
7 128
'system resource exceeded' and 'query too complex' by AccessMan
I have a query that involves 10 instances of the same query which are daisy-chain-linked to each other via left joins. (I am trying to extract all of the...
November 9th, 2007 02:34 PM
by AccessMan Go to last post
4 67
'Trim' values in a totals query by Kevin Beck via AccessMonster.com
I have a ralatively straightforward query that returns the minumum and maximum cataloging numbers grouped by year. To weed out typos I want to return a trimmed...
July 1st, 2005 05:42 PM
by Kevin Beck via AccessMonster.com Go to last post
2 161
'Type Mismatch' Error- PLEASE HELP by khanner
we have a macro setup to update data info by uploading an excel spreadhseet in the access database. However when i try this, i get a 'type mismatch' error....
(Multi-page thread 1 2)
March 16th, 2010 01:53 PM
by John Spencer Go to last post
13 467
'Un-Crosstab' by colin ashley
I have a table that shows the jobs that people carry out. The column headings are person ID's, and the row headings are job ID's. An 'x' at an intersection...
September 26th, 2004 07:40 AM
by colin ashley Go to last post
2 211
'Update Query' Activation Problem by Chip
Hi, I am just learning ACCESS so this may be an easy fix. I have built a FORM that has a button to activate two 2 "update queries" but what i need is the form...
July 18th, 2004 11:14 PM
by fredg Go to last post
1 88
'update' query not working as supposed in a procedure. by Chris
Hi all, I have a smalldatetime field startDate, endDate. update myTab set endDate = Datedd(mi, 12.56*60, startDate) WHERE (any condition) this works fine and...
December 23rd, 2005 07:17 PM
by Chris Go to last post
1 87
(And) expression by lmossolle
I am trying to use this command i am getting an error; SAT to 1M=IIF(AND(100000,{KT Value]1000000),,"")
October 6th, 2009 07:30 PM
by KARL DEWEY Go to last post
1 94
Post New Thread


Display Options
Showing threads 301 to 320 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.