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
"invalid operation" in query by JoanneB
I'm using Access 2003 with XP and seem to have the most recent service pack. I'm running a series of queries which make a table, then append to it. Several...
December 28th, 2007 04:25 PM
by JoanneB Go to last post
5 90
"Invalid scale" error during Crosstab by Bruce Meneghin
I received the error "Invalid scale for decimal data type" while trying to execute this crosstab query (created with crosstab wizard) TRANSFORM...
October 10th, 2007 11:22 PM
by Bruce Meneghin Go to last post
2 88
"Invalid use of Null" in query by Rob Parker
I have a query which has suddenly started giving this error. It is based on two other queries, each of which run OK. The query contains 4 left joins (I'm...
December 10th, 2009 04:37 PM
by Jeff Boyce Go to last post
3 83
"Invisible" Columns in ACCESS table by Harry V
I have a table that I've imported to Access 2002 SP3 from SQL Server 2000, and I cannot get two of the columns to display. I've looked in the design window...
October 3rd, 2006 08:11 PM
by Harry V Go to last post
2 59
"is not a valid name. Make sure... by AndrewB[_2_]
I just started getting the error message: "is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too...
March 15th, 2010 07:13 PM
by Scott Go to last post
5 255
"is not a valid name. Make sure by Scott
I just converted several my Access Databases to Access 2007 and I am getting the following error message on 2 of them: "is not a valid name. Make sure that...
March 18th, 2010 07:21 PM
by J_Goddard via AccessMonster.com Go to last post
8 235
"join" and "sum" over 3 tables by Joe Koenig
Hi, sorry if this question is a tad bit lame, but I ran out of practice re SQL and and can't seem to solve this on my...
March 15th, 2007 10:14 AM
by Michel Walsh Go to last post
1 77
"Joining" multiple queries by JMK
Hi All, This is simple, and I know I have found the answer myself in the past through trial and error but after days of searching the answer is no closer to...
October 1st, 2008 08:13 PM
by Lord Kelvan Go to last post
3 69
"last" command problem by Stan
Hi. I have a database that keeps patient followup information for outcomes after treatment for cancer. One of my tables has multiple rows of data (toxicity...
August 5th, 2007 09:03 PM
by John Spencer Go to last post
5 117
"left function " problem??? by [email protected]
For some reason my home copy of access2003 wont let me use the following criteria in a query but it seems to work fine at the office. the error message states:...
May 16th, 2006 10:43 PM
by Wolfgang Kais Go to last post
3 80
"Like In" query operation...? by Mark Burns
Just a question - not really a pressing issue, but I was wondering something based upon somebody else's question in the .forms section. Field Data...
January 30th, 2006 05:08 PM
by Mark Burns Go to last post
2 47
"like" and "*" problem by ghost
Greeting, I have a query that has there fields, idnumber, fristname and lastname. In this query , I put the following criteria by using "like" and "*"...
January 27th, 2008 06:47 PM
by Ken Snell \(MVP\) Go to last post
6 118
"like" works as query, but not in code (Access 2003) by [email protected]
In my Access application I'm fetching data thru SQL statements, and not directly thru a RecordSet object. In my statements, such as select count(*) as...
September 20th, 2007 08:19 AM
by Jamie Collins Go to last post
5 86
"locked" query by Don
Hoping someone can help this novice! I have created a query that is based upon two separate tables. In one table "tblReviewTasks" I have a field . In another...
June 4th, 2008 03:18 AM
by Ken Snell \(MVP\) Go to last post
3 78
"Make Table" Issue by Bob Barnes
I have a "Make Table" Aggregate Query which is not producing the same data consistently. Are there any known issues doing this? Never had to before, but if I...
June 2nd, 2007 12:25 AM
by Bob Barnes Go to last post
6 58
"microsoft office access" unknown error by jcandamo
I'm getting a "Microsoft office access" unknown (error with exclamation mark) when opening a table in a MS Access 2003 database. The error happens in one...
July 9th, 2009 09:01 PM
by jcandamo Go to last post
1 82
"Modulas" Function by aMack
In Excel there is a "MOD" function which is described as "find the remainder from wholly dividing an amount by a variable" Is there such a thing in...
November 23rd, 2006 12:24 AM
by Brendan Reynolds Go to last post
8 106
"negative" query by Stephanie
Hi. I'm trying to find all the locations that did NOT have incidents reported. All I can seem to bring back is those locations that did report incidents. I...
August 3rd, 2009 04:18 PM
by KARL DEWEY Go to last post
5 60
"nested" crosstabs? by PerryW
Need help here! Have a PR database, with the following fields: EmpID, EmpName, EmpElig, S/H, Date, Hours, Type. I need a crosstab that may actually be a...
July 25th, 2007 09:16 PM
by PerryW Go to last post
0 33
"networkdays" by anandharan
We already made a function on those cells for 'Networkdays' and have given proper ranges also and it is working fine. But whenever we go to the particular...
August 8th, 2006 08:11 AM
by anandharan Go to last post
0 34
Post New Thread

Display Options
Showing threads 201 to 220 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:48 AM.

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