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 Last Post Replies Views Reverse Sort Order
Aggregating Date Data into Weeks and Quarters by Roger
I want to aggregate date data into weeks of the year. I have checked all date/time function and I can't seem to locate these types of functions. Seems strange...
July 11th, 2004 05:56 PM
by Duane Hookom Go to last post
3 2,081
Why is this strSQL not working??? Please Help by Gina Whipp
If I take out the Dlookup part all is well but I really need that Dlookup. Can someone explian why? Const strSQL = "SELECT tblLister.lListerID,...
(Multi-page thread 1 2 3 ... Last Page)
February 28th, 2007 04:29 AM
by Gina Whipp Go to last post
37 2,062
MS Access Database - Chinese Characters by Jose
When we load data from Excel using a MS Access 2000 database and it is open with MS Access 2000, we get chinese characters in one column after running...
April 13th, 2005 10:05 PM
by Jose Go to last post
2 2,060
Need Help with Totals Query by SSi308
I have a table with daily call records. The table includes fields for: Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed; Locale;...
(Multi-page thread 1 2 3)
May 20th, 2010 09:47 PM
by John Spencer Go to last post
24 2,032
adding 2 fields including null entries by Jesse
I'm working on a database which has 2 fields which each hold a name from a list of names in a table. The 2 fields represent the same thing in the big picture...
(Multi-page thread 1 2 3)
January 18th, 2005 05:31 PM
by Ted Allen Go to last post
26 2,019
How can I Automate a complex update process involving 3-4 tables?. by efandango
To some of you experts, it may be small change… but, To me this problem is complex and is beginning to hurt… I have tried various methods of doing...
(Multi-page thread 1 2 3 ... Last Page)
May 29th, 2008 01:19 PM
by strive4peace Go to last post
31 1,983
pass-through query link to local table by PJ
How do I link a local table to a pass-through union query? I'm accessing multiple tables via a pass through query, but I want to also link to a local table...
January 10th, 2007 12:25 AM
by Ted Allen Go to last post
4 1,979
A Great Big Thank You! by Daniel[_20_]
Firstly, let me apologize for making this beautiful cross-post. I know it bad etiquette, but in this instance I'm hoping no one will truly mind (after all...
(Multi-page thread 1 2 3)
June 1st, 2010 07:07 PM
by Albert D. Kallal Go to last post
22 1,955
Big number gives error! by Sara Mellen
I have a query (which leads to a report) that has been working great for about 3 years. One of the fields in the ORDERS table is the BrokerOrderNumber, a long...
October 11th, 2004 02:48 AM
by Ken Snell [MVP] Go to last post
8 1,937
SQL view of messed up action queries by Kendra
I really appreciate your kindness in helping me out. Here is the SQL for the action queries (if it clarifies things): SQL of append query...
August 31st, 2004 09:53 PM
by John Spencer (MVP) Go to last post
2 1,937
winning streak query by pat67
I have a table that has results on it with a winner and a loser. what I am trying to do is get a winning or losing streak query based on date and game id....
(Multi-page thread 1 2 3 ... Last Page)
January 14th, 2010 12:42 AM
by Clifford Bass via AccessMonster.com Go to last post
30 1,915
Integrating the code for a max.date function with a check box controlling it and by Chris W via AccessMonster.com
Hi all I have a problem with integrating some code I received via a previous post for linking a check box to a max.date function: this is the max date...
(Multi-page thread 1 2 3 ... Last Page)
October 17th, 2005 04:46 AM
by Ken Snell [MVP] Go to last post
31 1,895
Union Query Not Returning A Value by Jeff G
I have five union queries that pull information from other queries of different years related to specific project managers. All of the original queries are...
October 19th, 2004 05:47 PM
by Jeff G Go to last post
2 1,876
AT WITS END ON QUERY TOTAL by lmiller
I want to thank anyone in advance for any insight into this. I have posted this question a couple of times and have been working on developing this query...
(Multi-page thread 1 2 3 ... Last Page)
February 16th, 2010 10:15 PM
by KARL DEWEY Go to last post
34 1,864
How do I print the details view by David
When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print...
August 28th, 2004 12:17 AM
by David Go to last post
5 1,860
Update - If statement by Dan @BCBS
My data is Y or N, I need to Update the data to: If "Y" then -1 Else If "N" then 0 Else NA.. Can I add an experssion to do this, if so, what would it look...
(Multi-page thread 1 2)
December 14th, 2004 06:02 PM
by Ken Snell [MVP] Go to last post
13 1,845
Determining EVERY month between 2 given dates by Edwinah63
Hi everyone, I have a table with the following data upon which I would like to report: SomeDt SomeValue 1-sep-09 100 12-dec-09 ...
(Multi-page thread 1 2)
May 18th, 2010 12:02 PM
by Edwinah63 Go to last post
17 1,838
Expression exceeds 1,024 character limit... by JBHansen
"The expression you entered exceeds the 1,024-character limit for the query design grid." I just saved a make-table query with a new field name and evidently...
April 15th, 2006 02:50 AM
by JBHansen Go to last post
4 1,838
Better "Join" vs "Where" clause? by [email protected]
2003, 2007 At the EOD, it appears that a WHERE clause accomplishes the same data set as an Join. What are the benefits of one over the other? Also, it...
(Multi-page thread 1 2 3 ... Last Page)
March 6th, 2009 01:40 PM
by Michel Walsh Go to last post
37 1,826
HELP: Update 1 table with calculated fields from another table by Samora
Hello I have a form who have 10 fields from TABLE1 that after make calculations with them i build the field M1 from TABLE2 The event that fires those...
May 23rd, 2004 05:16 PM
by Samora Go to last post
0 1,823
Post New Thread


Display Options
Showing threads 41 to 60 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 05:14 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.