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
IIf AND by Gringarlow
I want to determine if a field is between two values. If RecTime is between 1000 and 1200, return Y, otherwire return blank. Thank You
July 2nd, 2008 06:03 PM
by John Spencer Go to last post
3 177
Help with a query... by Nuno Gomes
Hello all, I have table Customer with the field CP I have the table Cpostal with the field CP_NUM The relation between this two tables is Customer.CP 1-N...
July 2nd, 2008 04:48 PM
by John Spencer Go to last post
8 229
Converting text to a number in query by Stephanie
I'm having trouble with a conversion in order to get a formula to work. I have text that = numbers. Example: G++=1, G+=2, G=3,G-=4,G--=5, etc. I need a...
(Multi-page thread 1 2)
July 2nd, 2008 04:46 PM
by Stephanie Go to last post
16 413
memo field in the select query by inungh
I have a memo field in my select query and only return 255 characters. Do I need specify any return type using select query for memo field? The query is for...
July 2nd, 2008 03:56 PM
by Marshall Barton Go to last post
2 173
Want a counter for Access Query results by Stegra
I want to create a counter for a query by selected field results Main sort - req number Second sort - Date or Name or Time ...etc Output1 Have counter...
July 2nd, 2008 03:48 PM
by Stegra Go to last post
8 196
Calculate Age nearest by J
Any ideas on a formula to calculate someone's age on their closest birthday (last or next)? For example: Birthday = 1/7/1943 Effective date = 8/1/08 Age...
July 2nd, 2008 03:29 PM
by Bob Barrows [MVP] Go to last post
7 139
Inventory Control Query? by Suzann
I need to develop a way to keep track of gift cards received and sold by our company stores. We have 4 different card types and over 600 stores. I receive...
July 2nd, 2008 03:17 PM
by [email protected] Go to last post
3 239
Too many tables by Ian Belcher
Hi, I have a query that uses several subqueries. If I run this query several times I get the error of too many tables open. I don't have any tables open,...
July 2nd, 2008 02:56 PM
by Jerry Whittle Go to last post
1 141
Create multiple queries in Access with a single sql statement by Corby Nichols
Is there a way to create multiple queries with a single sql script, similiar to SQL Server 'Create Procedure' statement. I have a code generator that...
(Multi-page thread 1 2)
July 2nd, 2008 02:52 PM
by Klatuu Go to last post
15 264
Number format resulting from an aggregate query by Sajit
Pls. see the post with the same subject. -- Sajit Abu Dhabi ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the...
July 2nd, 2008 02:41 PM
by Sajit Go to last post
0 159
Count Distinct Values In Several Columns or Fields by HSL
I have a table that has 4 different columns for each customer id: Address1 Address2 Address3 Address4 I am trying to get a count of unique values across...
July 2nd, 2008 02:08 PM
by Ron2006 Go to last post
4 184
display top 5 records for each subcategory by lay
I need to know how to return just the top 5 DUs (Based on sum of cases lost) for each Code desc. Below is my current SQL that returns back all records for...
July 2nd, 2008 01:46 PM
by Michel Walsh Go to last post
7 186
Select records by employee by [email protected]
I have a table with about 31000 records. Table as the following fields: Invoice Number, Supervisor, Employee, Action The action only has 3 possible variables...
July 2nd, 2008 01:14 PM
by John Spencer Go to last post
3 191
Calculating Working Hours that cross over midnight by Jurrasicway
Hi, I am trying to make a query work that will calculate hours worked. However, when my working time spans midnight I get negitive figures. My expression to...
July 2nd, 2008 07:58 AM
by Jurrasicway Go to last post
4 247
Adding Calcs to a Crosstab? Or Form? by carriey
I have finally figured out my first crosstab query and it does about half of what I need it to do. I get a table that I have put into a form which displays...
July 2nd, 2008 12:28 AM
by carriey Go to last post
4 193
Roundup Function by aMack
I can get the roundup function to do what I need in Excel - it does not give the same results in Access. Excel: =ROUNDUP(2161/36,0) Result is 61 in Excel....
July 1st, 2008 10:17 PM
by aMack Go to last post
2 234
Trying to find values that are not equal by Cindy
Hi; I am a new user... I have the same field in two different tables. I tried a query to find the records where the values are not equal. I used the...
July 1st, 2008 08:34 PM
by Jerry Whittle Go to last post
1 154
Update Query to a SharePoint List by Lori J.
I use Access and SharePoint daily, but just switched from 2003 to 2007 versions. I have a list that was created in SharePoint that I have linked into...
July 1st, 2008 07:41 PM
by Lori J. Go to last post
0 151
Split two data elements that are in one field by Lisa W.
I have a table that was created via an excel spreadsheet import. One of the fields consist of two data elements, but I would like to split it so that the...
July 1st, 2008 06:39 PM
by Lisa W. Go to last post
4 184
Sum values of column by NeoFax
I need to write an expression that sums the values of a query based on the date. Here is the query setup: Helo#(Dbl) Sample: 14701, 14702,...
July 1st, 2008 06:18 PM
by KARL DEWEY Go to last post
1 199
Post New Thread


Display Options
Showing threads 10121 to 10140 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:19 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.