|
|
many to many relationships by
KAT
Is there a way to take two sets of data that have a many to many relationship
and create a one to many relationship using a query?
For example: I have1...
|
March 2nd, 2007 03:01 AM
by KAT
|
9 |
127 |
|
|
combining 2 tables in a delete query by
crhp917
i have written 2 separate queries to delete an individual record in 2
separate tables by employee name with a "like " arguement. the
queries work as i need...
|
|
3 |
150 |
|
|
Query Help by
Need Help
am trying to build a database and need a query build to count times example
Hound Number 999 score 35 Time 11:00
Hound Number 999 score 30 ...
|
|
0 |
106 |
|
|
Minute Query by
Need Help
i am trying to build a database and need a query build to count times example
Hound Number 999 score 35 Time 11:00
Hound Number 999 score 30 ...
|
|
0 |
140 |
|
|
|
|
1 |
154 |
|
|
Query for groups of records by
Greg
I would like to know if it is possible to write a select query based upon
the number of records within a group.
I have a table with a primary key made up from...
|
March 2nd, 2007 12:52 AM
by Greg
|
2 |
102 |
|
|
Filtering a query by
Weezie1383
Hi,
I will do my very best to explain what I'm trying to do, but Microsoft
Access isn't my first language so be kind!
I am creating a database for a...
|
March 2nd, 2007 12:21 AM
by Smartin
|
1 |
123 |
|
|
Automatically Connect Tables by
Nigel
I have n access database which is split with the tables in one database and
the queries etc in another,
I have created a table called zztables and it is...
|
|
1 |
101 |
|
|
Help with Archival query by
Zeunasc
I have a table with the following columns: StudentName,
DatePointGiven, PointValue, Comments, Archived. I also have a table
with a single field: StudentName,...
|
March 1st, 2007 11:44 PM
by Smartin
|
1 |
96 |
|
|
|
March 1st, 2007 11:28 PM
by Smartin
|
3 |
131 |
|
|
problem with query by
Scuda
Hello all, I have run this query with other tables (basically the same) and
have not had a problem. Can anyone tell me if something looks wrong with this...
|
March 1st, 2007 10:18 PM
by Scuda
|
5 |
162 |
|
|
|
March 1st, 2007 10:16 PM
by Kent
|
5 |
167 |
|
|
key violation in append query by
Helen Martin
I have table A, table B and table C
table A contains contact information with a long integer primary key
called contactID as the first field..
table b...
|
|
2 |
93 |
|
|
Help with a query using wildcards by
Leon
I have a table with 12 fields, 3 of which are named Keyword 1, Keyword 2 &
Keyword 3 with each field and each record containing a keyword in the
appropriate...
|
|
1 |
95 |
|
|
|
March 1st, 2007 07:37 PM
by FL
|
2 |
107 |
|
|
calculating price returns by
Maursh
I am a newbie to MS Access and I am trying to convert a spreadsheet
into an access database so perhaps I need to design things
differently. Please forgive my...
|
|
1 |
112 |
|
|
|
|
1 |
82 |
|
|
Problems with February Dates by
Dawn
I have a database that has been running fine for years. When I change the
dates on the queries to pull the data for February, it is coming up blank on
one...
|
|
2 |
108 |
|
|
Update Query using Macros by
FL
Can I use an update query to update select records by specifing a Macro in
the Update To cell of the query? I need to populate other fields of many
records...
|
March 1st, 2007 05:40 PM
by FL
|
0 |
91 |
|
|
Need help with query by
Angie
I have two patient tables. One has patients with a certain condition, and
the other has patients with a different codes. Some patients have both
conditions...
|
|
1 |
120 |