Most recent date query
Thu, 25 Sep 2008 09:31:12 -0700 (PDT)
Hi there,
I have a problem that I'm sure there's a very simple solution to, but
I can't figure it out. I'm creating a query based on two tables:
tblStaffMain and tblRank. tblStaffMain houses employee information.
These two tables have a one-to-many relationship: one employee in
tblStaffMain can have many ra ...
|
INSERT INTO Query Question
Thu, 25 Sep 2008 09:19:01 -0700
Just from googling this, it appears this is a common error, but all of the
solutions suggested don't seem to solve my problem. I'm receiving the
following error message as I attempt to run an append query: The INSERT INTO
statement contains the following unknown field name: '[Company]'. Make sure
you have ty ...
|
Group By Apt ID - Match like codes
Thu, 25 Sep 2008 15:56:18 GMT
My company provides cable service to apartment buildings, with separate codes
for each type of service â?? we had an error with our close where some of the
amounts were wrong, so we need to compare the old postings with the new
postings.
The service codes and their related amounts for old (original posting) an ...
|
querydef
Thu, 25 Sep 2008 08:40:07 -0700 (PDT)
I just wanted to make my app clean, because there are too many queries
stored on the mdb file.
I tried to stored my SQL in my table like tblSQLstring and retrieve
them to use currentDB.execute strMYSQL, dbFailOnError
It works fine,
The only thing is when I need run more than one query to get my result
se ...
|
Interesting HR Database - Queries
Thu, 25 Sep 2008 07:36:01 -0700
I am having 2 issues with an employee absentee database.
Here is my set up
-Table "Records" which contains all employee absentee information (name, id,
dates,...) (Based on a linked excel spreadsheet from a network drive, which
gets updated every week.)
-Query "Records Query" which sums each employee's to ...
|
Views and Tables
Thu, 25 Sep 2008 07:05:01 -0700
I'm trying to set up access to an Oracle database from Access 2003. I've set
up my ODBC connections and I can see the tables. I've asked for access to
the views as well as tables. Should the view names show up as table names
when I create an Access linked table using the ODBC database? I don't see
them. ...
|
Pivot Results
Thu, 25 Sep 2008 06:58:13 -0700
Hello everyone. Hope you can help.
I have a table that looks similar to this:
Group Reason Date
grp1 New 9/1/2008
grp1 Old 9/1/2008
As you can see, for grp1 there are two reasons. I need a query to create
data that shows the f ...
|
|
|
replace hyperlink not working...
Thu, 25 Sep 2008 09:32:57 -0400
in table: FixtureCatalogsPages
I want to replace all of the entries in the field: CatalogSheetLink (data
type defined as "hyperlink")
where the current entry is: F:\TDA Master
Specifications\FIXTURECUTSHEETS\Lucifer\Housing\DHT_ZO.jpg
with a new hyperlnk
I have written this SQL staatement; however, ...
|
DB2 Question
Thu, 25 Sep 2008 06:35:01 -0700
I am trying to run an automated job that grabs data every half hour from a
table. I am hosting this downloaded data in mySQL but the source is DB2. The
code for the query currently looks something like this:
SELECT
ABCDEF.PLAYERS
WHERE
ABCDEF.ENDDATTIM
BETWEEN
NOW() AND SUBTIME(NOW(), '0 0:30:0.000 ...
|
Ranking Mtk Volume
Thu, 25 Sep 2008 06:12:01 -0700
Hello,
Iâ??m trying to create a query that ranks my market volume from highest to
lowest. The rank needs to be in a separate field. Hereâ??s what I have:
<MKT VOL>
187
3
684
52
205
Hereâ??s what I need:
<MKT VOL> <RANK>
684 1
205 2
187 3
52 4
3 5
Any ...
|
