|
|
Combining Dup Info by
Jennifer
I have a table (tbl1) that has Invoice # and Item Desc as Fields (the info i
used is fictitious) :
Inv # Item Desc
50014 ...
|
|
1 |
228 |
|
|
Run a macro on a specific date - JCW by
JohnW
I have a macro set up that runs a MsgBox that I need to run on some specific
dates at the end of the month. I would like to run the macro on the 24th,
25th,...
|
April 15th, 2010 12:11 AM
by JohnW
|
6 |
267 |
|
|
|
|
1 |
171 |
|
|
Finding missing operator by
AccessKay
I was hoping that someone could give me some possible reason as to why I’d
get a missing operator error when my SQL is correct. It’s an IIf-DateSerial...
|
|
8 |
306 |
|
|
|
|
6 |
219 |
|
|
Querying for Extended ASCII Characters by
ftrujill0
I have an imported flat data file that has extended ASCII characters (i.e.
189, 239 and 191) in a Customer Name field. The extended characters are not
always...
|
|
1 |
185 |
|
|
parent child link query by
inungh
I have a query which has a parent and child link tables and would like
to have all the records in the parent even no child for this parent.
It seems MS Access...
|
|
1 |
183 |
|
|
dynamically choose columns in query by
mark
I'm trying to create a query such that when the user runs it, the proper
columns (fields appear). We have 12 columns, one for each month of our
fiscal year...
|
|
1 |
178 |
|
|
Date expression in Query by
Steve Stad
I am getting 'undefined function' w/this expression in my qry.
Expr1: IIf(today(),"cur","exp")
How do I insert or use todays date in a Query.
|
|
4 |
195 |
|
|
Find Replace values when they are not null by
teddyb777
I have a table that contains dollar amounts in random cells throughout the
table with the remainder of the cells containing nulls. I need to replace
every...
|
|
4 |
222 |
|
|
Append Query Question by
floyd33 via AccessMonster.com
Not sure if queries is the right place for this. Please redirect me if not.
I have three tables that interact on this process: ...
|
|
4 |
261 |
|
|
Average time from date column? by
GWB
I have a column that is in general date format, 6/19/2007 5:34:23 PM.
In another column I have a value between 10 and around 50. What I have to do
is get the...
|
|
9 |
180 |
|
|
Sum(IIF statement by
Jay
I have a large table that I want to query 2 things from. Please be patient
because I am pretty new at this.
I need to count the number of times that...
|
|
2 |
157 |
|
|
|
|
1 |
161 |
|
|
Opinion about aggregates by
AccessKay
I’m fairly new to Access so this may be an inane question to all those
experienced people out there. My question is about the use of aggregates in
a...
|
April 14th, 2010 06:47 AM
by david
|
8 |
235 |
|
|
Help with sample query. by
MN
Hi - I need to run a query to find out in a tableA field gender has some
other value than 1,2,3.
But this will product all records ! It was included...
|
|
8 |
159 |
|
|
select and count by
AJ
I have data to report on by area, priority and days past due (positive and
negative)
eg 0-6 7-14 15-28 etc
Newbee to Access, trying to create query by the...
|
April 14th, 2010 04:44 AM
by AJ
|
6 |
273 |
|
|
SQL to export query into table by
mario
Is there an SQL code or command in MS Access that allows me to export query
results into an table. I'm not worried about the redundancy part as it's a
small...
|
|
2 |
243 |
|
|
Deleting Duplicates by
Marc
In Access 2003 After running the duplicate query finding all the duplicates
how would I go about deleting them leaving one record.
|
|
2 |
183 |
|
|
Insert Multiple Records into a Table by
mario
Can I insert multiple records into a table using "INSERT INTO"., it seems it
can insert only one record at one time.
INSERT INTO Table1 (F1, F2, F3, F4)...
|
|
3 |
476 |