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 Reverse Sort Order Views
Simple between and query by faxylady
I am trying to segment a table by the ID. In the criteria row, I put =1=1000. The result was not the entries between 1 and 1000, but all the entries of...
(Multi-page thread 1 2)
August 24th, 2006 08:01 PM
by John Vinson Go to last post
15 231
Create Save Queries by Simon
I was wondering if anyone has ever created a wizard type of tool to allow an end user the ability to create, run, save queries. I don't want the user to...
(Multi-page thread 1 2)
January 4th, 2007 03:38 PM
by Simon Go to last post
15 161
How to retrieve all or patial records by Lou
Good Day, I have a query in which uses a forms combo boxes to set the criteria of the report. I need help with how to get the query to pull the data to the...
(Multi-page thread 1 2)
January 22nd, 2007 08:18 PM
by Klatuu Go to last post
15 164
Like statement by rml
How do I get records returned with the following: Like I would like to have all three records returned in the query. I can't seem to figure it out. How...
(Multi-page thread 1 2)
February 1st, 2007 05:25 AM
by Marshall Barton Go to last post
15 149
Make Multiple Tables via Query by Michael_V
I've tweaked some vb code which streamlines repetitive tasks. Essentially it takes Table1 and parses it into individual tables based upon a list in Table2...
(Multi-page thread 1 2)
February 14th, 2007 02:05 AM
by Michael_V Go to last post
15 268
Sum based on date range by Rohn Everson
I need to measure the tallies in the "SEVERITY" column over the last six months from the date range in the "START_DATE" column. I hope that makes...
(Multi-page thread 1 2)
March 8th, 2007 12:29 AM
by Michael Gramelspacher Go to last post
15 172
CrossTab - parameter with a null response by AFSSkier
How do I pass a parameter with a null response in a CrossTab Query? I have the following SQL. I am unable to get the PARAMETERS right. PARAMETERS Text (...
(Multi-page thread 1 2)
March 28th, 2007 02:50 AM
by AFSSkier Go to last post
15 135
replacing quote marks by Rcarman11 via AccessMonster.com
I need to replace strings that have " marks in them and It keeps giving me an error. I need to delete html tags like a href="testing home page.html" so i've...
(Multi-page thread 1 2)
April 30th, 2007 04:25 PM
by Rcarman11 via AccessMonster.com Go to last post
15 129
Copy Data From an ACCESS form to a WORD Template by Doctorjones_md
I have a Front-End ACCESS db (linked to (3) Tables on a Back-End SQL Server). I have a series of Queries that manipulate the data and populate an ACCESS...
(Multi-page thread 1 2)
May 30th, 2007 07:58 PM
by Marshall Barton Go to last post
15 242
Requerying underlying make table query by efandango
I have a ‘make table’ query that creates a ‘top 10’ record list on a form. How can I allow the user to ‘requery’ the underlying query from within...
(Multi-page thread 1 2)
January 17th, 2007 05:53 PM
by efandango Go to last post
15 168
Sum in Query problem/question by [email protected]
Hello, I am trying to create a query that will sum several lines. Details are below, but I am trying to have several occurances of Open Trades from a table...
(Multi-page thread 1 2)
January 12th, 2007 06:02 PM
by Steve Schapel Go to last post
15 277
Query building Copy and Paste not working by CurtainMary
Since going to 2003, I cannot seem to be able to paste into the Expression Builder or the Zoom window. The only way seems to be to do it in the query...
(Multi-page thread 1 2)
August 25th, 2006 02:38 AM
by Gina Whipp Go to last post
15 154
can a query be converted to a table by Bob Levin
I have 400 names in a table (7 fields)I made a query of 40 names from that table. Can I now make a table from that query. I used the "create table" wizzard...
(Multi-page thread 1 2)
September 12th, 2006 06:24 AM
by John Vinson Go to last post
15 160
Expression to grandfather expiration by date by LMB
Hi Everyone, Access 2000. I don't create my queries using the sql but I know it helps you folks understand what I am talking about. At this point I can...
(Multi-page thread 1 2)
September 11th, 2006 06:56 PM
by Marshall Barton Go to last post
15 219
Get column beyond 255th - Acc2K by Tony
Hi All, I have to pull data for display from a database that has a table with more than 255 columns. The problem is that the data I need is beyond the 255th...
(Multi-page thread 1 2)
September 15th, 2006 03:45 PM
by Tony Go to last post
15 134
Parameter Query prompt - How to let user select all by Astello
I want to set multiple parameter queries, and allow the user to enter a parameter for each of them or to select all if they don't want to limit that field. ...
(Multi-page thread 1 2)
October 11th, 2006 08:20 PM
by Astello Go to last post
15 316
Combining Rows by GMD
Would like to combine rows of data in the following format, everytime a field named P.O changes. In this example, rows below 999-5U0455 would be together on...
(Multi-page thread 1 2)
October 19th, 2006 03:08 PM
by GMD Go to last post
15 172
Update Query needed.... by Bikini Browser
I need an update query written. Are there any takers? It looks hard, but I don't think an experienced query writer will have any problems with it.. Am I...
(Multi-page thread 1 2)
October 25th, 2006 03:43 PM
by Bikini Browser Go to last post
15 111
iIF statements in a query by T Miller
OK, I have some sample data, not real good with IF statements in Access, Need to know if it can be done with the reult I need and how the iIF statement...
(Multi-page thread 1 2)
November 7th, 2006 04:42 AM
by T Miller Go to last post
15 152
Difficulty with Concatenate Function by Mike Diamond
I am having trouble and have been dfor some time with sorting out this issue i am having with concatenating. I have taken a look Duane Hookams example on...
(Multi-page thread 1 2)
July 10th, 2007 12:47 AM
by John Spencer Go to last post
15 154
Post New Thread


Display Options
Showing threads 361 to 380 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 02:41 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.