|
|
|
|
1 |
497 |
|
|
Update Query Type Conversion Failure by
I am trying to run an update query and MS Access fails to
update any of the records because of type conversion
failure. I am not sure what this means, since...
|
July 7th, 2004 06:52 PM
by
|
2 |
469 |
|
|
|
|
1 |
271 |
|
|
negative autonumber by
I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form...
|
|
2 |
167 |
|
|
Group By by
I've been having a problem with grouping in my queries and
I finally figured out how to do what John Spencer
suggested ...
SELECT ,
Sum(IIF(30,CyTotal,0)) as...
|
|
3 |
847 |
|
|
Date/Time by
Hi There,
I have a query that uses the Date\Time function and
displays it as DD\MM\YY HH:MM:SS. I'm trying to extract
any occurance of where the time is 30...
|
August 31st, 2004 02:29 PM
by
|
4 |
162 |
|
|
|
|
1 |
660 |
|
|
finding MAXdate by
I have this query (yes I know "date" is a reserved word). I would like it to find the maximum date per "cont_eduID" and only if it
is over a year old return...
|
|
3 |
273 |
|
|
UNION by
Hello,
I have a SELECT statement
(SELECT DISTINCT Products FROM Shelf
UNION
SELECT ' @#@#@#@#' AS Col1 FROM Shelf) that...
|
January 11th, 2005 02:11 PM
by JL
|
1 |
107 |
|
|
|
June 27th, 2004 06:15 AM
by
|
4 |
149 |
|
|
|
June 26th, 2004 12:51 AM
by fredg
|
1 |
226 |
|
|
Make Table Query takes long time by
I'm using a make table query to create a new table from
Paradox tables. There are about 80,000 records in the
Paradox tables and the process takes about 30...
|
|
1 |
678 |
|
|
Activation on a New Computer by
I have Microsoft Office XP Standard, Version 2002 that I
bought separately.
I bought a third computer and I want to activate this
product so I can use Excel...
|
|
1 |
359 |
|
|
Help on query logic by
Can someone suggest some logic for the following:
I have two tables: one gives a listing of items and the
second gives a listing of transactions performed on...
|
|
1 |
318 |
|
|
|
|
1 |
322 |
|
|
Simple query, multiple fields by
Alright, so I have been scouring the newsgroups trying to
find a solution to my problem, but it seems to escape me.
Here is what I have. There are two tables...
|
June 7th, 2004 04:52 PM
by Paige
|
2 |
411 |
|
|
Duplicate search by
Hello,
In one of my fields, i have customers names so in the
future i can tracks how many requests came from one
certain customer.Is there a query search that...
|
|
5 |
190 |
|
|
Query records between weeks by
Date By Week: DatePart("ww",.) in
Field. This would show all records.
But I want to have criteria to query records between today
and back 10 weeks. I...
|
|
1 |
260 |
|
|
calculating grand total by
Hello
I have a table which records the number of staff receiving
an education class, with a separate field for different
staff types.
I can create a query to...
|
|
1 |
120 |
|
|
sql check please by
SELECT SUM (care_charges + other_charges + Pay_late_fee_daily + pickup_late_fee_minute + payment_amount)
FROM payments
WHERE ID = MMColParam AND...
|
February 6th, 2005 05:19 PM
by
|
0 |
75 |