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
"if -- then" criteria in querys. by crossofG
I have a data base that contains family information (address, phone, family last name) and then is related to individuals of that family (first name, last name...
July 21st, 2004 04:43 PM
by Mike Go to last post
1 137
"If the user enters something, return something, otherwise return everything" by Chris Mortimore
I need a expression for a query thinger. The database has 4 possible values for a field called "Voltage", these values are 11, 33, 0 or NULL (NULL being...
September 6th, 2004 03:35 PM
by Chris Mortimore Go to last post
2 187
"IF" expression in a query by Duncan Edment
I have a query that returns the Annual Leave days recorded for a specific employee. This query is as follows: SELECT tblEmp.EmpFname, tblEmp.EmpLname,...
June 11th, 2004 11:38 AM
by Michel Walsh Go to last post
1 428
"Init: Left([Firstname],1)" in Access Qry by DFA
I need to take first letter of Firstname to provide Initial to add to Surname. Have entered above in the field row of a query which has Firstname. Have tried...
June 5th, 2005 09:10 PM
by Steve Schapel Go to last post
2 110
"insert/delete queries" <--- careless parlance ? by André Hartmann
I have a question to you Access guys. In the news group I frequently read terms like "insert query" "update query". When I learned SQL I was taught that the...
August 11th, 2004 07:12 PM
by Rick Brandt Go to last post
3 126
"invalid bracketing of name" when referencing Query Parameter by GreggLund
In Access2003 I have a query that uses the start and stop date that it gets from a form. In the query I have entered the fields in the Query Preference. Form ...
August 23rd, 2007 12:42 PM
by scubadiver Go to last post
8 259
"Invalid Procedure Call" error using DateDiff by Jeff
I'm using the DateDiff function in a query and it works fine until I try to set a filter to only show the records where the difference 0. When I add 0 to...
September 9th, 2004 07:10 PM
by Jeff Go to last post
2 670
"Invalid SQL Statement" message from union query by Alison Downing via AccessMonster.com
Hi there, I've read the Access help files on union queries and trawled the threads on the forum but I'm still stuck and hoping someone can help me out. ...
April 14th, 2005 10:30 AM
by Alison Downing via AccessMonster.com Go to last post
2 242
"Less Than" Query Problem by JTF
I have a form that contains a drop down list, from which the user can select a "period" - from 1-13. I have two update queries that I need to run based on...
August 18th, 2005 05:43 PM
by JTF Go to last post
3 101
"Like" operator in a query by genojoe
In "SQL Server Compatible Syntax" setting in Options dialog; Table/Queries tab, I do not check "This database". In this database the following query returns...
December 28th, 2004 04:35 PM
by Duane Hookom Go to last post
1 118
"LIKE" query problem... by AlexT
Folks I'm having a rather strange problem with a query to an Access file from Excel. My query looks like SELECT qLookups.lkSubkey, qLookups.lkValue FROM...
July 8th, 2005 12:38 PM
by AlexT Go to last post
2 94
"Minus" keyword by Earl Takasaki
I can't seem to get the MINUS keyword to work in Access SQL view. Is this a limitation of using the SQL View to create a query? If so, what other keyword do...
June 16th, 2005 01:27 PM
by Gary Walter Go to last post
3 179
"not enough space on the temp disk" by Jazz
Access query fails saying out of temp space running a query that will create an Excel spreadsheet of 17,000 lines or so. However, after about 20 minutes, it...
August 19th, 2005 03:56 PM
by Jazz Go to last post
1 163
"NOT" criteria by Liz Hansen
Hello, I need to compare two tables. When compared, if an employeeID is missing from the tblDemographics, it should be added using an append query. ...
September 13th, 2004 09:48 PM
by JL Go to last post
2 90
"Null" by DBC
when a numerical query returns empty how do you make it show as 0?
August 26th, 2004 12:44 PM
by Go to last post
4 129
"nz,0" by Todd
I'm using Access 2.0. The query I'm writing requires the sum of 2 fields. If I use the "nz,0" command to make sure the fields add up even if one of the...
June 14th, 2004 08:10 PM
by Duane Hookom Go to last post
1 97
"Operation must use an updateable query" On UPDATE Only by MDW
Hey all, I'm working on Access 2000, linking to a SQL Server 2000 table. When I try to run INSERT commands through Access, everything works OK. But when I try...
May 10th, 2005 07:30 PM
by Ofer Go to last post
1 137
"Operation must use an Updateable Query." - How do I get round this? by John Ortt
I have a table of sales data which I want to summarise into daily sales figures and update a table with. The problem is that if I create the Summary Query and...
November 10th, 2004 01:04 PM
by Michel Walsh Go to last post
1 330
"Overflow" by Art
I get an "overflow" message when running an Access Query, what does it mean? and what do I need to do? Thank you
November 2nd, 2004 07:41 PM
by Duane Hookom Go to last post
1 170
"pivoting" data with a querry by jay
All, I've got a table as follows: I need to generate a combo-box listing each of the five suppliers for an Item Number. I've considered...
August 24th, 2005 12:56 AM
by jay Go to last post
4 144
Post New Thread


Display Options
Showing threads 21 to 40 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 01:41 AM.


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