|
|
Query to return a subset of a set by
David Wetmore
I have an M2M relation with a link table (tblTagLinks) containing parent keys (PKey) and child keys (CKey).
I want to return the smallest set of PKey values...
|
|
1 |
138 |
|
|
|
May 10th, 2008 06:33 PM
by Naz
|
2 |
109 |
|
|
Strange values when summing in a query by
Kjell Harnesk[_2_]
Why is it that a query in Access resturns strange values when summing simple
figures.
Example: I have a number of records with a number field values like 8 ...
|
|
1 |
101 |
|
|
|
May 10th, 2008 11:19 AM
by Naz
|
0 |
93 |
|
|
Access and servers question by
Dupatt
I am getting resistance to using Access databases at work because some
people who I believe don't know what they are talking about. I am told that
when...
|
|
9 |
148 |
|
|
|
|
4 |
161 |
|
|
|
|
1 |
116 |
|
|
not display date in past by
H0MELY
Thank you for looking at my question.
I have a table that is full of information about phones and their
locations...we can call it a service file. The...
|
|
2 |
126 |
|
|
Month Captions and Labels by
Jasper Recto
I have table that has 3 fields.
Part Number DueDate Order Quantity
Using that table, I created a query that takes each due date for each order
and...
|
|
1 |
117 |
|
|
|
|
8 |
117 |
|
|
SQL Statment Help Needed by
Query Help
I have 22011 records in table "tblProcChargCounty " when I create a query
between this table and tblFacility table, I have 22011 records, but I try to
add...
|
|
3 |
133 |
|
|
Subquery help by
K
I think I can do this in one query but I am not sure the verbage. I have the
following scenario:
Lname FName DOS Provider1 ...
|
May 9th, 2008 08:26 PM
by K
|
2 |
83 |
|
|
|
May 9th, 2008 07:35 PM
by H0MELY
|
8 |
100 |
|
|
games on Excel by
Games will not open
I have several games that are on EXCEL that were working properly. Now they
will not open or load. What happened and how do I fix them?
|
May 9th, 2008 06:30 PM
by fredg
|
1 |
120 |
|
|
InStr with Or? by
yator
I was using the following InStr() to extract data from a field. The string I
am extracting begins with “!TCANC” and ends with an ASCII Null.
I have now...
|
|
4 |
106 |
|
|
SQL Help Needed - Revisited by
carl
I posted yesterday but did a poor job of explaining my task. I'm trying
again. My apologies. Thank you all who tried to help.
I need a query that will do the...
|
|
4 |
146 |
|
|
List all not in other table by
Question Boy[_2_]
I need to generate a list of all the Project Number in a table that do not
appear in another table How would the SQL synthax go?
Table 1
Name:...
|
|
2 |
92 |
|
|
90 day increments by
Annette[_3_]
I have a start date for a client stored in a table. Each client needs
to be reviewed every 90 days (do not care about working days or
holidays -- just a...
|
|
4 |
92 |
|
|
IF function in Query by
Supe
Can an IF function be used in a Query? I set up the IF function below to use
in an Excel worksheet to list the Banner name by searching for a name within...
|
May 9th, 2008 01:46 PM
by Supe
|
2 |
104 |
|
|
Create query that sums up categorical data by
Liz Yetter
Hi-
I need some help with Access 2003 queries. Please keep in mind that I
am NOT a programmer.
I have a table filled with gender (male or female), race...
|
|
2 |
104 |