A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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?
February 18th, 2010 04:51 AM
by David W. Fenton Go to last post
4 182
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 10:16 PM
by briank Go to last post
2 247
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...
February 17th, 2010 07:22 PM
by Daryl S[_2_] Go to last post
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...
February 17th, 2010 07:17 PM
by Daryl S[_2_] Go to last post
3 216
Update date field to Is Null in an update query by Owl
In an update query I have put "Is Null" into Criteria of a date field called RequestDate and the query works, but comes up with a message that it hasn't. ...
February 17th, 2010 05:31 PM
by Owl Go to last post
3 238
Query producing different results each time it is run by Tim Green
I have a database with a table linked to a FoxPro database. The table has over 600,000 records. I run a query that returns about 1500 of those records. But...
February 17th, 2010 03:30 PM
by Jerry Whittle Go to last post
2 224
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...
February 17th, 2010 01:36 PM
by Chantel33 Go to last post
3 173
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...
February 17th, 2010 09:14 AM
by naveen prasad[_2_] Go to last post
0 191
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...
February 17th, 2010 07:04 AM
by naveen prasad[_2_] Go to last post
1 218
Cant get Parameter Query to work even witht the help of Martin Gre by thebrat26
I am using Access 2007 and I have Membership Database in which I have created a query which asks for input from the user – Financial Year and Membership...
February 17th, 2010 03:38 AM
by thebrat26 Go to last post
0 244
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 02:57 AM
by cliff Go to last post
0 216
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...
February 17th, 2010 12:13 AM
by NEWER USER Go to last post
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...
February 16th, 2010 11:50 PM
by Marshall Barton Go to last post
6 456
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...
(Multi-page thread 1 2 3 ... Last Page)
February 16th, 2010 11:15 PM
by KARL DEWEY Go to last post
34 1,852
Concatenate multiple rows Into one Unique Identifier by garvic82
I need to concatenate multiple rows into one unique identifier. So, my unique identifier is #id. The number of multiple rows can vary for each #id and each...
February 16th, 2010 10:35 PM
by John W. Vinson Go to last post
1 321
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,...
(Multi-page thread 1 2)
February 16th, 2010 09:11 PM
by ryguy7272 Go to last post
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)....
February 16th, 2010 08:06 PM
by Jerry Whittle Go to last post
1 226
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 05:41 PM
by BlairH Go to last post
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 05:19 PM
by EAB1977 Go to last post
3 164
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:
February 16th, 2010 02:58 PM
by John Spencer Go to last post
2 203
Post New Thread


Display Options
Showing threads 1181 to 1200 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.