|
|
Need to query three controls on a form by
SAC
I have a form with three drop down boxes. The data source for each is the
same.
Driver1
Driver2
Driver3
They all lookup from the Driver Table. So,...
|
May 17th, 2007 02:41 PM
by SAC
|
6 |
82 |
|
|
|
May 17th, 2007 02:41 PM
by RBear3
|
1 |
47 |
|
|
Speed by
Lina Manjarres
Some one told me that it is faster a query that has a where like this:
where Id=1 or Id=2
instead of
where Id in(1,2)
Is this true?
Thanks a lot, Lina
|
|
2 |
100 |
|
|
|
|
4 |
89 |
|
|
Can I randomly remove 500 records by
Garry
Hi all
I have a budget to post 1500 letters
The database supplied has 2000 records
Can I randomly remove 500 records
All the best, Garry
|
|
1 |
66 |
|
|
How do i run two queries at once? by
Picasso
is it possible to update two columns after each other, using one query?
ie...
i need to update an AGE field from Date of Birth of a person and then after...
|
|
7 |
130 |
|
|
Combining Records by
Mike Diamond
Hi All
I have a query set up which currently contains three records. I would like
to be able to add an expression which shows the results of a particular...
|
|
2 |
121 |
|
|
|
|
1 |
85 |
|
|
|
|
0 |
145 |
|
|
Combo Box and SQL by
JAmes
Our application uses a msaccess frontend and a mssql backend (linked tables).
Our application occasionally experiences blocking in sql.
We have identified a...
|
|
3 |
99 |
|
|
|
|
0 |
94 |
|
|
Still stumped - can't get a date (range). by
Sue
I have 2 dates - DOB (date of birth) and DOA (date of anniversary) for
contacts. I've got a union query that enables me to pull both of these fields
into a...
|
May 17th, 2007 10:21 AM
by Sue
|
6 |
62 |
|
|
Help with Crosstab Query by
E.C.
Crosstab Query Help
I am trying to create a crosstab query to compare sales by customer-
then by year & month. I want it to be set up the following...
|
|
1 |
75 |
|
|
|
May 17th, 2007 02:24 AM
by Al
|
4 |
79 |
|
|
Passing Multiple value to a query by
lalexander
Could anyone tell me how to pass multiple values to a query?
I have a form that that I want to pass several value of an options object.
eg: 1=Pending ,...
|
|
7 |
104 |
|
|
Find and Change by
James Kennedy[_2_]
In basic terms: I have a table with fields of Social Security No, Name, and
Type (3 letters). There are multiple occurrences of the same SSN and Name,
but...
|
|
2 |
62 |
|
|
Returning Last Instance of a Duplicate by
Dopple444 via AccessMonster.com
I have a table with Multiple records for the same serial number. I need to
return only the latest record and the next previous record based on the date
of the...
|
|
1 |
94 |
|
|
SubQuery? by
Kirk P.
I've got this SQL that works fine:
SELECT Unit, Function, Min(Prod) AS AProd
FROM tblGLFINAL
WHERE (((Desc)="Product Code Allocation") AND ((Acct) Not Like...
|
|
4 |
73 |
|
|
|
|
2 |
64 |
|
|
|
|
1 |
77 |