|
|
Long criteria list by
Dale Fye
Roman,
It really depends on how many of the 800 postal codes you want to use.
If you only want to use a couple at a time, then you could write a query
that...
|
November 30th, 2006 04:51 PM
by Dale Fye
|
0 |
94 |
|
|
|
November 30th, 2006 04:44 PM
by Dale Fye
|
0 |
86 |
|
|
Trouble appending values to a primary key by
Richie Rich
Hi everybody
Hope all is well;
1. I have 1518 records with the value RMG-1
2. I want each one following in this sequence RMG-1, RMG-2, RMG-3 etc....
Can...
|
|
0 |
95 |
|
|
Date Dif shown in Yr/mo by
KARL DEWEY
Try this but edit the field names ---
Expr1: Format(CVDate(DateDiff("d",,)),"yyyy")-1900 &
" " & Format(CVDate(DateDiff("d",,)),"mm")
The months may have a...
|
|
0 |
98 |
|
|
Date Dif shown in Yr/mo by
Bruce Meneghin
Try
Str(DateDiff(m,now(),) \ 12 ) &
"/" &
Str( DateDiff(m,now(),) Mod 12)
Note that the first expression uses the backslash operator to do division
and...
|
|
0 |
99 |
|
|
Query - Adding 50000 to an ID field by
Matt_Fairfield
hey all
I am looking to add 50,000 to an ID field i have and was wondering the best
way?
MSlink (original field) i want to add 50,000 to each record so i...
|
|
0 |
106 |
|
|
3rd place Query by
KARL DEWEY
There are several ways but try this as criteria --
Like "??1*"
"KAnoe" wrote:
How do I set up a Query that only looks at the 3rd place of a office...
|
|
0 |
92 |
|
|
Long criteria list by
Roman
Hi,
I have a very large linked table in Access. I need records only for sertain
postal codes. The list of postal codes is also very long (800 postal codes)....
|
November 30th, 2006 04:18 PM
by Roman
|
0 |
96 |
|
|
|
|
0 |
87 |
|
|
Query heading format: Tablename.Fieldname by
KARL DEWEY
Access automatically includes the table or query name for all fields that
have duplicate names in the output display.
"Roger" wrote:
Im running a query...
|
|
0 |
109 |
|
|
Date Dif shown in Yr/mo by
KAnoe
How do you make the date difference between now() and show
up as year/month
Thanks
Keith
|
November 30th, 2006 03:58 PM
by KAnoe
|
0 |
90 |
|
|
Trying to return unique records only by
kcsims
I have a query searching for due dates on an asset. Each asset is broken
down into subcatorgories with different dates due on each. I have this
expression...
|
November 30th, 2006 03:51 PM
by kcsims
|
0 |
95 |
|
|
3rd place Query by
KAnoe
How do I set up a Query that only looks at the 3rd place of a office ID?
Here are some of my office codes 1H1A, 1D1B, 1D2A, 1D2B, 2H1A, 6H3A, 4R1
Etc. How...
|
November 30th, 2006 03:45 PM
by KAnoe
|
0 |
84 |
|
|
Limiting the number of query returns by
Dave
I want to run a query that is grouped by city and product dollars in each
city. I want to limit the return to the top 5 products by dollars for each...
|
November 30th, 2006 03:31 PM
by Dave
|
3 |
84 |
|
|
Calculating group total in report by
Duane Hookom
Group your report by PositionID and display the Group Footer section. Add a
text box in the Group Footer section with a control source of:
=Count(*)
If you...
|
|
0 |
93 |
|
|
1 to Many. Duplicate field values by
Aquestion
Just wanted to clean the table up a little
Table 1
Month Month_Num Cost Center Manager Hours_1 TeamLead
Oct 10 1234567 ...
|
|
0 |
84 |
|
|
|
|
0 |
86 |
|
|
Is it Possible? by
Isaac Sanchez
I have a report that gets its data from a query
The query requires input to narrow down the selection.
The query pulls data to print a load order for a...
|
|
3 |
173 |
|
|
Calculating group total in report by
Danielle
the data fields include "positionID" and "employeeID" although numeric they
are text -- each employeeID is unique but the positionID can be attached to...
|
November 30th, 2006 01:57 PM
by Danielle
|
0 |
85 |
|
|
read-only by
Moz
Is there a way to make Tables and Queries to be "READ ONLY" in a
database which has been already converted to a "MDE" mode but other
than using "window...
|
November 30th, 2006 01:33 PM
by Moz
|
0 |
66 |