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
FROM and JOIN Problems by mat_splat
Probably basics to you guys but still having loads of trouble and would appriciate any help. I have a table "tblNames" consisting of I have another table...
May 13th, 2010 12:03 PM
by Ken Snell Go to last post
1 234
Query, linked tables by Ioia
I have a table called tblPA where all personal data of Personal Assistants (PA) is recorded, being PaID the primary key. The second table linked by PaID as...
May 13th, 2010 11:20 AM
by Ioia Go to last post
2 272
aggregate query by Frank De Wael
Hi, I'm successfully grouping an articles table by Category, ProductGroup, and ProductFamily; Since this query is used to select 1 article I needed the...
May 13th, 2010 10:43 AM
by Frank De Wael Go to last post
4 190
Is there anything wrong with the syntax by Syphonics via AccessMonster.com
It gave me synatx error from clause? SELECT GL Finance Credit Query.* FROM GL Finance Credit Query UNION ALL SELECT GL Finance Debit Query.* FROM GL...
May 13th, 2010 07:25 AM
by Syphonics via AccessMonster.com Go to last post
2 235
Problem with query by kc-mass
I have not seen anything like this before but: 1. I am querying a table with completed invoices to get those from a selected fiscal period. The period...
May 13th, 2010 01:21 AM
by kc-mass Go to last post
2 166
Query results where gaps exist Min & Max do not work by SloppyJavaJoe
Hello all, I was using a min and max on the specimen id here to show the first and last specimen worked on, however; that doesn't work when a gap in the...
May 12th, 2010 11:30 PM
by SloppyJavaJoe Go to last post
5 189
Real 10 random records by Ljudmil
Hi, I have a query which gives me 10 random records. SELECT TOP 10 Basis_.t, Basis_.r, Basis_.Basis_code FROM Basis_ ORDER BY Rnd(Basis_code); Basis_code is...
May 12th, 2010 10:35 PM
by John W. Vinson Go to last post
7 297
Group By or MAX Question by Toria
I have a root ID field. I have a close date field. There can be more than one record with the same root ID. I need to pull only one of them with the latest...
May 12th, 2010 09:36 PM
by Marshall Barton Go to last post
3 175
filtering data by Jan
I have a database set up for a consignment shop. I'm trying to print a list of crafters that had sales during a time period that I enter. I'm able to get the...
May 12th, 2010 09:35 PM
by John Viescas[_2_] Go to last post
2 139
Show only this year by ZBB
I'm stuck. I can't change the following statement correctly to show only the current year in addition to the current month. It pulls the prior...
May 12th, 2010 09:21 PM
by John W. Vinson Go to last post
4 233
The not "Max" records by Iram
Hello, I have a query that finds all records with a particular "Case#". I changed the query to do totals and grouped by Case#'s. I have another field called...
May 12th, 2010 08:53 PM
by John Spencer Go to last post
1 156
Append only new records/entire record makes unique identifier by TommyP
Hello, * I have been searching the existing posts for an answer to my issue.* Many have similar suggestions, but none of them quite fit my problem, so...
May 12th, 2010 08:44 PM
by KARL DEWEY Go to last post
4 195
RelationShips Queries and joins by Merge
Not sure where to start and the posts I have read I do not fully understand I created 2 tables (remitt and Billing) and for each table I created a...
(Multi-page thread 1 2)
May 12th, 2010 06:46 PM
by John W. Vinson Go to last post
10 287
Calculated field by LoriP
I need to calculate many fields based on one start date and I need the calculations to count by month. For example first visit is 4/25/2010 The first...
May 12th, 2010 06:04 PM
by LoriP Go to last post
5 211
Query Join - Outer Join? by MrRJ
Hello, I need your assistance as I am a beginner with MS Access 2007. Please review the SQL and hope it makes sense. I am trying to capture all records...
May 12th, 2010 03:52 PM
by vanderghast Go to last post
5 174
Query Join - Outer Join? by MrRJ
John, I hope you don't mind me asking this. When you say "building the query a step at a time", what do you really mean? When I copied your SQL to mine, I...
May 12th, 2010 03:16 PM
by John Spencer Go to last post
1 165
Access Subtotal in Query by scott
I have a simple query that uses 3 fields. Location, Person and Value. When I group by location and person and sum value, I get all the results I need but I...
May 12th, 2010 11:36 AM
by Bob Barrows Go to last post
3 2,359
Select stmt using Like by dpm1028
I have 2 tables in an db. Contacts is one with field LastName. The other is Issues. The issues db has a free text field that stores lastname/lastname......
May 12th, 2010 03:30 AM
by Ken Snell Go to last post
4 268
Daily Make Table Query by JD
I have a Make Table Query that I will need to run every morning. Is there anyway to have the query add today's date to the name of the table (without going...
May 11th, 2010 11:14 PM
by PieterLinden via AccessMonster.com Go to last post
2 224
Combining multiple records into one memo field by vander via AccessMonster.com
Hello, What I want to do seems simple enough, but I can't seem to find a simple answer. go figure. I have a table that has records of different leinholders....
May 11th, 2010 08:24 PM
by John W. Vinson Go to last post
5 167
Post New Thread


Display Options
Showing threads 221 to 240 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 06:34 AM.


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