|
|
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 |
|
|
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 |
|
|
Subquery? by
Chris
I have a table looking like this:
Timekey Value
********** *******
1 1.3
2 1.45
3 1.5
4 ...
|
|
1 |
348 |
|
|
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 |
|
|
|
|
3 |
474 |
|
|
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 |
|
|
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 |
|
|
|
|
3 |
763 |
|
|
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 |
|
|
current date less 28 days by
marion
I support online learners and in this particular query I
am using two tables one for the student information and
one containing all the contact I have had with...
|
|
5 |
302 |
|
|
|
|
2 |
381 |
|
|
criteria in query part of field text only by
MemphiDoug
In my email field, I want to query only the aol.com users. I have
tried ="**", I have tried LIKE "**", I have tried
just "aol.com" I can't figure out how to...
|
May 30th, 2004 09:11 PM
by pdm
|
1 |
607 |
|
|
"append query" issues by
BJMLaJolla
I have the same problem. I have 70 tables that I want into one table. All tables have the same structure with different content. I tried an Append Query but...
|
|
1 |
325 |
|
|
|
May 30th, 2004 06:23 PM
by Paul
|
2 |
345 |
|
|
criteria in query part of field text only by
MemphiDoug
In my email field, I want to query only the aol.com users. I have
tried ="**", I have tried LIKE "**", I have tried
just "aol.com" I can't figure out how to...
|
|
1 |
680 |
|
|
Substracting two adjacent rows by
Yakimo
Hi!
I have a very large table, containing some DateTime data.
Is it possible to run a query that will return a resultset, containing the
difference between my...
|
May 30th, 2004 06:01 PM
by Yakimo
|
2 |
290 |
|
|
Autolookup Query by
Ernie
I have an autolookup query that automatically fills in employee name and rate on a form. What I would like is to be able to update the rate, for each record,...
|
|
6 |
604 |
|
|
HELP! by
Hannah Jackson
Hi! I don't know how this works but I have a problem so I'm just gonna post
it up here.
When I'm connected to the internet and I open explorer after about 5...
|
|
1 |
403 |
|
|
|
May 30th, 2004 07:07 AM
by tina
|
1 |
992 |
|
|
how do you work with time? by
Annelie
I am trying to create input for a time card
Start: 07:44 (shorttime format)
End: 17:13 (shorttime format)
HoursWorked: 09:29 (shorttime format)-...
|
|
1 |
360 |