Complicated Query (well for me!)
Sun, 5 Oct 2008 18:01:03 -0700
Hi All,
I thought I had this figured out from a post I found when searching, written
by Dale Fye from 12/29/2004 (called Help on a complicated query!?).
The problem I have is the same basic problem, I need to have Access
calculate the expiry date for an employees training. My problem is that I
have 16 ex ...
|
criteria between two dates
Sun, 5 Oct 2008 15:31:47 -0700
I have a form .. frmForm that has several fields ... id; bkdate; wkdate. I
have a query and I want to limit the data between 9/26/2008 and the date that
is in the field [wkdate]. As follows:
Between #9/26/2008# And [forms]![frmdate]![wkdate]
so my query looks like
WHERE ((([TBL Tickets].CurrentDate) Be ...
|
Lookup product price
Sun, 5 Oct 2008 11:26:01 -0700 (PDT)
I have a table in MS Access which has two columns, one column
containing a product name, and the other contains the product price.
I have also created a form, and have a product cell set as a combo box
(amongst others) for easy selection.
When the user selects a particular product type from the combo box, i
wou ...
|
How to find specific value or return all records
Sun, 5 Oct 2008 09:31:01 -0700
How can I set up my criteria so that if a user does not enter a value in the
form, all records are returned?
For example my form allows a user to search by country. But if the country
text box is left blank no records are returned (which I don't want to happen).
Thank you. ...
|
Is It Possible To Disable Combo Box on Parameter Query Form
Sun, 5 Oct 2008 05:08:01 -0700
This site has always got me through a problem so here's another one.
To open a report the user has a form to enter required filters such as
dates, values etc. which are passed to a paramter query.
Some reports need to be filtered by Supplier and some do not. The user input
form has a combo box of suppliers, t ...
|
how to use where clause in my query
Sun, 5 Oct 2008 01:30:00 -0700
I have following query to count n1 in last 2 sr's
Select a.sr, B.n1
FROM [sloto Union] AS a INNER JOIN [sloto union] AS B on (b.sr<a.sr) AND
(b.sr-a.sr<=2) AND (b.SR+2>=a.SR)
GROUP BY a.sr, B.n1
ORDER BY a.sr, b.n1
suppose I want to use where clause in above query to count n1 in say last 3
sr's or 4 ...
|
League
Sun, 5 Oct 2008 01:10:00 -0700
I have a table called Data, with fields Home, Away, Referee. What I want to
do is find out which teams (Home or Away) a referee hasn't had, by entering a
referee's name. ...
|
|
|
Need Help With Criterias
Sat, 4 Oct 2008 19:21:01 -0700
Hi everybody I have a table that has a few dates for every record, and I want
to make a query that will return only one date per record, and should be the
earliest date for that record.
What do I have to write in criteria?
...
|
Query shows all the records of the tables without even selection
Sat, 4 Oct 2008 16:29:01 -0700
Whenever I create a new query with Design View and add table/s, the output
shows all the fields of all the table/s, even though no fields are selected
into the grid.
The SQL statment is
SELECT *
FROM tblName;
S I have to choose the wanted fields and then to delete " *, " from the end
of the SQL statmen ...
|
Error: Operation must use an updatable query
Sat, 4 Oct 2008 15:13:01 -0700
Hi
I am trying to update a table from a query with an update query. The source
query is an aggreagate query. My update query is:
UPDATE tblEquipment AS E
INNER JOIN qryComponentTotals CT
ON E.lngEquipmentID = CT.lngEquipmentID
SET
E.curCostPrice = CT.CompCost ,
E.curSalePrice = CT.CompSale
...
|
