|
|
|
August 6th, 2004 05:21 PM
by Victor
|
13 |
1,194 |
|
|
create a form that collects parameters by
Kalai
Hi,
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in...
|
|
1 |
1,187 |
|
|
Currency Format Lost in Union Query by
Jill
Thanks to John Spencer, I resolved one problem in my union query (Thank you,
John). But I have another problem. Some of my fields in my union query are...
|
|
1 |
1,183 |
|
|
WORD XP mail-merge FAILS using ACCESS query by
SueMackay
I suddenly have a problem mail-merging labels and letters in WORD from an
ACCESS Database. I am guessing it is an incompatible problem but I just
can't seem to...
|
|
4 |
1,181 |
|
|
Query on a subform by
Jeffrey Marks
I have a form that displays an outing for members to sign up. There is
a subform where I display the members of the organization (via a combo
box), using a...
|
|
3 |
1,177 |
|
|
Joins on NULL Date values by
Andy
I have some queries whereby I need to join two tables based on two date
fields that are in both queries. Sometimes date 1 or date 2 will have NULL
values,...
|
May 28th, 2010 12:01 PM
by Andy
|
3 |
1,175 |
|
|
Next to Last Date by
slotmgr70
I have a table that tracks each customers visit to my store. I hold
promotions on occaision that bring customers that haven't visited my store in
awhile....
|
|
2 |
1,166 |
|
|
|
|
1 |
1,158 |
|
|
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,153 |
|
|
|
|
1 |
1,151 |
|
|
UNION Query truncating Memo fields by
Matthew DeAngelis
I came to this group to ask why I was losing most of my memo fields in
a UNION query, but John Spencer posted earlier that "Crosstab queries,
summary queries,...
|
|
4 |
1,146 |
|
|
Requery Combobox by
MJ
I have a combobox with an event that adds a record if
the 'id' doesn't exist. I try to requery the control
(combobox) but I get an error 2118 saying I must...
|
|
7 |
1,142 |
|
|
AVG Function in a Query by
JohnL
A table lists all the shipments by item, by order line, by date from the
year 2003 thru the present. One of the fields is a week number, YrWk, where
200420...
|
|
5 |
1,142 |
|
|
Blank Fields in NOT Null Query Criteria by
Steve Stad
Why would a few blank fields show up in a query where I am using 'Is Not
Null' in the criteria. The rest of the Nulls are filtered out - but there
are 7...
|
|
5 |
1,134 |
|
|
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,134 |
|
|
|
April 1st, 2009 02:03 PM
by Faye
|
3 |
1,131 |
|
|
Concatenate Text Fields to Date Field by
alhotch
I have three (3) columns in a table which represent the month, day, and year.
The values in these columns are 04 (month) 21 (day) 2010 (year). I want to...
|
|
5 |
1,129 |
|
|
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,127 |
|
|
Random Function for Selecting Records by
esn
Hi everyone,
This should be simple. I'm trying to pull one random record from each
group within a table. The groups are "Units" - geographic areas, and
I...
|
June 1st, 2010 08:19 PM
by esn
|
5 |
1,125 |
|
|
|
|
2 |
1,124 |