farriswheel
Last Activity: Dec 18 '06, 02:44 PM
Joined: Sep 29 '06
Location:
-
Thx Neo!!! -
how to link date function to text box
Hello All,
I am trying to link a date function to a text box.
I go into text box click on expression builder
and insert the date function into the after update tab
when I turn on the form I don't see anything
Any ideas?
Farris -
Using the Union
Hello All,
I'm having trouble using a union function with "insert into" function.
Maybe what I'm trying to do is not possible
Thanx for the help!
Farris
INSERT INTO [temp order_tbl] ( [part no], [part type], cost)
SELECT [model no], productdescript ion, unitprice
FROM model_tbl
WHERE [model no] = (forms![main_frm]![computer_lbx].Value)
UNION
INSERT... -
Thanx!!!!!
I understand now
Farris...Leave a comment:
-
Syntax help
Good Day,
I have a table that is labeled temp order_tbl.
I understand that sql reads the space so the correct way to get around the space is to use brackets: SELECT [temp order_tbl] which seems to work fine until I try the INSERT INTO function:
INSERT INTO temp order_tbl this gives me a syntax error
INSERT INTO [temp order_tbl] this gives me invalid use of brackets
any ideas?... -
the where clause and multiple forms
Good Day,
I am attempting get a total sum for the items selected, I keep receiving a error in my query when I try to use the where clause: "the expression is typed incorrectly"
Notice in the where clause I am trying to retrieve information from a different form!
Here is the code:
SELECT SUM (model_tbl.unit price) as cost
FROM model_tbl
WHERE model_tbl.unitp rice... -
It Does!
Thanks for the help
Farris...Leave a comment:
-
Understanding the SUM Function
Hello,
I'm new the SQL language so I am trying to get a grip on the syntax.
My problem is with the SUM function; I recieve an error when I try and group with other fields:
Example:
SELECT SUM(UnitCost) AS TotalUnitCost
FROM PAYMENTS;
the above works!
but when I try and do this:
SELECT SUM(UnitCost) AS TotalUnitCost
,StudentID, LastName
FROM PAYMENTS;...
No activity results to display
Leave a comment: