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
Tables with Relationships and Changing Variables by [email protected]
Hi, I have a series of table containing data over the past 2 years I am analyzing with the table analyzer and I am dividing it up and I have one question. We...
October 16th, 2008 08:59 PM
by R Tanner Go to last post
8 155
Group by function not working on certain fields by Chris Moore[_2_]
Using Access 2002 on XP Pro. I have a table containing a lot of redundant or un-normalized data. I am able to query some fields using the Group By function...
October 16th, 2008 08:21 PM
by Jeff Boyce Go to last post
7 89
See all records by LED
Hi, Was wondering if someone could help me out. I have two tables. The first one is Customers (500 records) The second one is Gift Cards (125 records) The...
October 16th, 2008 08:19 PM
by LED Go to last post
4 93
Splitting a Table with 15 Columns into Separate Tables Vs. Queries by R Tanner
Hi, Is there any disadvantage/advantage to splitting a large table into smaller tables versus just querying one table based on what you want? I am having...
October 16th, 2008 07:51 PM
by R Tanner Go to last post
5 94
Running total between two dates by Noreen
I have a query in which I need to calculate running totals on a no. of fields, mainly Year To Date figures. The problem is my year includes the 31/12/07. My...
October 16th, 2008 07:08 PM
by Michel Walsh Go to last post
1 78
Query with conditional statement by gremillion1
I am an access novice. . . . I have a query with an expression to find the average of two grades per subject (5 subjects). That works fine. However, what I...
October 16th, 2008 06:30 PM
by John W. Vinson Go to last post
8 138
Date range queries by Pat Hughes[_2_]
I'm having problems with date range queries. Can I make these queries when the person who built the database used "Text" as the "data type" for the date...
October 16th, 2008 06:01 PM
by Stockwell43 Go to last post
2 105
Enabling a Combo Box Based on the Value of another Combo Box by R Tanner
Hi, How would I enable a combo box ONLY based on the value of my current combo box..? Thanks
October 16th, 2008 05:40 PM
by R Tanner Go to last post
2 83
Creating a Form with Parent and Child Tables by R Tanner
Hi, I want to create a form to enter a record in a tickets table. I have another table with issues that is a parent table with a lookup column in my tickets...
October 16th, 2008 04:27 PM
by R Tanner Go to last post
0 78
Iif Statement by D
Hi: I have a query, and I need to calculate the varaince (pecentage) between two fields: (-); my iif is: July%$: IIf(.="FY09F",(-)/IIf(=0,,)) I have...
October 16th, 2008 03:26 PM
by Dale Fye Go to last post
5 126
IIF Statement #Error by rml
I have a query with three fields. ID, Standard, Report I'm trying to use the following code in the field line: Report:...
October 16th, 2008 03:22 PM
by Jerry Whittle Go to last post
5 140
How do I calculate a value in a new record from the previous recor by RickSF
How do I calculate a value in a new record from the value based on the value of previous record? the table has 3 fields for...
October 16th, 2008 03:21 PM
by RickSF Go to last post
2 106
Set Query Criteria to upcoming Saturday by twalsh
Designing a Query in Design Mode Field is called 'SCH_WK' or Schedule Week, which we identify as the Saturday for each week. I need to run the query each...
October 16th, 2008 03:20 PM
by twalsh Go to last post
2 89
Field allowing entry Pls HELP!! by JB
Hi, I've now got myself in a total muddle. I've created a database that worked very well. The usual client and contacts etc. the main form had fields for the...
October 16th, 2008 11:12 AM
by JB Go to last post
0 82
query value by rml
How can I make a query do the following: If the value in column A = "123" then value of column B = "tree" If the value in column A = "456" then value of...
October 16th, 2008 08:44 AM
by Keith Wilby Go to last post
4 91
Update query trouble by bhammer
I want to copy the CodeID value from one record to another, in the same table, to a certain record where a part of the Doc_Number (for the record with the...
October 16th, 2008 05:09 AM
by John W. Vinson Go to last post
1 84
Output Query to Text File by golfdog via AccessMonster.com
Looking to extract records from a query line by line ouputted to a single text file in a prescribed format. The formatted lines can be one of 6 different...
October 16th, 2008 03:10 AM
by golfdog via AccessMonster.com Go to last post
0 135
Query to copy selective records (and modify a column) by Bob Howard
Is it possible to create a query (or maybe just an SQL statement) to copy a selective set of records? The conditions are as follows: The added records are...
October 16th, 2008 03:01 AM
by Bob Howard Go to last post
3 92
Automated Delete Query by Syed Rizvi[_2_]
I have a database which needs to be clean up on a periodic basis using a Delete query. All query is going to do is to delete some records from number of...
October 16th, 2008 02:43 AM
by Allen Browne Go to last post
1 117
Storing two numbers, separated by commas, in one field formatted as anumber? by R Tanner
Is that possible? I want to store two numbers in one field and format it as a number. Or maybe I should just format it as text? Is there any downside? ...
(Multi-page thread 1 2)
October 16th, 2008 02:12 AM
by Allen Browne Go to last post
10 117
Post New Thread


Display Options
Showing threads 8201 to 8220 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 07:00 AM.


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