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
problems getting value in crosstab fashion in Sql server 2000 by Rex
Hi I have a table called "Member" as given below.. familyID memberID firstName -------- -------- -------------------- 0 7 Stuart 0 5 ...
February 9th, 2007 04:36 AM
by Duane Hookom Go to last post
1 106
Show result of TblA not in TblB by Ian
I have a main tblA with all clients. If they have any current contracts they are in tableB. How do I show the clients of A that are not in B? Thanks Ian.
February 9th, 2007 03:36 AM
by Ian Go to last post
4 84
Date stored as Number by JanetF
Hi there, I have a strange situation where I've adopted a database which I need to take data out of and import into a new database. Unfortunately one of the...
February 9th, 2007 12:46 AM
by John W. Vinson Go to last post
6 84
display query execution time on textbox or progress bar by luis assunção
hello i would like to know if it is possible to know the execution time that takes a query to run, to display it on a textbox or a progressbar. i am doing an...
February 9th, 2007 12:28 AM
by luis assunção Go to last post
0 117
Table list in CrossTab Pivot statement by Biggles
There might be an eaiser way to do this, but I am in a hurry and have existing queries I need to fix. I have a crosstab query where the column headings are...
February 9th, 2007 12:08 AM
by Duane Hookom Go to last post
1 73
zero a field in duplicate rows by Manny
Hi, I have a table with duplicate rows, which is fine, that's what i need to display. i have the same field 'balance' in all those rows. My question is; how...
February 8th, 2007 11:58 PM
by Smartin Go to last post
5 79
aggiornamento form ricalcolata by madmax71
qualcuno saprebbe gentilmente suggerirmi come fare per : aggiornare da una sottomaschera il contenuto di un campo in un elenco di record determinato...
February 8th, 2007 11:56 PM
by madmax71 Go to last post
1 112
Hide buttons on non-active row in a continuous form by Jim Bennett
I have searched high and low for an easy answer to this without success. I am trying to hide a command button behind a conditionally formatted textbox on a...
February 8th, 2007 10:37 PM
by Jim Bennett Go to last post
0 89
round function in query by mbr96 via AccessMonster.com
I have a table with a MonthlyPmtAmt field (Number data type, Single), that I notice has varying numbers of decimal places when I export the table to Excel. The...
February 8th, 2007 10:27 PM
by mbr96 via AccessMonster.com Go to last post
0 101
filtering integers in a field by IVAN
I have a problem in creating a relationship for 2 tables. Table1 - represents a call list with destination phone numbers( international). Table2 - is a...
February 8th, 2007 10:25 PM
by John Nurick Go to last post
6 99
Joining Multiple Tables by Harddrive747
I have three tables with the same amount of fields. They are Source, destination and volume. I'm trying to show trends from the source to the destination...
February 8th, 2007 09:15 PM
by Harddrive747 Go to last post
3 93
Delete all Records but... by binder
Hello -- I have a table that list a set of records that I need data for (tblScan) and several tables that contain many more records than I need. How can I...
February 8th, 2007 08:36 PM
by George Nicholson Go to last post
4 105
trouble with query results by Slez via AccessMonster.com
I have a query that returns duplicate records as follows: If I have 1 record in tblChangeItem, it returns the records for tblChangeItemDetail properly. If I...
February 8th, 2007 08:26 PM
by Jerry Whittle Go to last post
1 97
Use of Variables in queries by hkhella
I have multiple client names listed in a field. I need to build a report for seperate clients with similar search criteria (i.e. search for reports that...
February 8th, 2007 08:00 PM
by Klatuu Go to last post
4 99
Reposting - If my query finds no data it won't plot that week by stu
I'm running a query which calculates data for eight weeks and returns eight records. If the query finds no data for one of those weeks it returns only 7...
February 8th, 2007 07:35 PM
by Marshall Barton Go to last post
1 77
I want my query to return a single blank record when there is no d by stu
How do I configure the query to return answer unconditionally - in other words it will return a single blank record when there is not data to return (blank...
February 8th, 2007 07:16 PM
by Klatuu Go to last post
5 89
Converting partial date text to date by B Rager
Access 2003 ~ I have inherited a table with dates displayed as text. Problem is the dates are partial dates (i.e. 0705) 0705 is YYMM. I need to convert the...
February 8th, 2007 06:36 PM
by Dale Fye Go to last post
1 89
Same week last year, MTD by Steve Happ
Using Access 2003 I have searched for quite a while through the discussions but can't seem to find answers to what I need. If I've missed it, feel free to...
(Multi-page thread 1 2)
February 8th, 2007 06:01 PM
by Klatuu Go to last post
14 186
Table Details not in Build by Ken
I would like to use the value of a combo box on a form as criteria, and it isn't working. I tried to build the criteria and the details of the form don't...
February 8th, 2007 05:57 PM
by Jerry Whittle Go to last post
1 97
query doubles up records by Slez via AccessMonster.com
What could cause a query to return a duplicate set of records? I can view the records in the table, and for example there may be 6 records associated to the...
February 8th, 2007 05:39 PM
by Slez via AccessMonster.com Go to last post
6 70
Post New Thread


Display Options
Showing threads 20261 to 20280 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 03:52 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.