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
Union Queries by
I've created a union query that feeds a report of combined data. The 2 tables that make up the union query have some Memo fields. When the report is run the...
June 28th, 2004 09:46 PM
by Go to last post
2 154
Append Query Assistance by
My CSRs are each responsible for reviewing their section of the alphabet looking for similarities. To assist them, I need an Append Query that looks something...
March 16th, 2006 01:10 AM
by KARL DEWEY Go to last post
1 77
Append Query Help Needed by
My CSRs are each responsible for reviewing their section of the alphabet looking for similarities. To assist them, I need an Append Query that looks something...
(Multi-page thread 1 2)
March 19th, 2006 12:54 AM
by Go to last post
10 154
Elapsed Time Assistance by
I found the following article and sample DB. http://office.microsoft.com/en-au/assistance/HA011102181033.aspx After importing the module, everything works...
April 29th, 2006 07:37 PM
by Marshall Barton Go to last post
3 141
newbie question can access handle if the & case statements ? by
Hi, I get GetDescription Failed with E_FAIL(0x80004005) then I try to use IF THEN in select statement. can anyone show where I am going wrong with an...
June 2nd, 2006 02:36 PM
by Duane Hookom Go to last post
1 97
newbie question can access handle if the & case statements ? by
Many Thanks and appreicate the quick reply
June 2nd, 2006 02:52 PM
by Go to last post
0 74
question Select statement by
Hi All, when I use the following statement Select col1,col5,0.0,col9,0.0 the datatable shows the zeros as int not currency, how can I ensure the zero is...
June 7th, 2006 07:06 PM
by Gary Walter Go to last post
1 98
RE : question Select statement Many Thanks by
cheers, sorry should have done a search on access function.
June 8th, 2006 06:21 PM
by Go to last post
0 134
Strange query? by
Say I have a list of employee ID numbers and the employees work different days. I have two tables, two columns each. One lists empID, dayNum; the other lists...
August 1st, 2006 05:23 PM
by Duane Hookom Go to last post
3 146
access and sql server via odbc by
When writing a pass-thru query in Microsoft Access to access an sql server via an odbc system dsn, I can write a query like: select * from MyTable However,...
September 29th, 2005 05:08 PM
by Steve Jorgensen Go to last post
1 96
No Subject by
te: Wed, 10 Aug 2005 16:37:40 +0300 From: Nikos Yannacopoulos User-Agent: Mozilla Thunderbird 1.0.6...
October 1st, 2005 01:00 AM
by Go to last post
0 87
Mail recipient by
Hi, I have Access 2002 on XP and when I try to send part of a database via Mail recipient it only attaches the first two lines of the database whether I...
July 7th, 2004 02:53 PM
by Mark Hyland Go to last post
1 146
query ODBC call failed when using a parameter by
This is a bit strange but works fine with access tables but NOT with ODBC. When I create a query using a hard coded value for selection (i.e. = "486-66") my...
July 16th, 2004 07:47 PM
by Go to last post
0 608
Field value contains "#Error" by
when I try to run query that conatains premeter that asks user to enter a value, I get this error: "This expression is typed incorrectly, or it is too complex...
(Multi-page thread 1 2)
July 29th, 2004 07:19 PM
by Go to last post
11 212
Numbers in datasheet view expand on focus by
Hello, In my database i have an invoice amount that the field properties is set to double standard and auto in the invoice table.It is not needed to be in...
August 20th, 2004 02:53 AM
by Allen Browne Go to last post
1 322
Date Range by
Hello, I have an Access table that has a column for both month and year. Is it possible to place in the criteria section just a range such as: Jan 2003 - Feb...
September 22nd, 2004 10:59 AM
by Michel Walsh Go to last post
1 111
how to insert a where clause in Insert Into... statement? by
how to insert a where clause in Insert Into... statement
December 10th, 2004 12:27 PM
by Michel Walsh Go to last post
9 396
week by
Hi. I have an access 2000 table named payments and would like to select all records in which the date in field payment_date falls within the current week. I...
December 10th, 2004 08:49 PM
by Go to last post
0 117
find week dates by
I would like to create sql that retrieves all records where the date in payment_duedate falls within the current week sun. thru mon. I have never worked with...
December 12th, 2004 02:09 AM
by PC Datasheet Go to last post
2 119
"Not a valid password" message by !pro-progammer:)
When I coding "DoCMD.RunSQL 'Select Some Field FROM A Table IN Another Database' " but that database is password protected, I always get "Not a valid...
November 9th, 2007 03:46 PM
by Klatuu Go to last post
4 97
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 10:06 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.