|
|
Queries don't work after moving database by
Bill
I'm befuzzled. I moved an Access 2000 database from my old laptop (W2K, SP3) to my new laptop (also W2K, SP3) and now my queries that use the RTRIM() function...
|
June 7th, 2004 03:58 PM
by Bill
|
2 |
212 |
|
|
Too few paramaters by
BobRoyAce
I have a query that, when I attempt to execute using code
(e.g. Set rs = CurrentDB.OpenRecordset(...)), I get a
message indicating "Too few parameters....
|
|
1 |
190 |
|
|
Query to select columns in a table by
Niall
I have a table which has the following headings:
Name 2004 2005 2006 2007
Under the name field is all the staff members name. Under
each of the...
|
|
1 |
163 |
|
|
Too few parameters... by
BobRoyAce
I have a query that, when I attempt to execute using code
(e.g. Set rs = CurrentDB.OpenRecordset(...)), I get a
message indicating "Too few parameters....
|
|
1 |
403 |
|
|
Slow Outer Joins by
CoMET
I am working in an object oriented database and need to pull a number of fields from different objects if they exist. I can find matches with ease but when...
|
June 7th, 2004 02:01 PM
by CoMET
|
2 |
598 |
|
|
DMAX function in query by
Jim Franklin
Hi,
I have two tables, tbl_Orders and tbl_Letters. Both have a common Cust_ID
field and each has a date field, Order_Date and Letter_Date respectively.
Each...
|
|
1 |
513 |
|
|
Like operator by
Steve
Hi,
I'm trying to search the database fields by using a Like operator in my query.
Everytime its asking for a parameter. Any suggestions ? or can someone give...
|
June 7th, 2004 09:31 AM
by steve
|
3 |
252 |
|
|
best sellers by vendor by
Maureen
Good morning,
From invoice detail I would like to collect (in a single query) the top 5%
for each vendor. i.e.
Vendor 1 has 100 items I'd like the top...
|
|
2 |
476 |
|
|
Problems w/ Date() function... by
M. Center
Had several queries using the Date(), typically in a range selection (ie.
Date()+7:00AM AND Date()+3:15PM). Suddenly all queries using the Date()
generate a...
|
|
2 |
226 |
|
|
Dlookup Query by
Dave Hunt
Hi,
I have two fields on a form.......Suburb and City
The suburb is a cboSuburb Query
In the City field I have =DLookUp(" ","","! =" & "") ( After...
|
|
4 |
134 |
|
|
|
|
1 |
227 |
|
|
inventory Query by
Iris
I have 2 tables. One "inventory" thhe fields are
PartNumber, QTY, Descrp. the other table "orders" have
the ability to order up to 6 Partnumbers for each...
|
|
1 |
147 |
|
|
Adding three tables to one by
TYE
HI,
Here are the examples, which each field/data have in all 3
tables:
Name
Total Hours
Sales
Completes
Wait time
|
|
1 |
337 |
|
|
Record updatability by
Michael Wong
I have a recordset (containing ProductId) that is the result of a join
(criteria selected from the user).
I would like to apply an update query to this...
|
|
2 |
118 |
|
|
Using Wild card in Iif statement by
Les
Could somebody please tell me if it is possible to use a
wild card in an Iif statement e.g. IiF(="*PE","Y","N")
In other words i want it to find HZPE, AEPE,...
|
June 6th, 2004 03:34 PM
by
|
2 |
358 |
|
|
Query Form: Print Report by
Dennis
I have a query form that has three query criteria fields.
The first field is a diagnoses, the second is the first
unit and the third is the second unit. First...
|
|
1 |
1,264 |
|
|
This works, but should it?? by
alikwok
SELECT DISTINCT LOCAL_Sales.SaleID, LOCAL_Sales.Date, LOCAL_Sales.CardRecordID, LOCAL_Sales.InvoiceStatusID
FROM LOCAL_Sales
UNION SELECT DISTINCT...
|
|
5 |
192 |
|
|
The Apprentice on Access by
GabrielG
One of the fields on a table contains text data, basically Yes or No
How can I make a query and report to count how many Yes and No inputs I have
?
Please, if...
|
|
2 |
126 |
|
|
creating a query by
Alex
I have three tables:
Table1 - All Product
Day Product Component# Qty
1/1/04 A 7 100
1/2/04 C 2 20
1/3/04 C ...
|
|
3 |
110 |
|
|
italics by
Bob Matthews
I am using access 2003
I have two fields :- date died and where died
I wish to create a new field which is text-based and uses the data from the
two fields...
|
|
1 |
207 |