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
How a multiparameter query returns all records if all r null? by INM
How can I make a multi-parameter query returns all records if none of the parameters is specified? What the help suggests works only if the query has only one...
September 6th, 2005 03:09 PM
by Brendan Reynolds Go to last post
1 72
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
Number of fields within a table by John Palm
Hi there, Is there a way (function) to check the number of fields in a table by a query? Thanks for any reply, -- John The Netherlands
September 6th, 2005 04:15 PM
by Allen Browne Go to last post
1 88
Total in a Crosstab Query by bbishop222
I created a Crosstab Query that sums amounts by year for a given number of years. I want to sum the years for each action that I have listed. I've been...
September 6th, 2005 04:49 PM
by Duane Hookom Go to last post
1 82
IN (Select ... ) in Query criteria by Cydney
Can someone please explain to me how and when to use an IN(Select ... ) statement in the criteria grid of a query? I've seen it used, but I don't understand...
September 6th, 2005 05:00 PM
by Cydney Go to last post
2 67
QUERY QUESTION by anill
Hi I use MS ACCESS 2000 and I would like to help me with a Query. I would like to find from all my products all the prices from 400 to 799. How I can do that...
September 6th, 2005 05:49 PM
by John Vinson Go to last post
2 75
Delete query by Nick
I want to Delete data that is 548 days from Date() on close in a form. I can create a query statement Date-548 but how do I get the delete part?
September 6th, 2005 05:52 PM
by John Vinson Go to last post
3 76
Help with Update statement by Net
Here is an Update statement: UPDATE Sample, Main SET Main.State = Sample.State, Main.ST = Sample.ST WHERE Main.BU=Sample.BU And Main.Desc=Sample.Desc ; How...
September 6th, 2005 08:12 PM
by George Nicholson Go to last post
1 63
query - sum up and assign records to category by Flemming
Help me!!!! i could not even give a descriptive subject.... :-( I do not know if one or two queries is enough to solve my problem or if i need some...
September 6th, 2005 09:17 PM
by [MVP] S.Clark Go to last post
1 71
analysising ages in database. by Andre C
I have a list of clients all with dates of birth. I can create a querry that will calculate their exact ages fine but I want to analysis this in a chart...
(Multi-page thread 1 2)
September 6th, 2005 09:27 PM
by Duane Hookom Go to last post
11 173
Passing Active Form Name to Report Input Parameter (ADP) by Aad v via AccessMonster.com
Hi Access Profs, I create a report which has a stored procedure as control source. To select the right record for the report, the ID of the active record...
September 6th, 2005 09:32 PM
by Aad v via AccessMonster.com Go to last post
3 166
Return Earliest Date by Alex
I have a query with the following fields: dateA, dateB, dateC, dateE, dateF 1/1/05, , 2/1/05, 6/15/05, 12/5/04 , ...
September 6th, 2005 09:47 PM
by Chaim Go to last post
2 113
Count groups by Bonnie
Hi Folks, I'm looking for some advice please. I have an orders table and a inventory table - one to many. When the items in the inventory table are received...
September 6th, 2005 09:48 PM
by John Spencer (MVP) Go to last post
2 91
Multi-Level BOM (Bill of Materials) by Meredith
I have a dilemma with a multi-level BOM which has plagued me for months. I use linked tables which are in a data warehouse which I have no control over so the...
September 6th, 2005 10:09 PM
by [email protected] Go to last post
5 147
Returning NULL Values by Sparky Arbuckle
I am working on a web application for a company that uses an existing company database. I just found out before the long weekend that a couple hundred of the...
September 6th, 2005 10:37 PM
by Sparky Arbuckle Go to last post
7 111
IIF "Add-On" by Sparky Arbuckle
So after reading documenation and Usenet help replies this morning I have concluded that the IIf function in Access is not going to help with my current...
September 6th, 2005 11:41 PM
by Sparky Arbuckle Go to last post
5 74
Finding Unmatched values by Carlee
Hi there, I have a report that shows impression reads for two consequetive months. I am looking for a way to alter my query to allow me to see all devices...
September 7th, 2005 01:14 AM
by Ofer Go to last post
2 74
Criteria? by Angel_1
I have a field called categories. In this field there are 8 categories. Some records have more than one catergory. Is there any way I can use a combo box to be...
September 7th, 2005 01:14 AM
by KARL DEWEY Go to last post
2 92
Most current JET provider string by XP
I am using Office 2003 on Windows XP. I am using ADO combined with JET. Is this the most current provider to use? Microsoft.Jet.OLEDB.4.0 Could someone...
September 7th, 2005 01:31 AM
by Douglas J. Steele Go to last post
1 77
undefined function 'replace' by kaw
I have a saved query object with a replace function embedded in it (update xx set xx=replace(xx,'|','EOR'). This query works in several different...
September 7th, 2005 01:33 AM
by Douglas J. Steele Go to last post
1 69
Post New Thread


Display Options
Showing threads 9801 to 9820 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:01 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.