|
|
FILTER by
accessvoter
How do you filter numbers? ex. 1 through 200 in order?
|
|
1 |
1,340 |
|
|
calculating average days by
JohnL
I am trying to develop a report where in the PartNum footer the
average number of days between orders is calculated. I have
created the...
|
|
2 |
1,482 |
|
|
date and time query by
domaze
hello,
this is my first post in this forum.
I have the following problem and i really need some help because i am about
to go crazy.
I cannot understand why...
|
|
6 |
1,355 |
|
|
JOIN Query very slow by
Tally.NET
Hello,
I have the following Input tables
Table1
Serial Item Date SerialandDate
123 Item1 01-04-2007 12339173
123 Item2 01-06-2010...
|
|
4 |
1,205 |
|
|
Optimization of Between Clause Queries by
Kevin Myers
I have some sql queries involving the use of between clauses, similar to the
following:
select Colors1.*, sum(Colors2.freq) as TFreq
from OldColors as...
|
|
3 |
934 |
|
|
|
June 6th, 2010 07:52 PM
by JimG
|
0 |
902 |
|
|
Sum and DateDiff by
Kelly
Hi,
I doing a calculation in a query of the difference in times. I'm wondering
if I can control the decimal precision to be just (2) places. The number I
end...
|
June 6th, 2010 04:58 AM
by Kelly
|
2 |
885 |
|
|
AVG BETWEEN DAYS by
Lucy
Hello,
Within my qry I would like to calculate the average daily production for the
month.
The data Im working with is: production volume, dates (which is a...
|
|
1 |
801 |
|
|
|
|
2 |
1,070 |
|
|
Querying for most recent value by
dhinton
I am rather much of a novice when it comes to developing Access databases,
but have found myself in a situation at work where I have had to develop two...
|
|
1 |
855 |
|
|
DatePart by
Keith
I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using
DatePart function.
I've used DatePart("hh:nn",) and it returns "Error".
I've used...
|
June 4th, 2010 09:03 PM
by Keith
|
2 |
736 |
|
|
querying unrelated tables by
Keith
I have two tables - Employee_PunchTime table and Holidays Table. The
PunchTime table contains three fields representing EmployeeID, Time-in and
Time-out;...
|
June 4th, 2010 07:13 PM
by Keith
|
7 |
1,016 |
|
|
|
June 4th, 2010 04:22 PM
by Iram
|
2 |
788 |
|
|
Storing time as integers by
SSi308
I have a call database that includes a field for length of call. I have
created a query that includes employee, date, and length of call.
I need to calculate...
|
|
6 |
982 |
|
|
create a form that collects parameters by
Kalai
Hi,
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in...
|
|
1 |
1,138 |
|
|
|
June 4th, 2010 05:52 AM
by PamB
|
2 |
892 |
|
|
Total by certain time period by
nadesico
I have three fields in a table, and want to determine the total of the
occurrences by a certain time period. The data I have looks like...
|
|
1 |
819 |
|
|
Maybe Update Query? by
AccessKay
I’m floundering about and need someone to point me in the right direction. I
have two...
|
|
2 |
820 |
|
|
Default Dates by
Ampridge
I have a query that calculates records between two dates as
Between And
Is there a way to show a default value for the beginning and ending dates in
the...
|
|
2 |
890 |
|
|
COUNT number of times text in records by
gator
I have a field of names where there are multiple records of the same name. I
want to run a query on this showing a field of the name and a field of the...
|
June 3rd, 2010 06:25 PM
by gator
|
3 |
729 |