Trouble with the site.
Tue, 23 Dec 2008 13:10:16 -0800
I can't view responses to questions when I do a search. I even tried to post
this question after doing a search and it didn't work. I'm hoping that it
will work now. Does anyone know what the problem might be.
Otherwise I'm trying to find out why my query is not updateable. Any help
is appreciated.
...
|
Can only view questions
Tue, 23 Dec 2008 12:45:01 -0800
Why can't I view reply's. It's as if I wasn't logged in but I am logged in.
If this question posts then it's proof I'm logged. FRUSTRATED
wallymeister ...
|
Query a field with data 1-20 eg.?
Tue, 23 Dec 2008 09:39:00 -0800
I need to query the field with data like 610-620,650-699 and ask it to return
any record that falls either = to or in between. Is it possible, or do I
need to make low and high field and enter data records in this case two
records?
low high
610 620
650 699
Ask for 655
--
Wayne ...
|
Unmatched query between three tables
Tue, 23 Dec 2008 08:56:01 -0800
Hello,
I have an MS Access 2003 database that contains employee training records as
follows:
tblEmployees (empID, name)
tblTrainingCourses (courseID, courseName)
tblTrainingIncidents (courseID, empID, dateCompleted)
One employee can take many courses, and one course could be taken by the
same employee ...
|
Subtraction Query
Tue, 23 Dec 2008 08:10:01 -0800
I am trying to do a simple subtraction between two tables. My SQL is below:
SELECT [Wanda - Current Week].Advertiser AS [Current Week Advertiser],
[Wanda - Current Week].SalesRegion AS [Current Week Sales Region], Sum([Wanda
- Current Week].Q409) AS [Current Week Quarter], "13" AS [Current Week],
[Wanda - Pr ...
|
Summary Query has Duplicates
Tue, 23 Dec 2008 08:03:01 -0800
Hi,
I need your help. Here is my SQL as I understand that it may be helpful to
you to understand my problem. I have a table and mulitple queries in which I
am trying to create a summary report which lists Vendor and Types on the left
with Volume and Price listing across for each Period. It looks like the ...
|
Trouble with Query doubling values
Tue, 23 Dec 2008 08:01:02 -0800
I have a query from a legacy database that draws out record counts based on
employees over a given date range. But when I run the query some of the
values result in too many records. I am kind of baffled on why this query
doesn't work when it did in an early version of this exact database.
SELECT [All Memb ...
|
|
|
Data update
Tue, 23 Dec 2008 04:22:00 -0800
I currently have a master product catalogue (650000 lines) in access which is
updated from our oracle systems. I would like to update/ add customer
specific catalogues (70,000 lines) with certain information from the master
catalogue ie prices changes.
I have a unique field product code in both of the tables ...
|
Query Aggregation Problem
Tue, 23 Dec 2008 10:56:17 -0000
Hi
I have 2 tables, one is the data download from online banking and the second
one is with filtered date.
From table 1 I want to insert date into table 2 only if the date is greater
than the date of data in table 1.
I wrote this query
INSERT INTO tblnationwideflex (transdate, payee,[in], out, balanc ...
|
Duplicate vaules dropped when summing
Tue, 23 Dec 2008 02:52:01 -0800
I have an invoice form and table that allows 5 lines to be entered with the
relevant separate services and amounts.
Then I have a Union query that collects the amounts together and sums the
amounts (GroupBy) to arrive at a total for the order.
If any of the amounts on the lines are the same, e.g. 25.00 appears ...
|
