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
Access DDL/DMO?? by Ivan Debono
Hi all, Is it possible to create foreign keys, indexes, drop & create queries using SQL with an Access 2000 database? Thanks, Ivan
September 6th, 2005 03:29 PM
by Ivan Debono Go to last post
2 108
Access Deleting a Query SQL by michelleumich
Hi all, I am working with a multiple parameter search query. The form I am using to conduct the search displays the results in a subform. I have gone through...
July 12th, 2007 06:40 PM
by michelleumich Go to last post
0 62
Access Deleting a Query SQL by michelleumich
Hi all, I am working with a multiple parameter search query. The form I am using to conduct the search displays the results in a subform. I have gone through...
July 12th, 2007 06:44 PM
by michelleumich Go to last post
0 61
Access Deleting from MSDE - Help!! by Tom
Hi I am a newbie to MSDE and am having a problem deleting records from an MSDE backend using an Access query front end. Our main data is stored on a UNIX...
(Multi-page thread 1 2)
April 17th, 2005 09:15 AM
by Tom Go to last post
11 288
Access Discussion Group by jcinn
Can the Office Discussion Groups listed on the left sidebar be reformatted into a drop-down listing? It is very difficult to search the discussion threads for...
February 9th, 2005 05:16 PM
by Michel Walsh Go to last post
1 150
ACCESS doesn't like the brackets by Nishant Shah
What's wrong with my statement? ACCESS doesn't like the brackets - even when I remove the brackets before and after the "!" ? Please help.. =!! And !!+1...
September 7th, 2006 07:07 PM
by KARL DEWEY Go to last post
3 61
Access Dsum function help by Nate
I have been having trouble breaking this function for my query. I have 2 columns, date and amount. I need to sum the amount for one year for day one. I then...
July 12th, 2006 07:00 PM
by Klatuu Go to last post
1 125
Access due dates by Sue at WaMu
designing query for "off calendar"; have due date expressions working correctly - time frame is within one month, so need to add to expression that due dates...
February 1st, 2006 12:06 AM
by Jeff Boyce Go to last post
1 65
Access duplicates query by mehstg1319
Hi people I have an access query I am trying to implement in a database....due to the nature of the data it is selecting...there will be duplicate entries...
December 16th, 2008 06:02 PM
by John Spencer Go to last post
3 65
Access equiv. of Excels =Search("_",A1) by Duncan
When reducing UK Postcodes from unit postcode MK19_1PY to Postcode Sector MK19_1 I used to use =Search("_",A1) to identify the position of the blank in the...
October 8th, 2004 05:44 PM
by Douglas J. Steele Go to last post
1 75
Access Equivalent for SQLBASE Query by shar
What would be an equivalent Access query for this SQLBase query? select , ln.warehouse_id), co.warehouse_id ), 0, from...
April 13th, 2006 03:34 PM
by shar Go to last post
4 90
Access equivalent of Excel's Product() by [email protected]
Excel has a cell formula called Product() that can operate on a list of varying size. Basically I'm looking for the equivalent for an Access query. I haven't...
April 23rd, 2008 09:06 PM
by [email protected] Go to last post
2 133
Access equivalent of str_replace() function by Don Hicks
Hello, Is there an Access equivalent of the str_replace() function? Here's my dilemma: In an Access '97 table, I have a text field containing item...
August 13th, 2004 06:10 PM
by LeAnne Go to last post
3 205
Access equivalent to Excel's VLookup function by john431
I’m looking for the equivalent in Access of the VLookup function in Excel, when the lookup value is between values in the value lookup column. I want...
(Multi-page thread 1 2)
March 13th, 2006 08:11 AM
by john431 Go to last post
10 244
Access error message by sloan
I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to...
October 25th, 2005 05:59 PM
by Vincent Johns Go to last post
4 121
access error msg "the search key was not found in any record" by PRICEY
I KEEP GETTING THESE ERRORS 湡慣桳物 IN MY DATABASE AND THIS ERROR MESSAGE APEARS WHEN I TRY AND DELETE THE RECORD OR FORM the search key was not found in...
May 11th, 2005 04:50 PM
by Chaim Go to last post
2 129
Access errors out when query by ascending by Kevin
I have the below code in my query and want it to sort by ascending not descending. Everytime i change it to Ascending in the design view not the code view...
December 3rd, 2008 06:40 PM
by John Spencer Go to last post
1 79
Access Export to Excel worksheet by Ken[_3_]
I have two tables that I wish to export to a single worksheet in Excel. The first table is called Travels which includes Trip Number, Travellers name, total...
March 13th, 2007 04:14 AM
by Ken[_3_] Go to last post
0 112
Access Expression by ft
I'm trying to convert the results of an expression but I can't seem to get it right and I don't know if its possible to do the way I'm going about it. I also...
(Multi-page thread 1 2)
October 16th, 2006 03:32 PM
by ft Go to last post
10 119
Access Expression by James K via AccessMonster.com
I would like to construct a query from a table with a debtor name field. The select statement needs to exclude all records that have the word Corp, CO, Ltd,...
August 27th, 2005 04:38 PM
by John Spencer (MVP) Go to last post
2 109
Post New Thread


Display Options
Showing threads 1041 to 1060 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 09:08 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.