|
|
Access SQL Query by
[email protected]
Primary Keys are in " "
Database Tables:
department ("deptNum", deptName, deptCity)
employee ("empNum", empName, empCity)
project ("projectNum", projectName,...
|
|
1 |
112 |
|
|
Query: Sum column with Duplicate Values by
KARL DEWEY
Change the table structure to this one-to-many --
AutoID - primary key
Month Name
Month Number
Cost Center
Manager
AutoID - foreign key
Team Leader
Hours
|
|
0 |
72 |
|
|
Question about syntax by
Nanette
Hi Lori,
I tried a similar query on my DB and it worked. Try copying the syntax style
to yours:
SELECT tblCabinets.CabPN, tblCabinets.CabDesc
FROM...
|
November 29th, 2006 09:59 PM
by Nanette
|
0 |
74 |
|
|
|
|
0 |
72 |
|
|
Converting a number into Hours and Minutes by
Karrie
If I have a task that takes a total of 78 minutes, how do I create a query to
convert total minutes into hours and minutes? My answer will be 1 hour and
18...
|
|
5 |
80 |
|
|
Question about syntax by
Lori
SELECT NAMES.,NAMES.
FROM NAMES
WHERE (((NAMES.)="1010"));
Here is my syntax, what is wrong with it? I keep getting an error message.
|
November 29th, 2006 09:30 PM
by Lori
|
0 |
69 |
|
|
advanced top 100 list query by
wb
I am trying to create a list of top 100 customers by spending for each
store.
I can successfully create the list of top 100 customers for all stores, but
when...
|
November 29th, 2006 09:21 PM
by wb
|
5 |
92 |
|
|
Pivot by Date Range by
WAstarita
I have a payroll database that daily I have to check if everyone's time
sheet has been submitted. I would like to automate the query by being
about to supply...
|
|
5 |
183 |
|
|
Part Numbers Change after Importing by
Jerry Whittle
Create a new table that has all the fields needed to import the Excel
spreadsheet. Make sure that the problem fields are text datatype. Import into
this new...
|
|
0 |
82 |
|
|
Very Tricky Query by
Grd
Hi,
I have a Bonuses Table with three Bonuses Amounts and the dates that the
bonuses came into effect
1 100 1/1/2000
2 200 1/1/2001
3 300 1/1/2002
I have...
|
November 29th, 2006 08:38 PM
by Grd
|
0 |
75 |
|
|
|
November 29th, 2006 08:37 PM
by Nini
|
0 |
63 |
|
|
Query by
Jerry Whittle
SELECT EL.*
FROM EL
WHERE EL.PrimaryKeyField NOT IN
(SELECT O.ForeignKeyField
FROM O
WHERE DateField = WhatEverYouAreUsingForMonth) ;
One problem with...
|
|
0 |
86 |
|
|
|
|
0 |
81 |
|
|
Update query by
ladybug via AccessMonster.com
I have two tables. The first table has program names (Program) as it's first
field. It stores other program info in it as well.
In the second table it has...
|
|
7 |
91 |
|
|
|
November 29th, 2006 07:44 PM
by Satyam
|
2 |
124 |
|
|
Trim and Distinct by
Nanette
I answered my own question.
I went into Excel to trim the data first. In a separate column I input
"=TRIM(A2)" then copied that for all the necessary rows....
|
November 29th, 2006 07:41 PM
by Nanette
|
0 |
76 |
|
|
|
November 29th, 2006 07:17 PM
by ChuckW
|
0 |
74 |
|
|
|
November 29th, 2006 07:15 PM
by TedMi
|
0 |
73 |
|
|
Query by
ChrisM
Query MESS... Please Rescue
Query - Perfect Attendance
Tables - Employee List; Perfect Attendance;Occurances
Perfect Attendance is based on no occurances...
|
November 29th, 2006 07:07 PM
by ChrisM
|
0 |
78 |
|
|
|
November 29th, 2006 07:01 PM
by Krista
|
0 |
73 |