|
|
Format Date by
Tiffany
I have to import a text file into access. When I import
the file using the date format on the table I get import
errors. Since I cannot control the text file...
|
|
4 |
283 |
|
|
|
|
3 |
761 |
|
|
Query DateTime Field by
Tausif
Hi,
I have a field DateStamp, stores both date and time. I would like put a
query with which I can only compare date but not the time. I put this query
but it...
|
|
7 |
432 |
|
|
Query Join Problem by
Tom
Hi all,
I am trying to join two queries together, but the join is
on a normal field in one query to a calculated field in
another. The join is working fine,...
|
May 31st, 2004 09:54 AM
by Tom
|
0 |
1,065 |
|
|
|
|
3 |
474 |
|
|
3 highest values in query by
AK
Hello,
How to display 3 highest (smallest) values in sql query (without Max. values
field) .
Andrzej
|
|
1 |
462 |
|
|
Subquery? by
Chris
I have a table looking like this:
Timekey Value
********** *******
1 1.3
2 1.45
3 1.5
4 ...
|
|
1 |
348 |
|
|
Exclude weekends by
Dan
Hi:
Can anybody tell me how to exclude the weekends from the
rezult of: now()+5 - to calculate just the working days!!?
Thank you,
Dan
|
|
6 |
432 |
|
|
Working Days by
hermie
I try to do the same but not got it work?
I put next formula in my query:
TotalDays: Work_Days(-)
What is wrong with this formula?
Herman
"Ian Tranter"...
|
|
1 |
422 |
|
|
CrossTab Query with Dates by
GNTK
Hi All,
I have a database with 3 tables: TBL_Persons; TBL_Absence;
TBL_AbsenceReasons. When a person is absent I put a record in the
TBL_Absence with the...
|
|
3 |
323 |
|
|
Help! -Match problem by
Chengfu
Hi, group.
I need your help.
I have two tables, one is tblTutor with the names and their available
times, the other one is tblTutee with the names and the...
|
|
4 |
289 |
|
|
Totaling selected records only. by
David
I have been attempting to total some fields from
individual records in a table and then display the result
in a text box but have been unable to do so. I...
|
|
1 |
568 |
|
|
Query By Form by
Craig
I have a query by form whereby the form has a Command Button to run a module
which checks to see if the query has records. If the record count is 0 it
opens...
|
June 1st, 2004 01:10 AM
by Craig
|
2 |
973 |
|
|
Help by
Andy
I currently run w2000 professional on my other pc. When I
shutdown my pc is won't shutdown automatically, I now have
to manually press the on off button. Any...
|
|
1 |
303 |
|
|
|
|
2 |
276 |
|
|
Update query problem by
WWV
I have a table (table 1) with many date ranges in them for grouping by age
ie start, end dates for group 1, start end dates for group 2 etc. I have
another...
|
|
1 |
557 |
|
|
|
June 1st, 2004 08:17 AM
by Chris
|
0 |
590 |
|
|
Edit table using union query by
De'Ville
I am trying to create a form for a union query that
allows me to edit the data in either of the tables used
for the query, but I can't understand why with...
|
|
1 |
1,396 |
|
|
More dates issues by
Mike
Hello,
The dates in a SQL2k table are stored as nvarchar (yyymmdd). When displayed,
the CAST (DATE_FIELD AS datetime) syntax is used. Because of the...
|
|
1 |
362 |
|
|
highlighting field in query or report by
Tony
Hi, I'm trying to highlight a cost field if there is a change in the field
value. eg if previous cost was $2.20 for the last 9 weeks and this order
comes in at...
|
June 1st, 2004 12:53 PM
by Tony
|
5 |
573 |