query output problem
Fri, 19 Dec 2008 17:31:42 -0600
Hello There, I am trying to get this query to work but have hit a road
block....see below
'Sample - RecyHistory Table Data:
DateRec PalletCount
12/1/08 2
12/1/08 3
12/8/08 5
12/15/08 2
12/15/08 6
'Query to get average numbe ...
|
Add criteria to a append query
Fri, 19 Dec 2008 15:07:02 -0800
I am trying to add criteria to a append query, I was able to use Is Not Null
in my queries Criteria under F_Subs Serialnumber so records that have a blank
SN are not appended but i cant figure out how to put =
Me!T_Main.SerialnumberID in the criteria for the T_Sub's ParentSNID
I have a form F_Main that disp ...
|
Iff Query/Form
Fri, 19 Dec 2008 15:01:07 -0800
I have 3 tables/forms.
-Business Unit1
-Business Unit2
-Customer Info
On the customer form i have 3 fields that i would like to relate to eachother.
-Business Unit
-Account
-Manager
I want the Business Unit field to be a drop down to choose either 1 or 2.
This I can do. The next 2 parts I can't do.
...
|
Crosstab query results and null vs. zero values
Fri, 19 Dec 2008 14:01:01 -0800
Hello,
I have created a crosstab query for the first time and there are results
that are appearing as null values instead of zero values as they appear in
the data feeding the crosstab query. Is there a way to change these values
to zero as I am having issues creating calculations in a report as a result
...
|
Query returns incorrect results
Fri, 19 Dec 2008 13:10:02 -0800
I have an extremely complex web of queries that is returning incorrect results.
Query A relies on a left outer join of two other queries to produce a
dataset, and it provides the desired result. Query B attempts to summarize
Query A using GROUP BY on some of the non-null fields, but for reasons I
cannot ex ...
|
Append only new records to a table
Fri, 19 Dec 2008 12:03:02 -0800
I have an append query where I only want records from Table A not found in
Table B to be added to Table B. However, as I have it set up, the query
appends all the records from Table A to Table B. Is there something simple
I'm missing?
Thanks... ...
|
Code that was working doesn't anymore -Remove ALT-ENTER from Excel
Fri, 19 Dec 2008 11:33:01 -0800
Hello,
MS ACCESS 2003 on XP PRO.
UPDATE t_OIS SET t_OIS.Instructions =
Replace([t_OIS.Instructions],Chr(10),Chr(13) & Chr(10))
WHERE (((InStr([t_OIS.Instructions],Chr(10)))>0) AND
((InStr([t_OIS.Instructions],Chr(13)))=0));
I used this to remove alt-enters from the excel dump and replace them with
the ...
|
|
|
Calculating totals/subtotals
Fri, 19 Dec 2008 10:32:01 -0800
I have a query from a table/query of Donors that is sorted/grouped by gender
then by blood group within that gender (this is a medical database for
statistics).
I would like to have it calculate the total number of donors of particular
blood group wtihin that gender to appear in the report as a subtotal.
...
|
Concatenated Field - Sort Order
Fri, 19 Dec 2008 10:21:01 -0800
{Access2003}
I have a concatenated field in a main query set as follows:
Other Phone: Concatenate2("Select [PhType] & ': ' & [Phone#] FROM [Staff
Contact-OtherPhone SubQ] where [EmplNo]=" & [Employees].[EmplNo] & " ORDER BY
[PrefSO] ASC")
The SubQ [PrefSO] field (based directly off of a table) mentioned ...
|
Append Query Problem
Fri, 19 Dec 2008 16:49:58 GMT
Good morning,
Using VBA, I created code that will query a list of emails that need to be
sent out automatically. That worked fine and did what I needed it to do.
I wanted to take it a step further and use an append query to record the
email event in the activities table. Unfortunately, I cant get it to w ...
|
