|
|
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 |
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 |
920 |
|
|
|
|
1 |
293 |
|
|
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 |
354 |
|
|
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 |
329 |
|
|
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 |
298 |
|
|
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,063 |
|
|
"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 |
347 |
|
|
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 |
304 |
|
|
string by
Allouche Patrick
Salut j'aimerai remplacer un carctere present plusieur fois dans une chaine
?
1-2-3-4-5-6 deviendrai 1 2 3 4 5 6 donc '-' par ' '
ou encor inser un espace ce...
|
|
1 |
334 |
|
|
Unmatched Query by
I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?
Any ideas?
|
|
1 |
1,112 |
|
|
|
May 26th, 2004 03:31 PM
by JonR
|
3 |
729 |
|
|
Crosstab Report and query by
Newbie
Hi,
I have the following query - see below
I want a report that is based on week number - the actual week number needs
to be on the report.
I have written a...
|
May 26th, 2004 05:11 PM
by Newbie
|
4 |
744 |
|
|
|
May 26th, 2004 05:15 PM
by
|
2 |
463 |
|
|
Please help me!!! by
Ann
Hi to anyone who can help.
I have a table with the following fields:
Last Name
First Name
Course ID 1
Course date req 1
Course ID 2
Course date req 2
|
May 26th, 2004 06:17 PM
by Ann
|
2 |
345 |
|
|
Crosstab Query Help by
Newbie
Hi,
I have the following query
PARAMETERS !frmMetalRequirements! DateTime;
TRANSFORM Sum(tblMatlSchedule.OSQtyReqd) AS SumOfOSQtyReqd
SELECT...
|
|
1 |
291 |
|
|
Convert grouped records into a string by
mmattson
I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date...
|
|
1 |
421 |
|
|
crosstab query not showing all values by
Michel Peeters
I have a crosstabquery.
The 8 column headings are weeknr based on DateDif.
The value is the sum of Kg (double)
The rowheadings are fields from the customer...
|
|
0 |
533 |
|
|
Multiple Append Queries to One Table by
wpshop
I have a table with 5 fields. Each field's value can be calculated by using a Query to run a count on existing information in the main table. I can change...
|
May 26th, 2004 07:51 PM
by wpshop
|
2 |
632 |
|
|
Return String from Boolean Field by
Dragon
Hi,
I have the following query collecting data from a table where 'Complete'
field is a yes/no field. I am exporting this data for a PDF merge and what I
need...
|
May 26th, 2004 08:08 PM
by Dragon
|
2 |
397 |