|
|
Limiting a query by
Fay Yocum
I have a grant that one staff member's salary comes from. There can only be
one staff member that gets paid from that grant at a time. If this person
cares for...
|
|
1 |
306 |
|
|
"Fill-in data when there's no data" by
Gary Walter
Hi Bob,
I have helped several people do similar;
it is for sure doable and fairly straightforward....
but I would first like to know how you
will be limiting...
|
|
0 |
350 |
|
|
more dates!!! by
brigid
How is this any different than the current code?
-----Original Message-----
Hi,
.... WHERE myField BETWEEN Nz( Nz( StartDate, EndDate),
date() )
...
|
|
6 |
1,069 |
|
|
Convert data. by
Robert
I have a table with phone number that were imported in the
following format (212)-555-0440. The field is set to text,
with no input masks.
I need to convert...
|
|
2 |
300 |
|
|
three leters abbr for Day of week by
gal
Hi group,
I have a report that runs totals accompanied with the date
and the day of the week. All my days are being displayed
with three letter abbreviation...
|
|
2 |
332 |
|
|
Access 2000 SP3 Issues by
Paul Lockwood
Hello
We have just upgraded all of our machines to Office SP3.
Since doing this I am now getting a large number of errors
within Access db's.
A couple of the...
|
|
3 |
359 |
|
|
|
|
1 |
294 |
|
|
Using IIF statement in Memo Field by
J Cunningham
Hi,
I'm fairly new to Access, and I need to write a query which will check a memo field to see if it is null, then display "n" (for not having data in the...
|
|
5 |
924 |
|
|
Help!! withdrawing materials from a stock. by
Chris
In a form, i have a command button with a code like below, which is making a
sellection from a query (which represent the current state of a stock) to
display...
|
May 26th, 2004 06:14 AM
by Chris
|
0 |
295 |
|
|
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 |
|
|
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 |
540 |
|
|
Count Unique Values by
AHopper
The following query "SixDifinPackagedUniqueQuery", using
fields "JobNumber" and "UniqueLabelPack" from
table "SixDifinPackaged" gives me a list of unique...
|
|
6 |
707 |
|
|
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 |
744 |
|
|
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 |
357 |
|
|
Excel vs Acess by
hermie
How can I implement the Excel COUNTA function in an Access query?
herman
|
|
1 |
289 |
|
|
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 |
318 |
|
|
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 |
444 |
|
|
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 |
321 |
|
|
|
|
1 |
499 |
|
|
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 |
277 |