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
I'm SOOO tired of delete queries failing! by Bob
running access 2k; I have 2 queries - BOTH should work as far as I can see, and NEITHER does; each reporting "could not delete from specified...
(Multi-page thread 1 2 3)
June 23rd, 2007 03:46 PM
by Chris2 Go to last post
26 332
percentage calculation...trying again by JMS[_3_]
Can anyone help please? Report Gross Grand Total and Sales tax Total are off by a penny or 2 The amounts are being generated by the sum expression below...
(Multi-page thread 1 2 3)
May 22nd, 2007 02:08 PM
by Michel Walsh Go to last post
26 287
Another time calculation issue, thanks for any help! by Gina Whipp
Hello All, I was hoping to do this without to much difficulty but not having much luck. I got the round down to the nearest 15 minutes. NOW I would like to...
(Multi-page thread 1 2 3)
September 2nd, 2007 03:33 AM
by Arvin Meyer [MVP] Go to last post
26 289
Query doesn't always sort by [email protected]
Hello, I have an access query that I run on a regular basis but that doesn't always sort. It sorts most of the time, but once in a while it won't, which makes...
(Multi-page thread 1 2 3)
May 3rd, 2007 12:38 PM
by [email protected] Go to last post
26 337
Access maybe, Sql no by Steve Dassin[_2_]
Greetings Access Users, I'm here to sell something. An idea. Some of you may have heard of a system called Dataphor from Alphora. I have been working with it...
(Multi-page thread 1 2 3)
September 10th, 2007 05:44 AM
by Steve Dassin Go to last post
26 320
upsizing to sql 2005 by Dee
I am using the upsizing tool to slq 2005 from access 2003. I have three tables which use 100's of queries. Some if the primary keys to the three tables may...
(Multi-page thread 1 2 3)
October 23rd, 2007 02:27 PM
by Michel Walsh Go to last post
26 259
Convert text to Date by Jasper Recto
We have dates that are in this format: 20080513 This is the date for 5/13/2008 If I import data from a text file that has this format, how can I convert it...
(Multi-page thread 1 2 3)
June 10th, 2008 10:19 AM
by catharinus Go to last post
26 419
Access Query by Chris
I have a database where I have people listed with two other columns of data that goes with the name. The names are listed multiple times. I was wondering...
(Multi-page thread 1 2 3)
August 25th, 2009 06:51 PM
by Bob Barrows Go to last post
26 514
Help with running balance by Johnny[_5_]
I need help on running balance for my banking DB. I have a Table (Transactions) where I store all account transactions, with the fields: TransID...
(Multi-page thread 1 2 3)
October 8th, 2009 04:39 PM
by Marshall Barton Go to last post
25 379
#Name error in Query by BBC
Have read at least 100 posts re #name errors and still can't figure out what's wrong with mine. I have a master form (and table, both called "Client") that has...
(Multi-page thread 1 2 3)
February 13th, 2009 07:27 PM
by BBC via AccessMonster.com Go to last post
25 319
Do not Count Duplicates by bdehning
I have a query based on two joined tables and need to know how to insert SQL into existing sQL so my query counts "Assigned Consultant" Properly. if the...
(Multi-page thread 1 2 3)
July 28th, 2004 05:47 AM
by bdehning Go to last post
25 941
Help with SELECT by vovan
I have a table with Accounts, let's call it Account. It has the following fields: AccountID AccountName ParentAccountID Data in the table: AccountID ...
(Multi-page thread 1 2 3)
June 25th, 2007 05:04 AM
by No Name Go to last post
25 163
Anyone know of a good/quick (and free) way to compress HTML code? by ship
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000) Hi Anyone know of a good/quick (and free) way to compress HTML code? We are trying to use...
(Multi-page thread 1 2 3)
May 18th, 2007 10:25 PM
by Jerry Stuckle Go to last post
25 446
DLookup and DMax with dates by Joseph Rosing
Hi, I have two date/time fields: StartTime and LastActivity. In the History table, there are Location and LastActivity fields. I want to run a query which...
(Multi-page thread 1 2 3)
July 27th, 2006 08:48 PM
by joer Go to last post
25 340
Access Query Right Align by Donna
I am trying to export a query to a .txt file. I can't get the number field to right align. Any help would be appreciated.
(Multi-page thread 1 2 3)
July 13th, 2006 06:13 PM
by Gary Walter Go to last post
25 322
Accounting system query by FJquestioner
I have a Receipts Allocation table in which the payment received for invoices are recorded by INVOICEID number. When the final payment for an invoice...
(Multi-page thread 1 2 3)
October 8th, 2006 07:10 AM
by Steve Schapel Go to last post
25 402
Help with Query! by Bob
This is what the Query code is and What is between the stars ** is what I would like added to it......Thanks Bob SELECT tblHorseInfo.HorseID,...
(Multi-page thread 1 2 3)
May 30th, 2006 11:23 AM
by [email protected] Go to last post
25 304
Creating a unique customer code with a function by mattc66 via AccessMonster.com
I need to assign a customer code for 5000 records. The customer code would be as follows: The number 2 followed by the first 3 letters of the business name,...
(Multi-page thread 1 2 3)
March 29th, 2006 01:24 AM
by Tom Ellison Go to last post
25 432
ANY and ALL by Darren
I am writing a subquery using the all statement and it seems to be giving a problem. SELECT EID, Salary, Department FROM tblAccounts WHERE Salary ...
(Multi-page thread 1 2 3)
November 4th, 2005 03:52 PM
by Chris2 Go to last post
25 296
Help with Query to find Month by AccessKay
I need some help please. I want to build a query based on a form with two combo boxes for Month 1 and Month 2 and then have a report that has two columns...
(Multi-page thread 1 2 3)
April 22nd, 2010 10:38 PM
by AccessKay via AccessMonster.com Go to last post
25 537
Post New Thread


Display Options
Showing threads 41 to 60 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 11:20 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.