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 causing Access 200 Crash by Tobias
This query is causing Access 2000 to crash on most but not all of our PC's. Access closes with an XP error with the option to send to MS or not. Strange,...
January 9th, 2007 09:26 PM
by Jerry Whittle Go to last post
3 102
January 9th, 2007 09:21 PM
by Jerry Whittle Go to last post
1 146
how do I avoid "expression too complex" error with nested IIf? by Yamou
I have about 20 parameters and can't seem to fit them all in one nested iif expression. Is there a way to create an expression that would cycle through those...
(Multi-page thread 1 2)
January 9th, 2007 09:17 PM
by Yamou Go to last post
10 217
Append Query Question by Ryan Clair
Simple problem: Today is the 9th. I need to be able to append a record for everyday since the first of this month to yesterday. Now heres the thing, it won't...
January 9th, 2007 09:15 PM
by Jeff C Go to last post
1 94
How do I export stored procedure results to excel? by Sunny
Hi, I have written stored procedure, which accepts input and produces results set depends on input parameter. How can I pass parameters to stored procedure...
January 9th, 2007 08:36 PM
by Douglas J. Steele Go to last post
1 100
Running 2 queries by Pammy
I have created one complex query on our employees database and then another query off of that one, it is very involved. My question: is there a way I can...
January 9th, 2007 07:26 PM
by Mackster66 Go to last post
1 121
Different results same query by BAC
Win XP Pro, Office 2003 pro I created an Access query using the query grid to read an ODBC database: SQL WHERE as follows: WHERE...
January 9th, 2007 06:26 PM
by BAC Go to last post
0 91
Eclude dates by MPAVLAS
I have a small database that contains target dates for when vehicles should be completed. I am trying to make a query that returns only entries with dates...
January 9th, 2007 06:10 PM
by KARL DEWEY Go to last post
2 108
"The setting for the ListRows property must be from 1 through 255" by Nick Pullar
Hi there First question, so please be gentle. I have created a database in Access 2007, which all works really well. However, for some of my queries, when...
January 9th, 2007 05:46 PM
by Klatuu Go to last post
4 482
Not enough space on temp disk - Query by BFike
I receive this message when trying to run a query that reads some fields from a table and the remaining fields are either from other queries or calculated...
January 9th, 2007 05:43 PM
by Jerry Whittle Go to last post
4 103
Expression Too Complex by ACWOKING
Here's one for you !! I have a large data set of figures 200 000 deep and with 59 columns. The columns represent each product and the rows represent...
January 9th, 2007 05:30 PM
by John Spencer Go to last post
2 123
accessing a linked dbase IV file is slow... by Brad Pears
I have an access 2000 app that uses a linked table to an older application built in dbIV. I have a combo box whose record source property is set to an SQL...
January 9th, 2007 04:59 PM
by Brad Pears Go to last post
0 98
Please Help with query DISTINCT by Elena
Hi All, I have MS Access 2003, i need to print report which looks like Summary CrossTab: I am using query and it doesn't work I am new to query design, please...
January 9th, 2007 03:35 PM
by Elena Go to last post
4 114
Random Random Random Query or Make Table HELP PLEASE by Hansford cornett
I have a table that has 25 Team Names in it. I use the well know Select Random Query process to make a new table (TableTop10) to return only the TOP 10 Team...
January 9th, 2007 02:20 PM
by Hansford cornett Go to last post
2 123
RunningSum in a Query? by George
Dear gurus, need your help on the following issue: I have a table in which I have the fields: Amount and Quanity. I want using a query or programming to...
January 9th, 2007 01:45 PM
by John Spencer Go to last post
7 132
Count in Query by David M C
I have two tables: WorkOrder: WorkOrderID (Primary Key) JobNumber OrderDate Deadline CompletionDate Status
January 9th, 2007 12:13 PM
by David M C Go to last post
7 147
Trying to find a single quote (') within text by Ken King
We are using an application called MRI on top of MS SQL 2000 database. I am trying to find a quote character within a text field using like '%'%', but get...
January 9th, 2007 11:51 AM
by Gary Walter Go to last post
3 144
Convert SQL query into Access query by [email protected]
I am trying to change this sql statment into a an access sql statement. I am not sure how convert the where statement "where c.ClientID not in (Select...
January 9th, 2007 11:51 AM
by Ken Sheridan Go to last post
4 103
My Eyes Are Crossing by Gwen H
I have a query that is selecting no records, and I can't figure out why. It involves two tables, "activities" and "activitiesABM_Temp". I want the query to...
January 9th, 2007 02:13 AM
by Van T. Dinh Go to last post
3 98
Framed Option Group / Nested iif Question by Flora M
Hi All, I have created a framed option group called fra_cost in my form called frm_search_criteria. In the option group there are three toggle buttons...
January 9th, 2007 12:50 AM
by Marshall Barton Go to last post
3 186
Post New Thread


Display Options
Showing threads 21061 to 21080 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 11:16 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.