|
|
Find any lower case in a field by
Jordan
We have a program that just moved to a MS SQL 2000 back end from Pervasive.
The old Pervasive backend would allow the same string in the primary key as
long...
|
|
2 |
193 |
|
|
|
|
4 |
212 |
|
|
|
|
2 |
297 |
|
|
Combining Duplicates in Select qry by
Jack Leach
Hi all, tia...
As of now I do this via DAO Recordsets, but I assume there must be a way to
handle it via query (also assuming that a query will always be...
|
|
3 |
332 |
|
|
Custom Function by
Dale
I am trying to create a tool for yearly employee performance reviews: each
employee is ranked on 5-10 different "competencies" and their behavior
related to...
|
|
6 |
248 |
|
|
Calender to switch to the month by
Leo
One of the control on the form is FldMon. It is a number field.
There is a calender on the form. It is ActiveX Control: Calender0
Class is...
|
April 26th, 2010 12:43 AM
by Leo
|
0 |
188 |
|
|
|
|
1 |
180 |
|
|
Access Queries by
Cindy Marie
I need to perform a query that will show me all of the items that were posted
between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please...
|
|
1 |
178 |
|
|
Iff Function by
Leo
The following is one of the fields in a query.
Expr3: IFF(DateDiff("d",,)=14,( & " X" & "
12"),( & " X" & " 6"))
and are datefields in the table...
|
April 25th, 2010 04:45 PM
by Leo
|
2 |
192 |
|
|
Duplicate a record by
Iram
Hello,
Is there an easy way to duplicate a record in a continuous form?
More yet, how would you write a query to duplicate the current record based.
I would...
|
|
1 |
322 |
|
|
Query or Table Description by
VB1022
all my database are developed in Access 2003... When viewing the queries in
2003 there is a 'Description' field. This is always viewable for all queries
AND...
|
|
1 |
164 |
|
|
Surprisingly fidly query? by
Leslie Isaacs[_2_]
Hello All
I'm sure this should be simple - but can't seem to get it!
I need a query that takes various integer values (say 'monthnumber'), and
returns an...
|
|
2 |
195 |
|
|
|
|
4 |
219 |
|
|
Viewing expressions in a listbox by
Peter Stone
Access 2003, XP pro, semi-novice
I have a table "Expression" where records are similar to the one below:
& " " & & " is " &
& " " & & " " & & " has a...
|
|
0 |
203 |
|
|
List of where queries are used? by
Joseph Greenberg
I have an access database which has many queries which are leftover from
various tests and temporary data extract needs. Is there a tool which can
tell me...
|
|
2 |
252 |
|
|
Min Funtion by
CK
My query is based on one table listing employee names, ids, and salary. In
my query I used the min funtion to display the lowest salary; however, I'm
not...
|
April 24th, 2010 05:36 PM
by CK
|
2 |
166 |
|
|
How to combine queries???? by
Joseph
I have two related queries/tables.
One:
TRANSFORM Max(MeritsMain2Total.Total) AS MaxOfTotal
SELECT CadetsName.CadetID, MeritsMain2Total.CadetName,...
|
April 24th, 2010 05:05 PM
by Joseph
|
2 |
181 |
|
|
Show only once by
samotek via AccessMonster.com
I have a query consisting of the fields productid and customerid.It shows the
products bought by the customers.These products are bought with...
|
|
1 |
172 |
|
|
OpenDiagBox by
NoodNutt
Hi there everyone
At present, I setup the function that calls the Open DiagBox, which works
well, with the exception of including the shell commands that go...
|
|
2 |
206 |
|
|
text format to date format by
Achit via AccessMonster.com
I have 2 question:
1. I export data from excel 4.0 to Access 2003, in Excel my data have text
format, I want change data to date format...
example my data in...
|
|
2 |
176 |