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 Reverse Sort Order / Thread Starter Last Post Replies Views
Access Chart Problems by jallen_45
I created a report from a single query, and then I added two charts to the report (from the same query as the report). I would have to enter a unique ID...
November 1st, 2006 01:06 AM
by S.Clark Go to last post
1 77
Access Checkbox and Sum (right post) by Miltos
Hello. I need some help for this access db. doseis check 50 y/n 50 y/n 50 y/n i tryed to sum doseis only if check=0 like...
July 17th, 2009 02:13 AM
by Miltos Go to last post
2 116
Access closes when query run by tcek
i am running a query that simply links several odbc tables and queries. when i run the query, access shuts down and the program exits entirely. all i see...
August 22nd, 2007 06:02 PM
by tcek Go to last post
3 75
Access Closes when trying to save query by Hieu Han
I am trying to save a query in Access 2002, but instead of saving the query, Access 2002 closes instead. Has anyone gotten this error? Do you know how to fix...
August 6th, 2004 02:20 AM
by Ken Snell Go to last post
1 332
access compact database changes results by Martin Beney
I have a database that I have added records to. If I run a query that uses a subquery (where xxx in (select top 32.....;);) that uses a top clause I get...
March 23rd, 2007 06:42 PM
by Martin Beney[_2_] Go to last post
6 120
Access confused by its own SQL brackets by Dan Williams
I'm pretty new at SQL. I tried this "SELECT DISTINCT FROM (SELECT UNION SELECT)" structu SELECT DISTINCT Firm FROM (SELECT Firm FROM UNION ALL SELECT...
April 8th, 2009 04:11 PM
by John Spencer MVP Go to last post
2 104
Access Conversion Toolkit by [email protected]
Is it safe to download and run Conversion Toolkit to convert files to Access2003 that were saved from Access97 as Version2000 files?
November 14th, 2004 05:15 AM
by Allen Browne Go to last post
1 110
Access Crash by George
I can regularly crash Access in 3 simple steps: (1) Run a pass through query against a DB2 database. DB2 requires a login with userid and pasword. (2) Wait 30...
November 22nd, 2005 05:18 PM
by George Go to last post
0 75
Access Crash on Query Save. What do I do? by LP in TX
Access 2000- I have a query with in Access that has multiple tables linked (4) with a compound if statement in a criteria feild. Acess will run the query. ...
August 18th, 2005 09:05 PM
by John Vinson Go to last post
1 98
Access crashes on a subquery by Carl Rapson
I've got a table with the following structure (I realize it's not properly normalized, but I plan to do that after I get this problem...
December 13th, 2006 05:39 PM
by Carl Rapson Go to last post
7 81
Access crashes on query parsing NMEA (GPS) data by J.T. van der Wal
I have had a problem parsing a time-fields contained in NMEA-data (record-type: $GPRMC) in an Access-query. My original data source neatly had output every...
June 18th, 2008 01:33 PM
by J.T. van der Wal Go to last post
0 120
Access crashes when query is saved or when opening design view by jkochchs
I have an update query ("main query") that is based on a number of other update queries. The queries itself run fine. When trying to open the main query in...
April 4th, 2005 08:31 PM
by jkochchs Go to last post
2 200
access criteria by Tom
Access 2000: I have the following query Last | First | columnA | columnB | columnC In the criteria field I need to build an expression: ColumnA ColumnB ...
August 17th, 2004 06:36 PM
by Tom Go to last post
3 93
Access criteria expressions by Rynorem
I don't have a ton of Access use experience but: Job Titles is a column in the database. In Queries, the user can type in a word and it will find the job...
September 16th, 2005 11:10 PM
by Amy Blankenship Go to last post
4 128
Access Cross-tab query should allow fields variable in sub-queries by JL
Currently in access with a transform query, all subqueries cannot have field name variables. Please Fix. ---------------- This post is a suggestion for...
January 27th, 2006 03:08 PM
by [MVP] S.Clark Go to last post
1 177
Access CrossTab queries by DIR
How do I sum column headings in crosstab queries?
October 1st, 2004 05:09 AM
by Duane Hookom Go to last post
1 240
access crosstab queries month range by [email protected]
I am working on putting together crosstab pivot queries by month. It always goes by calendar month order: Jan, Feb, Mar, etc. How do I set up the columns so...
June 7th, 2008 02:52 AM
by Duane Hookom Go to last post
2 116
Access crosstab query by Sherry
How can you get an Access CrosstabQuery to advise zero values in the total column?
September 3rd, 2004 10:08 PM
by Duane Hookom Go to last post
1 104
Access Crosstab Query Should Link To Forms by Anonymous
MS-Access Crosstab query doesn't take the form field in the criteria. So one need to create a crosstab query and then build another select query on top of that...
March 10th, 2006 05:31 AM
by Duane Hookom Go to last post
4 126
Access DAO Query by Bill Andersen
In Access 2000 DAO, what is the syntax to refer to a field in an open query?
August 4th, 2005 12:02 AM
by Bill Andersen Go to last post
5 131
Post New Thread


Display Options
Showing threads 1001 to 1020 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:24 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.