|
|
Count records within a range of values by
Steve
Please help me. I have a table with fields Salesman, Customer, Comparison(% of sales volume compared to last quarter). I would like a query that gives the...
|
|
1 |
560 |
|
|
Better Example of Count() Query by
Gary B
MASTER Table: CHARGES
Fields: ChargesKey, ChargesDate
Data: Row1 = 1, 05/25/2004
DETAIL Table: SERVICES
Fields: ServicesKey, ChargesKey, ServicesDate,...
|
|
1 |
269 |
|
|
can save the follwing queries by
Jonas
Hi
if I try saving the flowwing query access 2k crashes:
SELECT CAPTIONS.Key, CAPTIONS.Translation
FROM CAPTIONS, (SELECT ALanguage.ActiveLanguage AS...
|
May 25th, 2004 02:36 PM
by Jonas
|
0 |
362 |
|
|
Getting and setting information by
Jonas
Hi
I have one important question:
It so so easy to make powerful and fast queries on an access db,
but how can I write data more easily in a certain bd...
|
May 25th, 2004 02:44 PM
by Jonas
|
0 |
453 |
|
|
Access 2000 command buttons by
JKA
When I use the command button wizard to create any command
like "save" or "new record", I get the following error.
"
The expression On Click you entered as the...
|
|
1 |
356 |
|
|
Reminders by
Tara
I'm not sure I'm posting this in the right spot, but here
goes...I would like to design something to remind users
to run a certain report every thirty days. ...
|
May 25th, 2004 03:16 PM
by Tara
|
0 |
330 |
|
|
Help with simple query! by
v_roma
Hi everyone,
I've been trying to figure out how to do this query. I have a table and let's say it has three fields: site name, type of measurement,...
|
May 25th, 2004 03:24 PM
by
|
3 |
472 |
|
|
Appending Weekly Sales to a table by
ChuckW
Hi,
I have a table of 2004 sales and need to create a report
of weekly sales for the year. The data is stored in a
table called 2004Sales which is constantly...
|
May 25th, 2004 04:44 PM
by ChuckW
|
0 |
571 |
|
|
combo box has repeating options by
Jennifer
I was not aware of the "NotInList" event, and have
scratched the query that I mentioned before. I have
tried finding the code example through Access HELP,...
|
May 25th, 2004 05:31 PM
by
|
6 |
559 |
|
|
add column by
Dan
is there a way to add columns in a query for example
Loan officer # Loans
Dan 2
Ed 3
Frank ...
|
|
1 |
275 |
|
|
|
|
1 |
497 |
|
|
Text in IIf(,,) expression in query by
KaiRich
Hi all,
I have four fields, if any of them hold "Y" then I want
the query to return "Y" - but I only want one such field
in the query.
I have tried:
EMP:...
|
|
2 |
319 |
|
|
Reports from Cross-Tab Queries by
Jack
My cross-tab querie now works O.K. when passing parameters via the Query|Parameters route. And, of course, I can print the query results. But I want to do a...
|
|
1 |
442 |
|
|
Extract data by
Tony
I'll give it a whirl.
Thank you very much John.
Tony
"John Spencer (MVP)" wrote in message
...
...
|
May 25th, 2004 07:01 PM
by Tony
|
1 |
315 |
|
|
Excel vs Acess by
hermie
How can I implement the Excel COUNTA function in an Access query?
herman
|
|
1 |
287 |
|
|
trouble with query by
Gary B
MASTER
Table: CHARGES
Fields: ChargesKey, ChargesDate
DETAIL
Table: SERVICES
Fields: ServicesKey, ServicesDate, SalesRep
I need to return the Count of...
|
|
4 |
355 |
|
|
ODBC CALL FAILED by
bikermike
When we try to run a query that passes a date variable we
encounter "ODBC CALL FAILED". This is not happening on all
our computers but we can't seem to isolate...
|
|
2 |
743 |
|
|
Count Unique Values by
AHopper
The following query "SixDifinPackagedUniqueQuery", using
fields "JobNumber" and "UniqueLabelPack" from
table "SixDifinPackaged" gives me a list of unique...
|
|
6 |
704 |
|
|
Delete Record Based on Text Box by
James Stephens
I have set this up to work before with one text box, but I am struggling to make it work with 2.
Is there a way to make a delete query that will delete any...
|
|
1 |
537 |
|
|
help with not so simple query by
v_roma
I apologize for reposting my question. It's actually a
follow-up question, which seems more complicated than the
original.
Once more, for the sake of...
|
May 26th, 2004 02:28 AM
by ChrisJ
|
1 |
294 |