|
|
CREATE TABLE Query, DEFAULT value DateTime by
GaryN
I am putting together some scripts to run in VB to create an ACCESS database
and it's schema.
As a part of each table I want to have a timestamp field that...
|
|
7 |
132 |
|
|
Same query / different tables by
Jeff
Hi
I am trying to determine how to write a particular query. I have 1
parent record with 2 child records. The parent has neighborhood on it.
Each child has a...
|
February 7th, 2007 11:35 AM
by Jeff
|
6 |
120 |
|
|
UTC Time in a query ? by
Adrian Constantin
Hello.
Can Access tell what is the current UTC or GMT time ?.
I would like my database to be shared between customers in different
countries and I would like...
|
|
3 |
117 |
|
|
data validation by
GRIFFO
Hello,
I have two tables of data, and I want to test the data in one table against
the data in another. Here's the wordy scenario.
Telephone exchanges...
|
|
1 |
69 |
|
|
syntax error FROM Statement by
brz
I have tried to apply some infromation off the message boards to my Data Base.
I have exhausted all the Help from Microsoft office and cannot seem to fix
this...
|
February 7th, 2007 02:46 AM
by brz
|
6 |
88 |
|
|
Help Writing Query Please! by
shar
Please help rewriting the following SQL query for MS Access.
Thank you.
SELECT
O.ONE_ID,
O.TWO_ID,
O.THREE_ID,
O.SEQ_NO,
O.STAT,
|
|
3 |
72 |
|
|
Problem with complex query coding by
CP
I wish to use a form to show the results of a query between customer and
equipment serial no activated by a control button. Then control button runs
the...
|
February 7th, 2007 12:23 AM
by CP
|
2 |
93 |
|
|
select a crteria for a txt feild by
jon
I have a query which works fine but I want to get the user to be able to
chose different criteria.
Date()-90
Date()-120
between 17/02/2006 and 17/06/2006 ...
|
February 7th, 2007 12:20 AM
by jon
|
4 |
113 |
|
|
Query help by
ckloch
I have a two tables. the first table has a list of all mutual funds
for all clients and the recommended replacement along with the
effective date. The...
|
|
5 |
78 |
|
|
|
|
2 |
83 |
|
|
date in a query by
soj
I am using Office XP or Office 2000 Premium.
On some of my compagnys computers, the expression for today, date(), is
accepted in a query, and on other...
|
|
1 |
142 |
|
|
|
February 6th, 2007 11:44 PM
by Tony
|
2 |
85 |
|
|
|
|
1 |
72 |
|
|
Requery creates new record by
StuJol
i have an Access2003 database with a main form that has several sub forms.
Part of my code writes data to the main form when it is about to close.
Below is...
|
|
1 |
82 |
|
|
|
|
10 |
146 |
|
|
Does Access 2000 support SQL2? by
Billy Smith
I'm using Access 2000. I'm studying some complex joins in a book that says
SQL2 will do some things that SQL1 will not. Does Access 2000 support SQL2...
|
|
2 |
92 |
|
|
|
|
9 |
113 |
|
|
Cleaning up a data field in Access by
Jean J
I have a file from a customer, who has formated the name field like:
"John***Doe", how can I extract the first name and the last name and break
them up,...
|
|
2 |
79 |
|
|
|
February 6th, 2007 08:52 PM
by G
|
0 |
126 |
|
|
Query Criteria Expressions by
michelle
Is there an expression that would state that for the Date Field it would be
for Current Work Week and then for the Previous Work Week?
|
|
4 |
85 |