|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 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 |
|
|
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 |
|
|
SQL string problem by
Gary D.
I have a form within which I am trying to define a SQL string via a
string variable (I have also tried defining it as several string
variables and...
|
|
6 |
448 |
|
|
Start of field Query by
Nikki
Is there a line you can add to this code
WHERE (((InStr(,
))0 Or (InStr(,)) Is Null))
That will allow you to search for the start of the field
as well. Say...
|
June 7th, 2004 04:22 PM
by hcj
|
1 |
497 |
|
|
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 |
412 |
|
|
Probably really simple but.. by
Jack McGuigan
Hi all,
I haven't used Access for yrs and now need to create a query quickly. I
have a table, in which some of the fields have long data strings. I...
|
June 7th, 2004 06:00 PM
by fredg
|
2 |
118 |
|
|
delete query by
jebuss
I have a small app to print out multiple reports.
The user inputs the data on the form, which writes to the table.
Then the user can choose which reports are...
|
|
4 |
178 |
|
|
How to Join Chacter Field to Numeric Field by
Racer57
I have a database called Projects that has a Text field called Project ID. I
also have a spreadsheet called Invoices that I want to link to the database
that...
|
|
6 |
703 |
|
|
cascading delete in SQL ? by
delphine
Hello,
I'd like to know if it's possible to set up a relationship as cascade deletes using SQL under MSAccess.
I tried "CONSTRAINT fk_column
FOREIGN KEY...
|
|
5 |
133 |
|
|
w/ dlookup by
In need of help
What I am trying to do:
tblUniveral is made of questions (Q1- Q28)which can only
take their value from the list of Satisnumber off the
tblSatisfaction....
|
|
1 |
177 |
|
|
Problem with Query by
bmistry
Hi,
I have created a Expression in a query with the following
code:
IIf(IsNull() Or IsNull(),"No
Data","Some data")
However, some of the records have 'Some...
|
|
2 |
115 |
|
|
update query so slow by
VC
I wrote 7 update queries for updating the field startofweek and endofweek depending on the reportday, it takes more than 2 hrs to run all of them for 250000...
|
|
4 |
275 |
|
|
Max(date) not returning correct results by
Asha
Hi, I am trying to return the last comment by projectid,
when I run this query it is still giving me all comments
instead of the last comment. What am I doing...
|
|
2 |
212 |