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
Calculating in Queries by Fendi Girl
Hi How can I design a query that calculates hours for each project worked trough the week (time sheets, like job no. 205 Mon 2hrs + Tue 7.5 hrs Wed 0+ Thu...
July 22nd, 2008 12:16 PM
by John Spencer Go to last post
6 111
undefined name in pass-through query by Angie
I'm writing a pass-through query joining a table from within the existing database to an ODBC linked table via DB2. I keep getting the following error: ...
July 22nd, 2008 10:15 AM
by Brendan Reynolds Go to last post
1 173
Calendar Control by Jasper Recto
I have a query that prompts the user for the start date and end date criteria. I created a form with a button that launches that query. I would like to...
July 22nd, 2008 02:40 AM
by Arvin Meyer [MVP] Go to last post
3 120
Executing a make-table query using multiple primary keys by NOTdbRanger
Access 2003 Help files tell me this regarding a make-table query: "Note The data in the new table you create does not inherit the field properties or the...
July 22nd, 2008 01:39 AM
by david Go to last post
8 163
Average Calculation by Love Buzz
Hi all. Please see my SQL below. I am pulling data from a Table (December 4). The query I am building is working great except for the average (Exp4)...
July 22nd, 2008 12:49 AM
by Jeff Boyce Go to last post
1 84
Show true "repeated" entries by J Sedoff[_3_]
I am modifying an Access 2000 database in which my "qryMB59" query is merging a table to show one other piece of information and an older query...
July 21st, 2008 09:48 PM
by J Sedoff[_3_] Go to last post
6 183
Date Range in Crosstab query by Jomark
I have a crosstab query using a date range Between #1/4/08# AND #31/3/09# that works fine for this period. What I would like to know is if it is possible to...
July 21st, 2008 07:01 PM
by Jomark Go to last post
2 167
Cannot have aggregate function in expression by Love Buzz
Hello all. Below is a query I am trying to create that contains operator productivity statistics. In addition, I would like to calculate the average time...
July 21st, 2008 05:41 PM
by Love Buzz Go to last post
2 93
Datasheet view by Jasper Recto
Is it possible to make the label in the datasheet view wrap itself? I have a label that's very long and I would like it to wrap the words so that it's 2 lines...
July 21st, 2008 05:38 PM
by Jeff Boyce Go to last post
1 92
Parameter Query? by Hank
I have a query in access 2003 with the following: LastName Birthdate - (example:. 11/01/1990) Month: Format(,"mm") --Expression to extract the month....
(Multi-page thread 1 2)
July 21st, 2008 05:21 PM
by Hank Go to last post
10 213
Find Top 10 items from a query by Jasper Recto
I have a query that sorts items from table. I would like to only determine and view the top items on that list. Is that possible? Thanks, Jasper
July 21st, 2008 04:40 PM
by Jasper Recto Go to last post
4 123
Why doesn't this code from the Access Help menu work?? by Edward
I'm trying to improve my understanding of record locks and copied this code from the Access help menu; also set a reference to DAO 3.6 and when trying to run...
July 21st, 2008 04:34 PM
by Dale Fye Go to last post
1 113
Refrest PivotChart by Atif
I am opening a Select Query in PivotChart view using a ListBox value. The List Box contains values "NA-E", "NA-W" and "EU-Asia". The problem is for example...
July 21st, 2008 03:38 PM
by Atif Go to last post
0 112
select fiscal year on a query by artist
I have a query that I need to allow a user to select the fiscal year. The company fiscal year runs 4/1 through 3/31. I want to allow the user to select...
July 21st, 2008 03:22 PM
by Allen Browne Go to last post
1 112
Query Writing Question by pfm721
I have a db with 3 tables. tblTracker ID (AutoNumber) PK VetSSN (text) ConsultNumber (text) Location (text) tblVendor Name (text) PK Phone...
July 21st, 2008 02:12 PM
by pfm721 Go to last post
1 107
Subquery to return distinct count by Max
I am having table with Data Year-Trainer-Event 2007-X-A 2007-X-B 2008-X-C 2008-X-A i want count of Trainer by year wise such that Person X count for the year...
July 21st, 2008 12:30 PM
by John Spencer Go to last post
5 113
Sum Query by Ernst Guckel
Hello, I am trying to sum all hours worked per employee within a given week. I want the total of EmpHours and EmpOTHours between Date1 and Date2 Here is...
July 21st, 2008 12:24 PM
by John Spencer Go to last post
1 123
Index Name(s) by [email protected]
I am using Access 2003 Is there a way to use SQL to get the Index Names on a table? I can get the data if I go to Tools-Analyze-Documenter, select...
July 21st, 2008 06:10 AM
by Allen Browne Go to last post
1 143
need help with query by nishkrish
i have a table which shows customers oustanding, out of 500 customer if 3 pays me half the payment the part payment is yet to be received how can i show that...
July 21st, 2008 03:47 AM
by John W. Vinson/MVP Go to last post
3 110
Help with Query for new user by Meredith9053
Only been working on access for a few months. so bare with me. Basic Background: Working a Database to produce invoice for a small jewellery company. ...
July 21st, 2008 02:58 AM
by Meredith9053 Go to last post
4 144
Post New Thread


Display Options
Showing threads 9821 to 9840 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:11 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.