|
|
query a number stored as text by
Lee
I have a part number field that had to be defined as text due to the make up
of the part numbers. I need to query for a number and it will not find them.
How...
( 1 2)
|
|
19 |
1,232 |
|
|
Make Table Query - Sorting Errors by
Fred
I have a make-table query that is not sorting consistently. I am sorting on
one of the fields in the query, CAMPNO. I ran it once, and manually looked
at the...
( 1 2)
|
|
19 |
601 |
|
|
Non numeric data by
HelenJ
I have generated the criteria that I want to use to filter a sub report, into
a table (the values for this come from a list box), and since the criteria
need...
( 1 2)
|
|
19 |
265 |
|
|
Run-time error '3265' by
Ted
i'm using a2k and am starting to get the error in the heading about 'Item not
found in the collection' when i execute the following VBA code. i've read a
few...
( 1 2)
|
May 11th, 2006 03:56 PM
by Ted
|
19 |
236 |
|
|
Query Help by
Jay
I have a summary query where the records are grouped on the following
fields:
-SaleMonth
-Car
-MileageBand
-RegPlate
And the only other field, 'Price', is...
( 1 2)
|
|
19 |
204 |
|
|
Count Query by
WMorsberger
I have a few different tables that all have the same information in them but
the tables are split up by different departments. I want to do a total count
of...
( 1 2)
|
|
19 |
162 |
|
|
update query: still having problems by
scubadiver
I want to update a field called "rate" in the "department" subform table from
a field called "rate" in a temporary table called "sheet1".
I am getting...
( 1 2)
|
|
19 |
219 |
|
|
Export Query to Text File by
Big Dog
Using Access 2003, is it possible to have a query create a text file with no
user intervention? Thanks
--
Bill Gable
( 1 2)
|
|
19 |
232 |
|
|
Query not returning all values by
handsclark
I need to redefine the date of entries to match a 24 hour schedule that
starts and ends at 06:00 each day instead of 00:00.
I haven't been able to find...
( 1 2)
|
July 4th, 2007 02:40 AM
by SteveS
|
19 |
306 |
|
|
Accesss change text to number by
sierralightfoot
I have an access table
I want to change:
text field 444 444 444 to a number field 444444444
text field 444-444-444 to number field 444444444
( 1 2)
|
|
19 |
238 |
|
|
filtering by month by
Kelly
I have a database full of enrollment numbers for each month of the year. The
date field is formatted - m/yyyy. I want to do a query for September
enrollment...
( 1 2)
|
February 9th, 2006 09:39 PM
by SteveS
|
19 |
188 |
|
|
|
|
19 |
470 |
|
|
Using iif condition by
Alylia
I am working on a query that has a created column based on one column with
codes in a lookup list from a table in the database. This new column...
( 1 2)
|
December 8th, 2004 04:19 PM
by Alylia
|
19 |
261 |
|
|
help needed by
jkendrick75
I am needing a query to power a report that my boss wants done by this
friday. i have been working on this report for a couple of weeks now,
without getting...
( 1 2)
|
|
19 |
1,218 |
|
|
|
|
19 |
485 |
|
|
for by
Chris
Hi
I am trying to create a query to group pathnames when all I have in my
source table is a fully qualified filename.
ie I have a record that looks...
( 1 2)
|
August 15th, 2005 04:18 PM
by Bambi
|
19 |
350 |
|
|
Combo Box Query by
Oopesh
Hi,
I am having a lil bit of a problem trying to do the Following ...
I want to have a Query which brings up a Combo Box / Drop Down Menu,
when you choose...
( 1 2)
|
September 28th, 2005 05:47 PM
by Oopesh
|
19 |
256 |
|
|
Slow Append by
Chutney via AccessMonster.com
I am looking for a more efficient (read faster) way to append new records to
and update existing records in a master table.
My master table, tblMaster, is...
( 1 2)
|
|
19 |
351 |
|
|
Cross-tab Criteria not evaluating by
Juan Schwartz
I am running a query that prompts for a date and runs a week from that
day. Right now, no matter what is entered, it returns all of the
records in the table....
( 1 2)
|
|
19 |
367 |
|
|
Dates by
Lisa
I have a query that I want to compare food cost from month to month. I want
to parameter the months using a form. In the table the months are dates and
in...
( 1 2)
|
August 9th, 2007 08:22 PM
by Lisa
|
19 |
191 |