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
Retrieving variable number of rows by Amy Blankenship
Hi, all; I need to be able to use one query to retrieve either the most recent result or all results, based on a parameter to the query. I don't seem to be...
July 14th, 2008 07:05 PM
by Amy Blankenship Go to last post
2 156
Newbie Question by bmacrow
Hello all, I am fairly new to this database creation thing, having been thrown in the deep end by work. My question is I am currently trying to get the...
July 14th, 2008 05:27 PM
by strive4peace Go to last post
8 190
What to choose for value in crosstab by Susan L
I'm trying to set up a cross tab to report "valid", "invalid" and "total" transactions (rows) by month (columns). I have a form on which a user can select a...
July 14th, 2008 04:43 PM
by Susan L Go to last post
2 143
finding duplictes by Dave Cullen[_2_]
Is there a way to find duplicate values in one column of a data table? If I make the column the primary key Access gives an error but won't show me where the...
July 14th, 2008 04:14 PM
by Allen Browne Go to last post
1 163
Q-Udayan by Udayan
Dear Sir, I asked the same question before but i lost i cant find the question again. Pls help me I am new to access. I have a data base having the flwg...
July 14th, 2008 03:53 PM
by raskew via AccessMonster.com Go to last post
1 197
Formula and Table Joining in a Query by MichaelR
Hi, I have two tables - one has all of my company sales data with many columns and the other has a row for each state, rep, product combination. The second...
July 14th, 2008 03:46 PM
by MichaelR Go to last post
4 136
Adding new records with 3 relationships by [email protected]
I am importing data into the database, because the HR does not want to imput data they already have in an Excel speadsheet. Since the DB using ID's that point...
July 14th, 2008 02:28 PM
by Klatuu Go to last post
6 144
Multiple Tables in single datagrid A97 by Kahuna
Is it possible to have multiple tables in a datagrit and have the columns up-datable? If not how woyuld one work around that challenge - other than having...
July 14th, 2008 12:44 PM
by Kahuna Go to last post
2 132
ANN: GNUstep Software Index is up and running by Jami Moilanen
Aika huvittavaa, että tiedotusvälineet ovatr kiinnostuneet vain Kallin taustamaksajista, miksi? Miksi ihmeessä ei oteta esille esim. Anne Holmlundin ja vaikka...
July 14th, 2008 10:44 AM
by Jami Moilanen Go to last post
0 145
Text Based Queries by William Foster
Good evening all, I have a query I need to create that can read individual text characters and return their codes so that I am able to assess whether they...
July 14th, 2008 09:18 AM
by William Foster Go to last post
2 123
Running queries with low priority in ado.net on access database by John
Hi We have an access database with several users. I run a number of queries in sequence via ado.net on the same database form time to time. The problem...
July 14th, 2008 04:50 AM
by John Go to last post
5 138
running sum for hour and minute by inungh
I have a query for working hour and minute and would like have a running sum like following: Employee (Working hour) (Working Minute) (Working hour...
July 14th, 2008 04:38 AM
by strive4peace Go to last post
1 151
Matching account numbers by CAM[_2_]
Hello, I have a table that is a chart of accounts called "ChartOfAccounts" Another table called "MonthlyExpense" containing expenses for the month...
July 13th, 2008 07:29 PM
by bhicks11 via AccessMonster.com Go to last post
1 133
Unexpected results when sorting multi-table query using toolbar button by JulieS[_2_]
Good day, When creating a running multi-table select query (details below) and then using the toolbar buttons to sort data in the datasheet, records...
July 13th, 2008 04:15 PM
by JulieS[_2_] Go to last post
5 160
debugging query-forms by News Boy[_2_]
I'd like to create a database to keep track of which routes go with which carriers, and which substitute carriers are associated with them. A carrier can...
July 13th, 2008 02:36 PM
by News Boy[_2_] Go to last post
2 136
I need to build a query that asks for a record by Gina
I would like to build a query so that when you open it, it asks you for information before it can open the query. I think it has something to do with...
July 13th, 2008 09:42 AM
by John W. Vinson Go to last post
2 142
T-shirt Sizes by ampickel
Ok I know that was a weird title. But this is what I need. I am trying to tally t-shirts into sizes. So right now my table has names and 7 sizes all in...
July 13th, 2008 02:30 AM
by Duane Hookom Go to last post
2 168
quartile function on access 2003 by Joel
Hello: Anyone have used or know how to calculate the quartile in a data using access 2003?. I already have used this function in excel. if this function...
July 13th, 2008 12:52 AM
by Joel Go to last post
2 192
Multiple Parameters by ampickel
Hello, I set up a database to keep track of athletes for a soccer camp and I am trying to run a query in which I am prompted to choose male or female or...
July 13th, 2008 12:29 AM
by Duane Hookom Go to last post
3 129
HELP WITH AGGREGATE FUNCTION by Alisheba
I'm having a terrible time figuring this one out and I was hoping someone can help me out. I'm trying to capture the sum of all items that are between 31 to...
July 12th, 2008 11:44 PM
by John Spencer Go to last post
1 140
Post New Thread


Display Options
Showing threads 9941 to 9960 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 12:05 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.