SQL into a labels caption ?
Sat, 27 Sep 2008 13:27:00 +0200
I would like to put the result from an SQL into the caption of a label,
but it keeps showing the SQL sentenc insted and not the result. I can
see that the label thinks it is some text I want to show, but how can I
make it do what I want it to do ?
How I have tryed it -
label.caption ="select.......... ;" ...
|
Summary Queries
Sat, 27 Sep 2008 00:05:47 -0700 (PDT)
Hi
Currently I have a db where I can run queries on several locations
( from a form with a drop down list) which in turn runs a query then
puts out results to a report which is summed in the footer.
My question is how do I write a query which will look at each
location, total the cost of items for each location ...
|
ACCESS 2007 Update Queries
Fri, 26 Sep 2008 17:52:03 -0700
I just updated and am trying to make an UPDATE QUERY like I did in Access 2003.
When I try to update the value in one table with the value from another
table I get a message that says I can only use one table and when one is
selected the other table is removed. How do I make this type query in Access
2007 ...
|
Query count then average.
Fri, 26 Sep 2008 15:18:01 -0700
This is a follow on question to my post on 9/22/08 â??Query on checkboxes.â?
First I really appreciate those who are on here helping people like me learn
MS Access and find solutions to problems.
In my golf database, I have a table with the following columns:
Name/Date/Course/Hole/Tees/Fairway in Reg/Green ...
|
Obtain Month & Year from a Text formatted Date field using Left Fu
Fri, 26 Sep 2008 14:36:01 -0700
I have an Access table (1.5 million records) that has the Process.date
formatted as Text. It is not possible to change the datatype to date/time
format.
It looks like this: 2008-06-01 00:00:00.000
I am trying to obtain the Year and Month from this field using Text
Functions:
Please advise if there is a ...
|
backend table not showing in linked table manager
Fri, 26 Sep 2008 14:13:01 -0700
I used a make table query to create a table. The table shows in the front end
but not the backend. What should I do so the table will be in the backend
instead of the front end? I tried to export the table but the Linked Table
Manager still does not show the new table.
Thanks. ...
|
Update query average from second table
Fri, 26 Sep 2008 13:49:01 -0700
I am trying to use a update query to update a column in one table with the
average of values from another table. StandID and ORACS are common fields.
One ORACS row will correspond to multiple rows for StandID
The following query gives me a data sheet showing the values that I need,
but I can't seem to writ ...
|
|
|
Need 5 queries with subqueries or can it be done all in one?
Fri, 26 Sep 2008 20:27:46 GMT
I am having an Update Query issue. I have a Calls form that holds 5 chemicals
and the quantities used of each. I need these quantities to be subtracted
from the Inventory table as I enter calls.
I made a simple Update Query but am receiving undesirable results.
Because there are the 5 spots to enter chemicals, ...
|
Delete Query Not Working
Fri, 26 Sep 2008 12:19:01 -0700
I have a couple of queries set up to get a very select list of records. So
far, all of those are working properly. Now that I have what data I need, I
would like to write a query to Delete those results with matching IDs from
the original table.
Table "Records" - holds data regarding absences
Query "Sums" - ...
|
More than one value needed
Fri, 26 Sep 2008 12:04:02 -0700
I need to pull more than one answer from a field in a query.
I have tried: , : ; and &
For an example- tax types: 1040, 1065, 1120, 1041
I want to pull all but the 1040.
Any ideas on how I do that? ...
|
