|
|
Spliting First Middle and Last Name by
lindag
We have fields that are LastName/FirstName Middle and sometimes a
number, ex. Smith/Linda S 3. Any suggestions how to split up and
not include the number?
|
|
4 |
199 |
|
|
Setup of Design View by
briank
I have inherited an Access 2007 db. Upon reviewing the selection of queries
I see that the previous developer preferred to view the query in much
different...
|
February 17th, 2010 09:16 PM
by briank
|
2 |
264 |
|
|
Error -1524 by
LarsM
I got the message "Reserved error (-1524); there is no message for this error".
Background: I have a database system with several identically structured
back...
|
|
1 |
263 |
|
|
complicate query? by
hoachen
Tab1: Item#1, Item#2
Tab2: Item#1, Title, actor, year
I used inner join to join Tab1.Item#1 and Tab2.Item#1 with a filter on Title
(like "dvd*) this return...
|
|
3 |
216 |
|
|
|
February 17th, 2010 04:31 PM
by Owl
|
3 |
255 |
|
|
|
|
2 |
241 |
|
|
Query to pull set criteria or all by
Chantel33
I have the following query:
SELECT .Username, .Task, .Product, ., ., ., .Status, (-) AS Expr1, .Area
FROM INNER JOIN ON .Task = .
WHERE (((.Username)=) AND...
|
|
3 |
190 |
|
|
2nd time posting this problem, pls help by
naveen prasad[_2_]
Dear Kindly solve my problem
table t1 has fields pictures, name
in design view pictures field is ole object and
name field is text.
now in table, i have...
|
|
0 |
207 |
|
|
OLE object open problem by
naveen prasad[_2_]
Dear Kindly solve my problem
table t1 has fields pictures, name
in design view pictures field is ole object
name is text.
now in table, i have inserted some...
|
|
1 |
235 |
|
|
|
|
0 |
261 |
|
|
hepl to solve my problem by
cliff
Question
Hi, I am new to access but i have the following to complete. Please help me
out
Interest rate
scheme date period rate
FDR 1/1/2000 1 YEARS...
|
February 17th, 2010 01:57 AM
by cliff
|
0 |
232 |
|
|
Grouping Data Fields by
NEWER USER
Can the following be accomplished in Access 2K3?
Name City
ABC123 Tampa
ABC123 Orlando
ABC123 Miami
I want to group on...
|
|
4 |
226 |
|
|
Another Len function not working by
Afrosheen via AccessMonster.com
Thanks for your time
I have this code:
Private Sub txtUser1_AfterUpdate()
On Error GoTo txtUser1_AfterUpdate_Error
If Len(Nz(Me!txtUser1, "")) = 0...
|
|
6 |
478 |
|
|
AT WITS END ON QUERY TOTAL by
lmiller
I want to thank anyone in advance for any insight into this. I have posted
this question a couple of times and have been working on developing this
query...
( 1 2 3 ... Last Page)
|
|
34 |
1,899 |
|
|
|
|
1 |
338 |
|
|
Calculate Average Returns Based on Dates? by
ryguy7272
I’m using the below SQL, which works perfectly well. I’m trying to figure
out a way to add in a little calculation for mutual fund returns for 1-month,...
( 1 2)
|
|
12 |
392 |
|
|
Sorting in select query. manually by
Boon
Hello,
I have a select query and I would like to sort on the field month. but I
want to be able to specify the order myself (not descending nor ascending)....
|
|
1 |
243 |
|
|
Extract 5 digit number from a column by
rachlh22
I am trying to extract a 5 digit number from a comments field. The comments
field has no formatting, and the 5 digit number may appear anywhere within
the...
|
February 16th, 2010 04:41 PM
by BlairH
|
7 |
274 |
|
|
Help with a simple query by
EAB1977
Hi guys and gals,
Can anyone help me with this query? I am having some issues with
pulling in all names even though (it appears) I have the join...
|
February 16th, 2010 04:19 PM
by EAB1977
|
3 |
180 |
|
|
parse data by
jhicsupt
I get an Error when there is no ".".
If field is blank, how do I just return an empty/blank field if there is no
".".
"John Vinson" wrote:
|
|
2 |
220 |