|
Append query in Access to SQL Server
Hi,
I have data in Access 2003 that I want to append to SQL Server 2000. I have
created a linked table and tested the connection, all is well. I want to
create an append query in Access to add data to the SQL table. In the Access
QBE design view I select the Append Query from the Query Type list. When I
click on the Append query button it does not have the linked SQL Server table
in...
|
3 |
12/29/2008 6:42:01 AM |
|
|
More Than 1 Field
I have a query that counts the number of occurrences by month, the code is
"select format(Receive, "yyyy\-mm"), count(*) FROM Table1 GROUP BY
Format(Receive, "yyyy\-mm"). I was getting help from someone but now I can't
find that post. My question is can I make this work for the other 4 date
fields in the table or do I have to create a query for each date field.
Thank You
TryingToUnd...
|
3 |
12/29/2008 6:22:17 AM |
|
|
How many nested iff can be there in iff function?
...
|
4 |
12/29/2008 3:24:39 AM |
|
|
d lookup
I have two tables. One with Salary Particulars, a field name Gross.
Another table named Income Tax, with fields PayRangeLow and PayRangeHigh, and
TaxAmount.
In a query I have a column with Tax: DLookUp("TaxAmount","IncomeTax",[Gross]
& " Between [PayRangeLow] And [PayRangeHigh]") in the field section. I want
to return the tax amount payable from the Income Tax Table, based on the
...
|
3 |
12/29/2008 3:22:38 AM |
|
|
query delay
My form uses a listbox to browse through records and it works fine unless I
delete a record.
The parent form uses a persistent snapshot recordset which is requeried by a
subroutine in vba. The subroutine then uses this recordset to create a new
recordset which is applied to the listbox's recordset property so that it
will reflect any changes made.
The sub calls these procedures ...
|
3 |
12/29/2008 3:07:24 AM |
|
|
SQL Help Please
I think I posted this in the wrong area previously. I received notification
of a response, but cannot get to it. I think I posted in reports, when it
belongs here. Here it is again. Sorry about that.
I have created a pass through query to get data from an Oracle Database.
The SQL appears below.
SELECT STATION.STN_NAME, PRODUCT.PROD_ID, PRODUCT.PROD_NAME, SETUP.SETUP_ID,
SETUP.SE...
|
2 |
12/29/2008 12:44:36 AM |
|
|
SQL Server Login requesting password when query is run.
Sporadically, when I run a query on a linked ODBC table, I get a SQL Server
Login prompt where it lists my ODBC UserID and I have to enter my ODBC
password. This creates major problems when I try to run a long sequence of
queries using VBA (it stops running in the middle). Is there a way I can
stop this prompt from occurring?
Thanks...
|
2 |
12/29/2008 12:41:10 AM |
|
|
FIRST in a MATCH
JOHN,
I HOPE YOU WILL RESPOND AS YOUR LAST ADVICE WORKED GREAT AND I WAS ABLE TO
UNDERSTAND YOUR STYLE OF EXPlANATION.
I have a query now that outputs the records I am interested in. However,
the query will not let me update any of the fields. Specifically, I wish to
"mark TRE" the PRINTFLAG field so that I can run a report and print of only
the records I am interested in.
I assume th...
|
1 |
12/28/2008 9:46:01 PM |
|
|
MATCH
how do you write a query to do a sort of VENN [diagram] UNION or Interesection
between two tables? In the 4GL FOCUS Language, you would query table 1
and place the output on HOLD sorted by key 1. Then query Table 2 and place
the output on HOLD sorted by key 1. Then you would MATCH the two HOLDFILES
on Key 1,
and output UNION or INTERSECTION.
In ACCESS QUERY, I imagine you write QUE...
|
10 |
12/28/2008 8:35:01 PM |
|
|
use different equations in same query field
I am trying to set up a query to calculate flow from a table which contains
date and other relevant information. The calculation changes depending on
the date. For example, the table is called FlowDataRearragned and has the
fields [FlowDate] (formated as short date), [InfluentFlow] and
[EffluentFlow]. I'm calculating [EffluentFlow] from an Update query, but
need to change the equation ...
|
3 |
12/28/2008 6:55:00 PM |
|
|
OUTER JOIN Trouble
Hello
I have a question about outer join.
For example, we have Persons table:
Person_id | Status |
1 | active
2 | with obligations
3 | nonactive
4 | active
Then we have Lending table
Lending_id | Person_id | Lending_status_ID |
1 | 1 | 1
2 | 1 | 1
3 ...
|
4 |
12/28/2008 6:13:47 PM |
|
|
data from different tables
Hello everybody,
please help!
I have 3 tables and I retrieved the data in this way:
select field1 from tbl1 where id=5
union select field2 as field1 from tbl2 where id=3
union select field3 as field 1 from tbl3 where id=7
So I get the data in three rows. But I would like to get them in a single
row: field1, field2 and field3. Is this possible?
Thanks!
Wolfgang
...
|
7 |
12/27/2008 11:57:22 PM |
|
|
Transpose
I hv three columns as shown below.
Name Month Amount
C72651 Dec-08 10
D398456-00 Dec-08 20
Y65148413 Dec-08 30
U1284563 Nov-08 40
T21645984 Oct-08 50
E8123321 Sep-07 60
I need a single query to convert the above rows into separate columns based
on month column as shown below
Name Dec-08 Nov-08 Oct-08 Sep-07
C72651 ...
|
2 |
12/27/2008 6:27:09 PM |
|
|
Beginning Balance for yearly report
How do I compose a query which will pull only the beginning balance of a
particular month, example 9/1/07? I have completed queries which will give me
the income between the time frame after that, but can not seem to acquire
only the beginning balance to add to the income and expenses so an accurate
accounting can be made,
Please,can someone help me complile a query to extract only the ...
|
6 |
12/26/2008 8:31:00 PM |
|
|
Search for records by date
Because I used a "Time Stamp" with the "Date" I have to enter [That Day] and
[The Next Day]. I'm sure there is a better way. Thanks
Here's what I use
SELECT Table1.[Job Number], Table1.SetterCompany, Table1.[Date To], Table1.
[Date From], Table1.Amount, Table1.[File Number]
FROM Table1
WHERE (((Table1.SetterCompany)=[Forms]![Setter Billing]![Text18]) AND (
(Table1.[Date From]) Bet...
|
4 |
12/26/2008 8:08:42 PM |
|
|
swapping data from one table to another
This is probably a stupid question, but for the life of me I can't remember
how to do this.
I have 2 tables. Table1 has a full list of names and record ID's. Table2
contains a matching list of names. What I need to do is look up the ID value
in table1 based on the name contained in Table2 and then update that value in
an ID field in Table2 so that I can remove the names from Table2. ...
|
3 |
12/26/2008 3:17:19 PM |
|
|
Progress meter while report query runs
I have a report whose record source query takes a long time(2 minutes) to
run. I tried to program a progress bar while the query runs but the query
will not release control to update the progress bar once the query starts.
Is there any way to show the query progress while it is running to open a
report? Even the Access 07 ststus bar does not properly display the query's
progress.
...
|
2 |
12/26/2008 1:38:27 PM |
|
|
sum and do calculation at each change for 900000 rows
I have an access query that brings back over 900K rows. I need to group them
by date, activity, region, status, (Zero means there was no backorder, and 1
means there was a backorder) and stock number.
At each change in status I want to add up the number of orders without
backorders for a stock number in a month, then add up the number of orders
with backorders for a stock number in the ...
|
2 |
12/26/2008 1:01:02 AM |
|
|
Update query
I have 2 tables...
Table 1: has two fields- "Reports" and "Current Period"- current period is
yes/no.
Table 2: has 13 fields- "reports" and "PD 01-PD12"
I want to run an update query...I want to use Table 1 to update Table 2
depending on the Period...
I was hoping in my update query to link by report, and update table 2 to
"Current Period" in table 1. Is there any way not to specify...
|
5 |
12/25/2008 10:30:59 PM |
|
|
How do I format a querie result to come out as currency.
I'm trying to calculate what the new price of an item would be based on
cutting 10% off of an existing price...I can't get the answer to come out as
currency!...
|
2 |
12/25/2008 7:46:15 PM |
|
|
Importing several txt files programatically in Access 2003
Hi,
MY QUESTION: HOW DO I REWRITE MY MACRO so that it cycles through the 16
results of a query and uploads the 16 resulting text files to my database in
one run.
1. My currently working macro (compacted here for space) to import ONE file
at a time from a specific directory to the open database:
....
FilePath = "T:\InternationalPrograms\Finance\2008-10
NAIROBI-Transactions(BON).txt...
|
4 |
12/25/2008 4:37:25 PM |
|
|
ms access 2003 display graphs using combo box
I have a list of values in the combo box. Depending on what value is
selected, graphs should be displayed on the same form. After change of
selection, the form should display the newly selected graph. I have
saved the graphs as forms in ms access. Pls help!!!...
|
1 |
12/25/2008 4:18:15 PM |
|
|
Counting '*' in a query
Hello all.
I pull data from a report that uses * and ** to indicate a certain action
taken on a particular transaction. Since this is a wildcard in Access, I am
having some difficulty trying to count. It counts any field with an asterix,
whether there is one or two. Not every field has an asterix in this column,
but I am trying to count the fields with one asterix and fields with two...
|
4 |
12/25/2008 2:38:55 PM |
|
|
Challenging Query
Hi everybody!
I have 2 tables in my database, a table with Buildings and a table with
inspections of those buildings.
One table has buildings with data related to them, and the other one has
inspection dates with inspection-related data.
The below tables resemble my actual tables. These are the rules for both
tables:
-No building can appear twice in the Building Table. H...
|
2 |
12/25/2008 11:08:55 AM |
|
|
sum columns
I need to display days of the week in a subform and hours worked per day. I
then need to total the hours and perform calculations on the total, which I
also need to display. After trawling through these posts I concluded that the
best way would be to have each day as a field and the hours as a row. I then
created a query so that I could total the hours for the week. Only trouble is
I can...
|
13 |
12/25/2008 7:12:44 AM |