|
|
Complicated Query? by
hntsignif
I have a dbs with the following fields:
ProjMgr
ProjLead
ProjDesg
ProjEng
ProjQA
TeamM1
TeamM2
TeamM3
TeamM4
|
|
7 |
197 |
|
|
|
|
3 |
134 |
|
|
|
November 12th, 2009 08:53 PM
by ff
|
4 |
135 |
|
|
Appending to a data record by
BillA
I need to do a select query based on a date and then add a note to a field in
the database. In some cases there is already data in the field so I want to...
|
|
2 |
107 |
|
|
|
|
1 |
125 |
|
|
|
|
2 |
157 |
|
|
Crosstab query with multiple fields by
elena
Hi, All
My query:
PARAMETERS DateTime, DateTime;
TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks
SELECT AS Badge, Sum(Master.AmtVl) AS SumOfAmount,...
|
November 12th, 2009 03:48 PM
by elena
|
2 |
148 |
|
|
Joining or Combining two tables by
escuro19 via AccessMonster.com
Hi,
I spend alot of time trying to work this out but failed so please could
someone help.
Data:
(this table the intday varies depending on the...
|
|
3 |
181 |
|
|
|
November 12th, 2009 03:26 PM
by Brian
|
2 |
134 |
|
|
Select dates by
Saintsman
I have 2 tables - Jobs & Projects. One job can have several projects (or none!)
Table 1 holds job details (jobid; jobenterdate)
Table2 holds project (jobid;...
|
|
1 |
113 |
|
|
Max in sql passthru query by
dchristo
In the following there can be more than one (uniq_id) for the caseno in
dbo.master. I need the max(uniq_id) or last per caseno. I can do it when I
am only...
|
November 12th, 2009 02:52 PM
by dchristo
|
1 |
121 |
|
|
return a specific quarter data is in by
pat67
I am trying to total dat based on the quarter. I cannot find any
functions for this. Does anyone know if there is or how to do this in
a query?
|
November 12th, 2009 02:34 PM
by pat67
|
3 |
107 |
|
|
|
|
1 |
129 |
|
|
Finding Matching data by
Shon[_2_]
I have the following data;
Order Code Order Detail
100 AA
101 AA
100 BB
102 ...
|
|
6 |
137 |
|
|
Outstanding Drafts by
GreenSlime
In the course of our business process, we have to draft some documents and
send them to another department (DJ) for advice. I have a table called
"tblDrafts"...
|
|
2 |
152 |
|
|
Lost in time! by
Duncs
I'm having difficulty in understanding times (although I've used them
many times before) and getting the results in a query.
Here's what I have. I have a db...
|
November 12th, 2009 05:19 AM
by Duncs
|
5 |
262 |
|
|
|
|
1 |
126 |
|
|
help with by
Jimbo[_2_]
I want to know how many employees I have working in a given half hour
with the state licensure they have.
I have a table that has my employees, state...
|
|
1 |
104 |
|
|
Wrong Database Design by
Ralf
Dear All,
Currently I ask myself if the design of my database is wrong.
I have several tables with a lot of fields which use 'Value List' as a row
source...
|
|
2 |
123 |
|
|
How do I make a query return just 1 record by
Steve Haack
I have a querydef that returns a set of records, sorted by the ID
(autonumber) field.
All I need is the first record in the set. How can I tell the query to...
|
November 11th, 2009 05:32 PM
by fredg
|
2 |
127 |