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 Replies Views Reverse Sort Order
Query in a query by PPerry
I have a query (thanks to this group) which returns the very last date in a sequence. This query works great. I now want to use it in another query where I...
June 2nd, 2004 05:53 PM
by Michel Walsh Go to last post
1 1,239
Left join in query by Tara
I have a query set up with a one-to-many left join on two tables in order to pull all records from one table (the "one" side) and the corresponding records...
(Multi-page thread 1 2)
May 24th, 2010 04:21 PM
by Bob Barrows Go to last post
14 1,232
"UNION" Query with different fields in the two tables by Dkline
I have two tables. The tables have different fields and number of fields. They each have one field in common "PolicyNumber". What we want to do is to have a...
July 30th, 2004 09:05 PM
by Dkline Go to last post
5 1,219
SELECT function in Query by alexparks
I am entering this following command in a query and I am getting the following warning: "The syntax of the subquery in this expression in incorrect. Check...
July 5th, 2004 11:31 AM
by alexparks Go to last post
9 1,215
"Corrupted" query by Jeff J
Using Access from Office XP I have written a query as part of a Query by Form operation. I have an unbound form with 7 text boxes and the query has 7 "columns"...
August 12th, 2004 07:51 PM
by Jeff J Go to last post
8 1,210
Semicolon delimited text query help by Al Guerra
I did not design this. I have two tables, table A has a field "Link" that is of type string and contains a unique 30 character string (700 hundred of them)....
August 12th, 2004 11:50 AM
by Van T. Dinh Go to last post
3 1,209
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...
(Multi-page thread 1 2)
October 13th, 2004 04:10 AM
by Ken Snell [MVP] Go to last post
19 1,208
Flag a value in a group... by Jack Leach
Hi all, tia for any insight. I have the following query that gives some totals for qty's in a releases table, pulling and grouping information (part number,...
May 17th, 2010 07:48 PM
by Daryl S[_2_] Go to last post
4 1,206
Partial Name Prompt Question by bdehning
I currently have the following SQL which works fine but requires me to enter the whole Servicing Division such as Henderson. How do I add Like & "*" without...
(Multi-page thread 1 2 3)
August 1st, 2004 03:35 PM
by Gary Walter Go to last post
21 1,201
append queries records with multivalue fields by Dawie Theron
I need to append a number of tables. I make use of an APPEND QUERY and it works fine. BUT, for one part of my application, I need to work with tables which...
March 3rd, 2010 05:24 PM
by PieterLinden via AccessMonster.com Go to last post
4 1,195
"Effective Date" Criteria for Rates by Jason V
I have been stuck on this for some time now. I will try to make it as clear as I can. I need to create a Report of “transactions” (days worked of...
(Multi-page thread 1 2)
October 25th, 2005 11:00 PM
by Jason V Go to last post
13 1,181
sql union self-join syntax by SillySally
Hi. I can't seem to get my syntax correct. I hope the first part of the union query will give me everyone with a SignificantOtherID (avoiding duplicates) and...
(Multi-page thread 1 2 3)
March 18th, 2005 04:25 AM
by SillySally Go to last post
27 1,179
Return repeats info in "8s" by Joy Rose
I have the following Accounts Receivable Aging query. SELECT DISTINCTROW Sum(IIf((Date()-)31,*(1+)+-nz(),0)) AS , Sum(IIf((Date()-)61...
(Multi-page thread 1 2)
October 13th, 2004 10:07 PM
by Ken Snell [MVP] Go to last post
14 1,175
Seemingly (and probably) complex turnaround time by rgrantz
This is mostly complex because of the existence of 2 tables, not just one, but I imagine I'd have a tough time with just the one anyway. I'm trying to build a...
March 21st, 2005 10:19 AM
by Andreas Go to last post
1 1,156
Repost: Calculation problem. Someone help! by Victor
I am reporting due to lack of repsone. However, I really owuld like some help on this. I have a table which looks like this: ClientID ID Description ...
(Multi-page thread 1 2)
August 6th, 2004 05:21 PM
by Victor Go to last post
13 1,154
JOIN Query very slow by Tally.NET
Hello, I have the following Input tables Table1 Serial Item Date SerialandDate 123 Item1 01-04-2007 12339173 123 Item2 01-06-2010...
June 6th, 2010 09:07 PM
by John Spencer Go to last post
4 1,152
in access, round up to nearest fraction(.5) by Stephengw
In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to...
May 19th, 2010 07:56 PM
by Daryl S[_2_] Go to last post
1 1,151
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...
(Multi-page thread 1 2)
March 17th, 2005 03:37 PM
by jkendrick75 Go to last post
19 1,147
Access 2000 to 2003 mail merge to word by JJ
The DB we have was created in 2000. On my test computer, I upgraded to Office 2003 and am testing the mail merge. We run the query to get the information and...
June 23rd, 2004 06:41 AM
by Albert D. Kallal Go to last post
1 1,135
Access Function like Excel Mround function? by Faye
I need to round either up or down to the nearest quarter. Is there a function in access that works like Mround in excel where I can pass it the number and...
April 1st, 2009 02:03 PM
by Faye Go to last post
3 1,129
Post New Thread


Display Options
Showing threads 121 to 140 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 02:26 PM.


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