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 Reverse Sort Order Views
Text To Columns in Access by Ernie Sersen
Does Access have a Text-To-Columns function like Excel? I have a field in access that contains AAA-BBBB-CCC-DDDD or AAAA-BBB-CCCC-DDD. I need to be able to...
(Multi-page thread 1 2)
October 2nd, 2007 07:24 PM
by MacNut2004 Go to last post
18 354
Query sort not working after NULL column by mscertified
I have a query that has an order by e.g. ORDER BY A,B,C,D,E For this particular subset of data, columns A, B and C are all the same, column D is NULL in each...
(Multi-page thread 1 2)
December 11th, 2007 02:36 PM
by Michel Walsh Go to last post
18 211
Parameters problem in Query by Lisa
I have a query that creates a crosstab query. I want to be able to use the parameter between (date) and (Date), however it will not allow me to the query...
(Multi-page thread 1 2)
March 26th, 2008 08:51 PM
by Lisa Go to last post
18 208
Random Selection by FrankM
I have a Table (Q1) with several fields (Site, Rep, Cust, ID, Prod, Serv, Date, Act). I need to randomly make a couple of selections. There are three "Prod"...
(Multi-page thread 1 2)
April 4th, 2008 03:45 PM
by FrankM Go to last post
18 243
Query for Left(String,5) - Access 2007 by JohnH
I found this response in a post regarding a query I'm trying to do. It looks like it's what I need but I don't know how/were to implement it in the...
(Multi-page thread 1 2)
May 1st, 2008 10:36 PM
by JohnH Go to last post
18 222
Case or IIF? by NBullock
Might there be a better way? I am trying to pull text from a field in one table and then assign those records to that result. For example, if the printer...
(Multi-page thread 1 2)
July 3rd, 2008 06:45 PM
by NBullock Go to last post
18 322
Query Too Complex, Too many Characters? by Eka1618
Hello, What I am trying to accomplish is to give the user the ability to run a report based on different criteria from 4 different...
(Multi-page thread 1 2)
October 9th, 2008 10:17 PM
by Lord Kelvan Go to last post
18 181
Slow queries when joining local to SQL Server tables by Jon M
I manage a SQL Server data warehouse and my customers use Access to create ad-hoc queries of the data. A customer is creating a local table in Access to...
(Multi-page thread 1 2)
February 6th, 2009 11:27 PM
by Jon M Go to last post
18 209
SQL - Query count not working by QB
Hello, I have a first query which creates a base list from which I then base a second query (the one I'm having trouble with) which does a basic count which...
(Multi-page thread 1 2)
July 14th, 2009 06:11 PM
by vanderghast Go to last post
18 207
Jet SQL and Virtual tables/subqueries qiestions by Mark Burns
Is there some documentation somewhere I can reference for more information on 2 things: 1) The Jet Expression Evaluator (what functions & stuff are actually...
(Multi-page thread 1 2)
August 26th, 2007 04:49 PM
by David W. Fenton Go to last post
18 309
Matching Dates by ashg657
Ok guys fairly complicated one here... I have a single table with 20,000 transactions within it. Each transaction has a date attached to it. I have another...
(Multi-page thread 1 2)
August 24th, 2007 05:23 PM
by Michael Gramelspacher Go to last post
18 216
Query SQL not working.. by Zack Barresse
Hello everyone, working with a database where I'm trying to produce a query that will list all records that meet a certain condition. Here is my...
(Multi-page thread 1 2)
April 21st, 2006 03:37 PM
by Zack Barresse Go to last post
18 125
Vacation Query by Julie
What I need to figure out now is how to get a query to look at their anniversary date and add in what amount they get awarded and also to deduct what they...
(Multi-page thread 1 2)
August 16th, 2006 09:53 PM
by Secret Squirrel Go to last post
18 190
Design View by BBran
Hello, I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access...
(Multi-page thread 1 2)
January 4th, 2007 06:50 PM
by BBran Go to last post
18 232
Why can't I update this query by BruceM
This is the SQL for a query that cannot be updated: SELECT tblPO.*, tblVendor.*, tblPhone.Phone, tblPhone.MainPhone FROM (tblVendor INNER JOIN tblPO ON...
(Multi-page thread 1 2)
December 11th, 2006 01:35 PM
by BruceM Go to last post
18 181
Getting a total control to find totals for last 7 days via a query by efandango
I have an unbound control on a form that is doing a total on a query field called , I want to set the criteria from the control box and not the query. my...
(Multi-page thread 1 2)
February 17th, 2007 08:16 AM
by Marshall Barton Go to last post
18 380
Trim Data by Finger Tips
I know this may be answered somewhere but I am new at this and need very specific steps. Screen shots also help. I am running a query. In one of the fields...
(Multi-page thread 1 2)
April 29th, 2007 01:02 AM
by Finger Tips Go to last post
18 217
Query Not Working by CT[_2_]
Hello, I have set up a query for 1 table. The field I'm trying to run the query on is a text field. I enter a name (="smith, john") I get zero results. ...
(Multi-page thread 1 2)
June 18th, 2007 07:43 PM
by Scott Nash Go to last post
18 184
Return to form if query unmatched by Richard
I have this query. SELECT BOOKS.Number FROM BOOKS WHERE (((BOOKS.Number)=)) GROUP BY BOOKS.Number ORDER BY BOOKS.Number DESC; What I want to do now is if...
(Multi-page thread 1 2)
June 18th, 2007 09:02 AM
by Kozaw Go to last post
18 152
Need help making query with criteria based on combo box selections by Erick C
Hi everybody - I have a problem that I am hoping someone may be able to help me out with. I have a form in my database with 5 different combo boxes. I got...
(Multi-page thread 1 2)
September 29th, 2009 04:47 PM
by Erick C Go to last post
18 312
Post New Thread


Display Options
Showing threads 181 to 200 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 04:53 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.