|
|
|
|
1 |
73 |
|
|
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
|
|
2 |
109 |
|
|
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
|
|
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...
|
|
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
|
2 |
68 |
|
|
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...
|
|
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?
|
|
3 |
77 |
|
|
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...
|
|
1 |
63 |
|
|
|
|
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...
( 1 2)
|
|
11 |
173 |
|
|
|
|
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
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
5 |
76 |
|
|
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
|
2 |
75 |
|
|
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...
|
|
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...
|
|
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...
|
|
1 |
69 |