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
....not a valid name error when using ODBC connection between msac by Lloyd
I am trying to link to tables in a SQL2005 database from MSaccess 2003. The link table dialogue works fine until I get to the point where it displays the...
March 6th, 2009 12:41 AM
by Lloyd Go to last post
0 86
...cannot use a calculated field in a Where clause... by Need2Know
Hello Everyone, Still stumped with a problem I've been trying to resolve since last week. I've posted here before and received excellent assistance but now...
November 11th, 2009 03:28 AM
by KARL DEWEY Go to last post
2 177
...efficient method of finding closest date between unrelated tables by Need2Know
Good Morning All, Is there a more efficient method of finding closest date between unrelated tables? Any assistance provided is greatly appreciated. Thank you...
November 5th, 2009 01:14 AM
by Marshall Barton Go to last post
8 293
...lost question...??? by Richard
Dear administrator(?) I have posted a question regarding "selecting only one record from a query". I got a reply - answer. There is a question "Did this post...
August 16th, 2004 08:16 PM
by John Vinson Go to last post
2 385
...OK, I'M STUPID, PLEASE HELP! by Brad Hodges
I have a class of students who on graduation receive a title modification. I'm trying to create an update query to my main table concatenating "MR" to the...
September 16th, 2009 08:08 PM
by Brad Hodges Go to last post
9 134
...The Ol' NULL Statement... by Popparod
....LoL....if I could get just ONE to work.....! .....here's my dilema..... ....I need an Is Null statment to that say's "No Data" if theres of course "no...
(Multi-page thread 1 2)
December 13th, 2004 06:34 AM
by John Vinson Go to last post
12 227
.adp Query with a function? by jyeaman
Hi, I am working with an access data project from a SQL 2005 database. I have a query that pulls two different letter grades for a student and then using a...
December 17th, 2008 03:07 PM
by Michel Walsh Go to last post
1 61
.wdb to access by cut this out
I use Office 97 which meets all my modest needs but I'm receiving more and more files in Works formats because it is being so widely shipped with new pcs. Are...
November 23rd, 2005 04:27 PM
by Duane Hookom Go to last post
5 95
0.00's in Columns Help by Ned Lottsa Help
Hello, I have a table where there are 0.00's in column one and 0.00's in column two. when I run my query, I want to be able to see the information without...
November 4th, 2006 02:21 AM
by John Vinson Go to last post
3 75
0.6737418 Want It? ... 0.1289939 by [email protected]
2.881676E-02 Want It? ... 0.5949273 0.6737418 Now Visit http://www.clicklinknow.com/dating/ 0.1289939
March 29th, 2009 09:03 PM
by [email protected] Go to last post
0 101
0.7421979 Feel Curious Now? ... 0.8556474 by [email protected]
0.7808781 Feel Curious Now? ... 5.186081E-03 0.7421979 Now Visit Tobacco Is Drugs 0.8556474
May 9th, 2009 03:23 AM
by [email protected] Go to last post
0 108
0.8097016 Take A Peek Inside 0.1194602 by [email protected]
0.1901844 Take A Peek Inside ... 0.2435911 0.8097016 Now Visit http://www.clicklinknow.com/ss/ 0.1194602
July 29th, 2007 11:18 PM
by [email protected] Go to last post
0 57
0.8194727 Now Click Here To Have It ... 0.9075145 by [email protected]
0.1745477 Now Click Here To Have It ... 0.1078687 0.8194727 Now Visit http://www.clicklinknow.com/dating/ 0.9075145
March 29th, 2009 08:51 PM
by [email protected] Go to last post
0 104
0.9969174 I Want To Look In Here ... 0.9394656 by [email protected]
0.3774002 I Want To Look In Here ... 0.7980173 0.9969174 Now Visit http://www.clicklinknow.com/ss/ 0.9394656
July 22nd, 2007 02:06 PM
by [email protected] Go to last post
0 134
01 Hosting Web www.ivys.es by tesddalws
Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web...
November 4th, 2009 11:50 AM
by tesddalws Go to last post
0 126
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right by TomT
Hi, I have an MS Access app (2003), which uses pass thru queries to retrieve data from a SQL 2005 database. A number of these queries, when run, create...
October 28th, 2009 01:25 PM
by David Go to last post
8 193
1 day from becoming overdue and or past due records at the top by Iram
Hello. I have a continuous form with about 10 fields. Of those there are three fields in particular that I need help on... "Date Created" "Field1DueDate"...
November 3rd, 2008 07:50 PM
by Iram Go to last post
4 70
1 Field and 2 Criteria by jace
I'm new to Access but very fluent in Excel so bare with me on this. What I have is a query I'm trying to create where I have a Problem Code(numeric) and a...
December 20th, 2009 11:01 PM
by jace Go to last post
2 138
1 Field into two this one is tricky by Heeeeelppp
I am trying to split an 11 digit field into two fields. I have succeeded with doing this however not every field has 11 digits some of them are 9 and that...
December 4th, 2008 06:07 AM
by Heeeeelppp Go to last post
4 68
1 query 2 tables by wftech
I want to query 2 tables from 1 form. the query SELECT ., ., ., ., . FROM STUDLIST INNER JOIN SignedOutEquipment ON .=.; Works fine and the query
November 13th, 2009 08:21 PM
by wftech Go to last post
2 155
Post New Thread


Display Options
Showing threads 341 to 360 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 08:24 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.