|
|
Need help with concatenation function by
EllenM
Hello,
I've found a wonderful concatenation function at
http://www.mvps.org/access/modules/mdl0008.htm. It, however, separates the
concatenated values with...
|
May 21st, 2010 08:34 PM
by EllenM
|
4 |
1,002 |
|
|
|
|
4 |
838 |
|
|
Export to Text Files Based on Field Value by
Leviathan via AccessMonster.com
I have an Access table with personal information (e.g., first name, last name,
birth date, etc.) for thousands of people. The table is sorted by state. I
want...
|
|
1 |
795 |
|
|
Total - Total Fields in a Totals Query by
JK[_4_]
Any idea why this won't work?
TotalDays : nz()+nz()+nz()+nz()+nz()
I get an error that say:
SubQueries cannot be used in the expression.
Any help would be...
|
|
1 |
825 |
|
|
Help with small result type by
Alain
Hi to all expert,
I am running kind of a complex query and I want to know why I get the result
as a string instead of a number/currency, the math is good...
|
May 21st, 2010 04:11 PM
by Alain
|
2 |
786 |
|
|
Past Due Expression by
Hank
In a child day care center database at church, I have used the following
expression in a PaymentQry to determine a past due amount.
PastDue:...
|
|
1 |
771 |
|
|
Crosstab queries, and null values by
Edwinah63
Hi everyone,
I have a crosstab query attached to a graph on a report. It shows
quantity of widgets produced by each employee for a specified period.
The...
|
|
3 |
1,055 |
|
|
Querying 2 field unless duplicated by
DC1
New at this, so please bear with me:
I am looking to merge 2 fields unless duplicated. The fields are in the same
row in the same table Female Surname & Male...
|
|
2 |
758 |
|
|
Union Query Access 2007 SP2 MSO by
Bruce
I have a union query that keeps telling me that there is a data type
mismatch. When I first run the query everything is okay and it displays the
fields...
|
May 21st, 2010 10:20 AM
by Bruce
|
7 |
1,068 |
|
|
Access 2003: Select Next Item in Combobox by
eckert1961
Hello,
I have a combobox on a form and currently I manually select the next item
for a member as needed. This is fine for 1 or 2 but typically I have to do...
|
|
5 |
824 |
|
|
Multiple Totals Columns in a Pivot Table by
Danny
Hi.
I've built a pivot table, and get totals values displayed as expected. In
this case, it's a count of records.
But I also want to see values for several...
|
|
3 |
848 |
|
|
Need Help with Totals Query by
SSi308
I have a table with daily call records. The table includes fields for:
Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed;
Locale;...
( 1 2 3)
|
|
24 |
2,046 |
|
|
delete query by
inungh
I would like to delete first 3 records of the table.
I know that I can set criteria to delete certain records in the table,
but are there any way to set...
|
May 20th, 2010 05:21 PM
by inungh
|
3 |
691 |
|
|
90 days and the first of the month by
Gaetan via AccessMonster.com
I'm trying to figure out hoe to calculate 90 days from hire and the first
of the month
Example:
HiredDate Insurance activated
1/3/2010 ...
|
|
4 |
723 |
|
|
|
|
0 |
719 |
|
|
count qry by
StuJol
using access 2003 i have the following qry
SELECT DateSerial(Year(),Month(),Day())
AS , ., .Parameter, .Desc2,
Count(*) AS MyCount, .Module
FROM
GROUP BY...
|
|
2 |
740 |
|
|
delete files by
PANOS via AccessMonster.com
Good morning and thks for your help,
1. Have on acces Qouestion with the following
CODE
02304
02305
02306
Code is the item No
2. I have folder one my pc...
|
|
1 |
812 |
|
|
|
|
4 |
897 |
|
|
Calculating Elapsed Time by
Machyde
How do I calculate elapsed time in a simple query when the starting time is
before 00:00 and the end time after 00:00 ... all I'm getting at the moment
is a...
|
|
3 |
858 |
|
|
|
|
3 |
721 |