|
|
Multi table query by
hkraft
Here's my problem...
I need to sort information by physician name. The name is pulled from
in the DICTMD table and is derived from in the Master
table. ...
|
July 2nd, 2009 09:16 PM
by hkraft
|
1 |
91 |
|
|
Add Table Name as Field in an Append Query by
Ripper
Is there a way to include a table name in a query?
Scenario:
Outlook Calendar exported to Excel
Database contains 16 linked tables that are named for each...
|
|
1 |
111 |
|
|
DatePart function by
Day of week
I need to find the day (Sun,Mon,Tues....) from a date field (6/9/2009). I
tried DatePart, However, all I get is a number. Can anyone help?
Thanks,
Jose
|
|
2 |
95 |
|
|
if else with insert update by
Andrew
Hi all,
I'm new with access queries, I've mostly delt with stored procedures.
Is is possible to write a query that has an
if/else statement e.g.
if KeyID...
|
|
8 |
128 |
|
|
Checkbox controlled criteria by
Kevin C Niven
I wonder if someone can help. Either I don't seem to be thinking very
logically this morning or I'm using incorrect syntax.
I currently have a query with two...
|
|
2 |
127 |
|
|
Another case sensitive query by
Taz
I'm attempting to link a field in one table to a field in another table and
it is only matching where the case of the letters match. All the fields in
one...
|
|
2 |
95 |
|
|
Top N Records on multiple fields by
CodeCrazy
Hello -
I have a table in access that I need to pull the Top 20 records for each
different concatenation field. Here is an example table:
Concatenation ...
( 1 2)
|
|
14 |
249 |
|
|
Conditional Count Column in Query by
pcbins
I have a table that shows:
REGION COND_A COND_B COND_C COND_D
NORTH N Y Y N
SOUTH N N N N
EAST Y Y N N
WEST N N N Y
CENTRAL N Y N N
I would like to run a...
|
|
1 |
83 |
|
|
Query with INNER Join by
Dale_Fye via AccessMonster.com
Can you explain a little more about your table structure and maybe give some
examples of the data? This may not be the most efficient way to do this.
My...
|
|
1 |
91 |
|
|
Moving records by
Neal Ostrander
I have a database where we input orders on a daily basis. I need to archive
these orders for possible future use. There are two tables that are used for
the...
|
|
3 |
241 |
|
|
Truncated Text by
Ronald W. Roberts
We use Access as a way for users to run queries against a large Oracle
database.
The MS access DB's uses a standard OBDC Link to attach the tables.
So all...
|
|
0 |
140 |
|
|
My append Query does not work by
Frank Situmorang[_3_]
Hello,
I do not understand my append qury does not work with message " Key
violation, I do not now what is wrong with this:
INSERT INTO bukuangkby (...
|
|
2 |
146 |
|
|
query by
alxw3 via AccessMonster.com
can't get this right. IN THIS SELF TUTORIAL I TRY TO REACH OUTPUT FROM TABLE1.
TABLE1:
DB G0 G1 G2 G3 J0 J1 J2 J3 N0 N1 N2 N3 A0 A1 A2 A3 B1...
|
|
6 |
123 |
|
|
Query with INNER Join by
NeoFax
I am having problems getting the below SQL to work:
SELECT tblResults.Team, Count(tblResults.Loser) AS WinsAgainst,
tblResults.Team1
FROM tblResults INNER...
|
July 2nd, 2009 12:11 AM
by NeoFax
|
1 |
87 |
|
|
function that returns the field name by
AccessMan
I have a need for a calculated field in a query based on an expression that
includes a function that returns a string containing a field name from an...
|
|
3 |
99 |
|
|
How to queryvery many conditions in VBA by
Jim[_58_]
I'm looking for a suggestion. As part of an ap, I have to find a set of
records with a very large number of conditions and am wondering if there is
a "best"...
( 1 2)
|
|
13 |
211 |
|
|
Inner join with some null values by
Jim[_58_]
Hi all,
Here's a mystery I need to find a work-around for. Maybe someone has a
simple solution.
As part of a de-duping process, I'm finding duplicates...
|
|
9 |
224 |
|
|
YES /NO Query by
Rpettis31
I have a query that I want to list of all records that do not have a yes it
is the yes/no data type and I am not familiar how you query from this data
type?
|
|
1 |
121 |
|
|
Subtracting timestamps by
Surayo
Hi, I have two fields both timestamped, in long format (i.e. 6/14/2009
10:39:58 AM) and I need to find out the time difference between them. I used
an...
|
July 1st, 2009 10:11 PM
by Surayo
|
2 |
110 |
|
|
|
|
1 |
107 |