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 Reverse Sort Order Replies Views
Query Too Complex by cpsaltis
I have nested queries that when run on a local table runs correctly. When I switch the first query to use ODBC tables I get query too complex. If I run the...
July 7th, 2008 11:37 PM
by No Name Go to last post
8 153
Filtering by week by Fredrik
Hello! I have a form with a subform showing orders. Each post have a date (loadingdate). In the mainform I have a Textbox called "tbxWeek" and a...
July 7th, 2008 11:28 PM
by KARL DEWEY Go to last post
2 100
Turning off "null propagation" when adding fields by rdra90
I'm trying to add three numeric fields together in a query. Some of the fields will have null values (in this context, the same a zero) from time to time. ...
July 7th, 2008 11:04 PM
by fredg Go to last post
1 116
Using prompts in a switch statement. by BryanK
Hello, I have setup a switch statement, with the final item, if true, requesting the database user to input a value. I was curious if it is possible to make...
July 7th, 2008 08:12 PM
by Michel Walsh Go to last post
3 109
run-time error 1004 by Larue
Hello, I am getting the following error message when I try to run an Excel macro that is accessing a SQL Stored Procedure via a Pass-Through query in MS...
July 7th, 2008 07:44 PM
by Larue Go to last post
4 129
Limit Rows returned in a query by Nigel
Is there any way to limit the number of rows returned in a query, I have some conditions but I only want the first 5 rows returned
July 7th, 2008 07:12 PM
by Marshall Barton Go to last post
2 115
"Record Deleted" by Pwyd
I'm using a local copy of a database at the moment, however the same problem occurs with the network copy: Since yesterday, anytime i run a Query that has...
July 7th, 2008 07:04 PM
by Pwyd Go to last post
9 183
Updating and Erasing Data by taco
Hi Everyone; It's hard to explain what I need... I have a table. Everyday for once new data is getting stored in it. These latest datas should be transferred...
July 7th, 2008 06:50 PM
by KARL DEWEY Go to last post
2 118
Can you create a table from the output of a query? by BobC[_4_]
Using MA 2007 ... I would like to create a new table from the output of a query. Can this be done ... if so how? Thanks Bob
July 7th, 2008 04:11 PM
by Jeff Boyce Go to last post
7 120
Excel and filter by Ticotion
Hi I have a problem regarding transfering data from a query to excel. The problem is that I need it to be filtered before transfering so it is only the...
July 7th, 2008 04:05 PM
by [email protected] Go to last post
1 169
Query question by Ticotion
Hi I have a cross tab query that gets week no. input from a form. The cross tab should show week number, department and a OEE value. I use the following...
July 7th, 2008 02:04 PM
by Ticotion Go to last post
3 123
Querry with User Input and Search the columns by mario
I want to get the user input and use that string to search if it occurs in any part of three columns in the table. For example, Select ID, Survey_01,...
July 7th, 2008 12:22 PM
by John Spencer Go to last post
2 117
Problem to write a query result in a text file. by Marco
Hello. I have an access database that write several queries result into several text files. It's one query per text file. In a particular one it's happening...
July 7th, 2008 09:51 AM
by Marco Go to last post
3 131
Create Update Query by Dave
I have a number of text files that I have linked to within MS Access. I need to combine these files into one. All files have the same number of columns and...
July 7th, 2008 07:18 AM
by John W. Vinson Go to last post
4 113
Access 2003 INNER JOIN by KC_Cheer_Coach[_2_]
My Inner Join is not working correctly. I have changed it so many times to what should make sense, but my results now fluctuate from 18M records to 0...
July 7th, 2008 07:08 AM
by KC_Cheer_Coach[_2_] Go to last post
5 155
Change field Value using update query by shoeb[_2_]
Hi, I am stuck into a situation where i need to update a value in a field of a table. The situation is like this. I have a table "Device" and...
July 7th, 2008 05:54 AM
by Jeanette Cunningham Go to last post
1 111
How to count a value in a field by dave
Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all...
July 7th, 2008 01:42 AM
by fredg Go to last post
4 138
Query to show ALL by dave
Access 2003 I have a form with several drop downs for the user to use to "filter" for a report. in the criteria of the query I have done...
July 6th, 2008 10:25 PM
by dave Go to last post
2 117
Challenging Date Query help needed by Billy B
I have the following query that displays total distances for each year of my riding statistics. It works correctly. What I would like to do is change it to...
July 6th, 2008 08:40 PM
by John Spencer Go to last post
2 130
TOP in query user selects amount to return by Kevin
Using Top, is there a way to ask the user how many records to return? if not is there another simple way of acheiving this?
(Multi-page thread 1 2)
July 6th, 2008 06:34 PM
by cpsaltis Go to last post
10 218
Post New Thread


Display Options
Showing threads 10061 to 10080 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:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.