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
Unmatched query by joebeagle
Our organization uses an online database which is owned and operated by the State (HSN). I am developing a database for use within our company to keep track...
February 26th, 2007 10:34 PM
by joebeagle Go to last post
0 175
One-to-many query by Marios
I have two tables, TableA and tables, which have a 1-to-many relationship on TableA.ID and TableB.TableA_ID. What I want is to get a query which has all the...
February 26th, 2007 10:31 PM
by Marios Go to last post
4 184
Running Total Help by OShea
A mate of mine posted a question recently but had a bit of difficulty so let's give this a shot. I am building this as a subquery to hopefully make it easier...
February 26th, 2007 10:09 PM
by OShea Go to last post
2 127
determine which time interval the date falls into by Aivars
Hello, I have a simple table Rates, which shows what freight rates were applicable in different time...
February 26th, 2007 09:32 PM
by John W. Vinson Go to last post
6 297
Format Time in the query result by elena
Hi, All I got help with this query, all credits to Duane Hookom, it works great. In my table MarkTime field short time, but the query output return time in...
February 26th, 2007 08:51 PM
by KARL DEWEY Go to last post
1 173
Date() Criteria by robbyp
Hello, I have a basic query that is automated to export data into an Excel spreadsheet. This query runs using the Date() function in the criteria field to...
February 26th, 2007 08:20 PM
by Mike Go to last post
3 141
Find data determined by date by doreendev
I need to be able to populate a report based on volume data for each day of the year. For example: If today is March 1st, and historically March 1st is a...
February 26th, 2007 07:22 PM
by Carl Rapson Go to last post
1 137
Complicated Query by cableguy47905 via AccessMonster.com
This has been very frustrating because I know I should be able to get this. I am just going around in circles with it though. I have three different...
February 26th, 2007 06:14 PM
by KARL DEWEY Go to last post
3 134
Counting query by Marc
Say I have 6 number fields. I need to run a monthly report counting the how many times the same number came up. so if I have the same number in multiple...
February 26th, 2007 05:48 PM
by John Spencer Go to last post
1 160
Query based on calendar year. by Stefan van der Hooft
Hi! I’ve a question about selecting records from a table into another table. I’ve 2 tables, T_OE_Ideas and T_OE_Ideas_Queried. What I want is a query...
February 26th, 2007 04:33 PM
by John Spencer Go to last post
3 160
Running total from query by Confused_Dave
Hi, I'm building a database which will be used to monitor expenditure over several site. I'm having trouble finding a way to create a running total for each...
February 26th, 2007 03:52 PM
by Duane Hookom Go to last post
3 248
Reconciling Two Tables With Similar Information by FIECA
I posted this question originally on the tables board, but probably could use some help from the queries gurus as well. I created a database to track...
February 26th, 2007 03:52 PM
by Gary Walter Go to last post
1 154
Crosstab query Help by Elena
Hi, All I need help with query for the report; table has following fields Plate Location MarkDate MarkTime ...
February 26th, 2007 03:28 PM
by elena Go to last post
4 247
Conditional sum by scubadiver
Hi, I have a number of fields that can either have 1 or 2. How can I sum just the 1's and ignore the 2's. The field names are from "p1q1A" to...
February 26th, 2007 02:13 PM
by scubadiver Go to last post
2 187
QBF Query by Form- more than 2 tables? by Weezie1383
Hi, I currently have a QBF which runs using a query across 2 tables. I would ideally like to create a really awesome search page where someone can refine...
February 26th, 2007 01:19 PM
by Michel Walsh Go to last post
3 157
Inventory table slow by swas
Hi, I have an inventory table with each record having ProductID, OpenStock, Adjustment, Reason, ClosingStock. To find the current stock level for a product...
February 26th, 2007 01:02 PM
by Michel Walsh Go to last post
3 146
Numbers in a query by sarah
This question may be in the wrong forum - I'm just not sure. I have been ranking a field in my query and notice that some actual ties are not recognized as...
February 26th, 2007 11:50 AM
by Jamie Collins Go to last post
9 296
Query using two different date values by skr
I have a query for investments. My ultimate goal is to have a report that allows me to show the investments that are open during a month (i.e., If an...
February 26th, 2007 03:51 AM
by skr Go to last post
5 173
Select Unique Rows by alee via AccessMonster.com
Hello, I have a table similar to this: CustID Location OrderID 1 Vancouver 12 2 Vancouver 13 3 Boston ...
February 26th, 2007 02:11 AM
by alee via AccessMonster.com Go to last post
7 232
create a counter by Fasiano
hello there. i am working on my final year project and i stuck in the. if anybody could help me please do it. i have created a query named "general" which...
February 26th, 2007 01:51 AM
by Ken Sheridan Go to last post
1 158
Post New Thread


Display Options
Showing threads 19861 to 19880 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 02:41 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.