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 / Thread Starter Reverse Sort Order Last Post Replies Views
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 06:25 AM
by *«Ë²´* Go to last post
0 98
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 05:09 AM
by *«Ë²´* Go to last post
0 83
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 05:09 AM
by *«Ë²´* Go to last post
0 84
Triggers by --
Is it possible to build SIMPLE triggers within Access. I found info on it in the help pages but is all refers to ADO and SQL server....nothing about...
June 7th, 2005 05:35 PM
by Rick Brandt Go to last post
1 76
query field reference help by -dch
I am running Access2002 under Windows XP Pro. I have built a query as a row source for a listbox on a form. The first version of the query is working...
June 2nd, 2004 07:30 PM
by Go to last post
4 1,647
Access data truncation error with decimal data (error 3759) by -eppu-
After just upgrading MS Access 97 to MS Access 2003 my queries that use linked ODBC tables stopped working and now I receive the above error message. I know...
March 21st, 2006 02:57 PM
by -eppu- Go to last post
3 129
Storing OLAP info locally. by -Nate
Hello, I have question about OLAP queries. I have to update about 10 pivot tables in 10 separate .xls files daily. All 10 link to the same OLAP cube...
June 19th, 2008 07:25 PM
by -Nate Go to last post
0 121
Top N Records for a Group by by -PJ
I'm in Access 2003 and have a table where i have match_id and player_id. I'm trying to design a query where I return the last 10 matches for a given...
September 3rd, 2008 07:17 PM
by Dale Fye Go to last post
1 146
Clause order in SQL select query by .Len B
Are there any rules that govern clause order? Does the parser care? Obviously SELECT must be first but does WHERE have to precede ORDER BY? This question...
November 20th, 2009 12:06 AM
by .Len B Go to last post
4 174
Error 3061 by .Len B
The following is in the OnOpen event of a form. It is designed to populate an ocx control in the form. Dim rst As Recordset, stSelCrit As String stSelCrit =...
November 18th, 2009 01:41 PM
by .Len B Go to last post
3 175
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 91
Need a query that does this... by 0to60
Consider the following table: ID dateField intFieldA intFieldB stringFieldA stringFieldB I want a query that will give me the...
November 2nd, 2007 08:28 PM
by Douglas J. Steele Go to last post
2 76
Is there a join that does this? by 0to60[_2_]
I need an INNER JOIN of TableA and TableB, and then I also want the rows of TableA that DON'T have a match in TableB, and then vice versa. So basically...
September 17th, 2008 04:36 AM
by Lord Kelvan Go to last post
2 102
GROUP BY question by 0to60[_2_]
Let's say I have an Invoices table setup and I want to find the most recent invoice date per customer. I'd say: SELECT Customer, Max(InvoiceDate) FROM...
September 11th, 2008 03:30 PM
by John Spencer Go to last post
1 108
surely a form with a ListBox can be used in a query? by 1.156
Fred and Tina were kind enough to try to help in an earlier thread but I'm still getting nowhere. I have a simple query that works fine but the user must type...
(Multi-page thread 1 2)
June 2nd, 2004 04:54 PM
by tina Go to last post
14 1,720
Hold it, we found SQL view.... by 1.156
Fred, we now can see the code -- don't know how we didn't run into it earlier. The SQL code looks understandable for the original simple query with no drop...
May 28th, 2004 03:20 PM
by 1.156 Go to last post
2 984
Date Question... by 116
I am trying to create a query to give me the results from the first weds of each month back to the following day after weds. Having trouble formatting the...
May 18th, 2010 12:36 PM
by 116 Go to last post
5 888
Column for line numbers... by 116[_2_]
Can an expression in a column be used to generate line numbers? 1, 2, 3, etc. Thanks David
March 10th, 2010 11:12 PM
by 116[_2_] Go to last post
5 278
Query Question... by 116[_2_]
I have 2 tables...Job and Material. I am trying to configure dlookup to return value of 'Note_Text' in table 'Material' based on 'Part_Number' in table...
April 7th, 2010 06:08 PM
by 116 Go to last post
4 167
Query appears to be empty in Word document by 1284
Hi I have created a query, which contains 15 records. it is up and running Now I've made a ltter wchich should be send to this 15 people. Only instead of...
October 26th, 2006 03:00 PM
by 1284 Go to last post
0 69
Post New Thread


Display Options
Showing threads 61 to 80 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 06:10 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.