|
|
query grouping issue by
pat67
Hello All,
I am running a pool league and I am trying to create a query to show
each player's record vs other players. By the same token, each team's
record...
|
July 14th, 2009 06:34 PM
by pat67
|
6 |
94 |
|
|
SQL - Query count not working by
QB
Hello,
I have a first query which creates a base list from which I then base a
second query (the one I'm having trouble with) which does a basic count which...
( 1 2)
|
|
18 |
209 |
|
|
|
July 14th, 2009 06:02 PM
by Toan
|
6 |
117 |
|
|
Queries take FOREVER to run - ??? by
Bonnie A
Hi there. Using Access 01 on XP. A coworker sent me a question and other
than saying she needs to index her tables I'm not sure what to advise. Can
someone...
|
|
3 |
92 |
|
|
Using query like source for masses emails by
Alogon
Suppose a query with Field A and A1, A2, … are its values; Field B and B1,
B2, …
In a record, A1 could be associated with B1 and with B3 in another...
|
|
1 |
87 |
|
|
Distinct not working in 2007 as in 2003 by
Eldon
I am using a 2003-structure db file, necessary due to the need to keep
user-level security on the db, and a query that uses distinct that worked
fine when...
|
July 14th, 2009 04:09 PM
by Eldon
|
7 |
130 |
|
|
Multiple Dates in a table by
Pete
I have a downloaded table in which each item (primary key) has four date
fields in mmm-yyy format. Each date field has a corresponding quantity field...
|
|
1 |
83 |
|
|
Return only records with empty field by
Pamela
I want to create a report to track open assignments. My thought was to
create a completed date control on my form and run a report showing all
records that...
|
|
2 |
89 |
|
|
age groups by
Linda in Iowa[_2_]
I have an age field that is calculated from a birthdate.
I want to count the number of records in age groups such as 10-19, 20-29,
30-39, 40-49.
the...
|
|
8 |
146 |
|
|
Referring to fields in a subquery by
Leif
I'm trying to build a where clause, in VB, that refers to a field in a
subquery of a query. The field in the subquery is not exposed. I cannot
expose the...
|
|
1 |
131 |
|
|
Append with Criteria by
TinMan
Hi Everyone, I have 2 sub tables that are foreign key related (Reg No). I
need to move data from one table (t1) to (t2), where both the Reg No and
weekending...
|
July 13th, 2009 11:24 PM
by TinMan
|
2 |
93 |
|
|
Totals in crosstab query by
lmoisan via AccessMonster.com
Hi,
A while back, I submitted the following post and was provided with a solution
that worked. However, I now have an extra problem. I posted it but must...
|
|
0 |
105 |
|
|
Query ask two questions by
Rod
Hello,
My query asks two questions sequentially. It does an "Or" to find the
result. How can I have both of the questions come up together so the user
can...
|
|
1 |
116 |
|
|
Some text isn't recognized in report's query by
JimTrekker via AccessMonster.com
I am using a parameter query to gather specific text data from a table to
show in a report, and I know the text is in the table. If I request one
string of...
|
|
2 |
142 |
|
|
Returning maximum of 2 values by
William McNeill
I have a field in a query that multiplies 2 other fields and returns the
answer. It looks like this in design mode:
Freight: *
This gives me the freight...
|
|
2 |
116 |
|
|
Make Table Query by
rirus
I have several Excel Spreadsheets linked in an Access DB that I want to
combine into one table. All colunmn headers are identical in the Worksheets.
Manually,...
|
|
5 |
102 |
|
|
Nested If Statements II by
Alex Hammerstein
Hi,
I am slowly driving myself crazy...
I am trying to assertain the sum of the weeks that our students have been on
a course between 01/Aug/2007 and...
|
|
7 |
104 |
|
|
UPDATE Query by
fi.or.jp.de
Hi All,
I have userform in excel to search & get data from Access database.
I need to update some values from excel to access.
Right now i am using this...
|
|
0 |
96 |
|
|
|
|
1 |
145 |
|
|
Select Case with date range by
LouD
Hello,
I'm building a query and the if statement was too long so I had to create a
function with a select case statement. The problem I am having is with the...
( 1 2)
|
|
11 |
207 |