|
|
Retrieve Info from two tables by
Fernb2000
Hello;
I have two tables
Table 1 Rx
-------
RxNumber, RxId(no duplicates), RxDate, Name, Notes, Type, DOB
Table 2 Email
-------
|
|
2 |
108 |
|
|
Max(), Min() Problem by
Ken
I have a table with several "ref" values for a given "SH". I would like to
find the min and max ref per sh. I have:
Select sh,MAX(rm) as Maxrm, MIN(rm) as...
|
August 8th, 2005 04:07 PM
by Ken
|
2 |
80 |
|
|
Filtering Duplicate Values in a Query by
droyer
I am trying to find the total number of bank accounts for each month. The
table I am working with has a card number and a transaction date. I group by
card...
|
August 8th, 2005 03:46 PM
by Dennis
|
1 |
108 |
|
|
Date criteria by
MLT
I have a query with two fields; a PC ID number, and the date it last backed
up. I want the query to return any PC that hasn't backed up in the past 7
days. ...
|
August 8th, 2005 03:39 PM
by fredg
|
3 |
67 |
|
|
count if or equivalent by
Matt
I read a lot of responses and I'm not seeing what I'm looking for. I would
like to build a query to count how many times a certain name is included in
the...
|
August 8th, 2005 03:05 PM
by Matt
|
3 |
95 |
|
|
or in query by
dlb1228
im doing something i thought was very simple. i have 4 fields in my select
query.
the year field which is set to group by, Loan amount set to count, race...
|
August 8th, 2005 02:54 PM
by dlb1228
|
1 |
62 |
|
|
count query by
Lori
I need to write a query that counts number of unique occurences of a
combination of 3 fields in the same table (Inventory): PC Brand, Operating
System, and...
|
August 8th, 2005 02:11 PM
by Lori
|
3 |
100 |
|
|
Query from 3 other Queries by
ShdwRider99
Ok I am trying to generate a query using 3 other queries. I'm having success
so far except for 1 problem. The "Briquetting Rate Query" looks fine on its
own,...
|
|
1 |
293 |
|
|
30/60/90/120 Aging by
Gary B
Help! I can not solve this. Must be SQL, as I connect through Jet.
Pmts not fully Applied (such as clients who prepay), must be accounted for.
Database...
|
|
1 |
117 |
|
|
One to Many Relationship by
vernon
How do I set up an autoupdate query (using a form) that will automatically
popuplate a table with data from another table? Example of the table...
|
|
3 |
72 |
|
|
Dynamic List of data to search on? by
Dominic H via AccessMonster.com
I have a table (called TABLE A) which looks like this:
WORD | onum | nnum |
SCHOOL | 55569 | 99999 |
ENGINEER | ...
|
|
2 |
89 |
|
|
Query Help by
Fupp83
I have a table that has six columns: Project Name, Project ID, Address, Legal
Description, Cross-Reference, and Box Number. I want to create a query where
a...
|
|
4 |
77 |
|
|
|
|
2 |
68 |
|
|
|
|
8 |
109 |
|
|
|
August 8th, 2005 06:22 AM
by Greggo
|
2 |
86 |
|
|
update query does not seem to run by
Bill_De
I am having trouble with an update query executing. The query only runs when
I go to the objects window and double click on the update query "Reserve
Room"....
|
|
1 |
75 |
|
|
SQL querie by
open a adobe file from a command button
Would someone please explain why this does not work!! I have a table with
different values in it and all I want to do is write a query that tells me
the...
|
|
3 |
105 |
|
|
Yes/No Querry by
Fred Peters
I'm setting up an awards database. I'll have 30 people and 50 awards. I
need a querry to select LastName and only pull up the checkboxs that are
checked yes....
|
|
7 |
99 |
|
|
Append Query Criteria by
Procyan
I can't figure out how to write a criteria with Access 2003 for this
situation.
I would like my AppendQuery to only pull the data from the record set that
has...
|
August 8th, 2005 12:16 AM
by Procyan
|
2 |
99 |
|
|
Numbering Date by
Duane Hookom
There were a number of issues with the attempts.
1) ACTDATEs were not unique for IDENT values with a "Q" value in QUALTYPE.
2) There were records with no value...
|
|
0 |
64 |