INSERT INTO where data is on an Oracle database
Wed, 7 Jan 2009 15:57:05 -0800 (PST)
Hello,
To ease the process of importing data into a table, I'd like to know
if it's possible to use INSERT INTO with data from an Oracle database
or anything else of this kind.
I already have a query that does the job by looping thru a recordset
like this :
*********************************************** ...
|
Append Query Problem
Wed, 7 Jan 2009 15:31:01 -0800
I have a query that searches a table and gathers records based upon a
supplier code entered on a form and then appends them to a special table. All
is working well EXCEPT one supplier code. When I search that supplier code, I
do not receive any errors, it just locks up.
If I run the query as a select query, ...
|
Query where every record in one Table is listed
Wed, 7 Jan 2009 15:03:21 -0800
I have two tables Apartments and Occupancy and I am trying to create a query
that will pull the current Tenant from the Occupancy Table based on an
inquiry date (I know how to do that part) but I also want the query to list
the Apartment from the Apartments Table even if it does not have a "current"
tenant. ...
|
pull data from one table and combine with info from another table
Wed, 7 Jan 2009 17:32:14 -0500
we have one table that has users and check in data
the other table has all of the other information
we would like a query that combines the check in data to the table that has
all of the other information
...
|
Sort query by date
Wed, 7 Jan 2009 14:16:39 -0800
I have data which as a date/time stamp. I want to create a query which give
me counts by by month by for several different categories by region. I have
created the query to give me the counts by region and by category but I can't
get it to give it to me as a monthly roll-up. Can I do all of this running 1
...
|
Search through dates using like
Wed, 7 Jan 2009 13:52:08 -0800
I have a LONG table of orders. The dates are entered mm/dd/yyyy.
I was attempting to use like to search for all dates that happened in
September, regardless of year. I keep getting a syntax error. Is there a
way to search for dates that occured in a particular month regardless of day
or year?
--
Tha ...
|
Subtracting Time from a DateDiff field
Wed, 7 Jan 2009 13:35:16 -0800
I always get confused when dealing with time in Access so I will greatly
appreciate any guidance.
The [TimeSpent] field is a calculation of the difference between two times.
In the code below, I am subtracting 1 hour from [TimeSpent] to remove breaks
and lunches:
DateAdd("h",-1,[TimeSpent])
This work ...
|
|
|
Sorting Fields
Wed, 07 Jan 2009 21:24:53 GMT
I have a query that returns [DaysOld],[Status]
[DaysOld] is a number ie. "9" showing how old that job is.
[Status] is "sales", "stock", "old sales" and a few other
I need to be able to "Sort" by "Sales oldest to newest" and after "Stock
oldest to newest" and so on.
I can think of a few ways for assig ...
|
Make-table results differ between View and Run
Wed, 7 Jan 2009 13:01:15 -0800
The below make-table query returns 232 records when I click VIEW. But if I
click RUN, the table it creates has 233 records. A simpler count query
returns the correct 233 records. When I enter a different year at the What
Year prompt, I get the same problem - VIEW gives 1 less record than RUN.
These are l ...
|
Return Record for Latest Transaction
Wed, 07 Jan 2009 20:45:21 GMT
I have a table containing transaction data for many
items (Partno). Each item may have several entries in the table due to
transactions on different dates (TDate).
I wish to select the complete record for each item for the most recent
transactions (TDate) from a table containing many records. How do I structure
...
|
