|
|
|
February 24th, 2007 02:01 AM
by Greg
|
0 |
121 |
|
|
Linked Tables in a query... by
Devlin
I am working with a simple select query. I have two tables of related data.
The first table is a list of transactions and the second is account...
|
|
1 |
167 |
|
|
|
|
8 |
136 |
|
|
In query records returned multiple times by
Serendipity
Using Access 2003. Trying to make a grading report that groups on fldyear,
fldquarter, fldSubject, fldLN/FN (trimmed field) and fldGradeWeight then I
want to...
|
|
6 |
159 |
|
|
Running Total Help by
OShea
A mate of mine recently posted a question that was given us a bit of
difficulty. We had a calculated field named FTE that maybe causing the issue,
as it...
|
February 24th, 2007 01:08 AM
by OShea
|
1 |
140 |
|
|
Import xls data by
JK
I have a excell workbook that contains 4 sheets each sheet representing a
country and each have the same columns of data.
Entry Date - Client- Acct Name-...
|
|
4 |
175 |
|
|
Date as "month" by
crtopher
I have a qry based on a table that has a date field; i want to have a column
in the query called 'Month' that displays the month of the date, as the
actual...
|
February 23rd, 2007 10:40 PM
by crtopher
|
4 |
173 |
|
|
Figured out one-to-many by
Serendipity
I figured out part of my not being able to get a one-to-many relationship. To
make sure that the properties of my foreign PK were the same as the PK, I...
|
|
0 |
137 |
|
|
Access Syntax Error by
hiteshiyer
I'm trying to get three buckets of users based on their variation in number
of transactions between two years. I get an error message stating
"Syntax Error...
( 1 2)
|
|
11 |
250 |
|
|
VB6/MSAccess Query Problem by
Ryan Prather
I created a program in VB6 and a DB in Access. The database has a
Artists, Albums, and Tracks table. I also have the same the in app. I
am trying to get...
|
|
0 |
109 |
|
|
Adding records by
EHOWE
I have a query with Person Creating Error and a total errors column.
My output looks like this:
Person Creating Error Total Errors
John Smith ...
|
|
7 |
227 |
|
|
Results based on 2 expressions by
JK
I have the expressions below which work but now i need a second expression
based exp1 which would subtract amount entered into
Transactions.WithdrawalAmount...
|
|
3 |
125 |
|
|
multiple conditions criteria iif? by
Starry
Hi
I cannot figure out how to test multiple conditions in a single grid field
as follows
Grp: IIf(IsNull(),0,1) else IIf(IsNull(),0,2) etc. etc.
two is...
|
February 23rd, 2007 09:10 PM
by Starry
|
5 |
201 |
|
|
Filter by absence of subform record by
BruceM
I have a table (tblPlan) for general information about a Processing Plan for
machine parts. It has a related Plan Details table (tblPlanSteps) for the...
|
|
2 |
128 |
|
|
|
|
0 |
97 |
|
|
|
|
10 |
212 |
|
|
Running Total in My Query by
Dingo
Can someone give a hand with adding a running total to my query, as I had a
bit of difficulty with it? As you can see 'FTE' is a caclulated field. What I...
|
|
5 |
295 |
|
|
Running Total in a query by
Nathan
I have read similiar threads on this subject but I just cannot get the syntax
to work out correctly - I have a lists of items (SKU) and how often they are...
|
|
1 |
136 |
|
|
Append duplicate invoice numbers by
T
I have a table that has invoices brought in from another program. The
table contains duplicate invoices. I created the find duplicates
query which is...
|
|
1 |
119 |
|
|
Trying to get a text count by
Frustrated in AL
I am trying to count the number of instances that a particular phrase appears
in a field. I have been able to have the phrase identified, but I cannot get...
|
|
1 |
137 |