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
Count items in percent ranges by Molasses26
I have the table below and the Reads field is a Yes/No field and I’m only looking at the ones marked Yes so my data will look like...
February 24th, 2010 10:01 PM
by Molasses26 Go to last post
5 228
Format Currency field into zero filled text field by Marcie
I have a field that can be blank or contain a currency amount. No matter what the value is I want it to be a zero filled field. So for $9.99 I want 0000999...
February 24th, 2010 09:22 PM
by Duane Hookom Go to last post
1 223
update query to remove parenthesis by Kathy R.[_3_]
Hi Folks, I have a field that contains parenthesis, which I'd like to remove. Currently the data in the field looks like: (Miller) There's only 120 names...
February 24th, 2010 09:00 PM
by Kathy R.[_3_] Go to last post
5 275
Need help with query summing hours by Russ via AccessMonster.com
Tring to get total worked hours and total maintenance hours summary. I have a table with the clock hours WorkID WorkDate WorkEmployeeID WorkHours And have a...
February 24th, 2010 08:15 PM
by Russ via AccessMonster.com Go to last post
6 342
New to If statements by swillems
I have a query with service numbers and volumes. What I need is if the service number = 107, 109, or 105, sum volumes., otherwise show 0. -- S-
February 24th, 2010 07:49 PM
by John Spencer Go to last post
2 218
Only where a specific feild is unique. by Tom
I am looking for where "MR#", "Name", "Sex", match yet ONLY "Ans" not matching. The data in other fields are to be listed regardless if they match or...
(Multi-page thread 1 2)
February 24th, 2010 07:38 PM
by John Spencer Go to last post
11 521
Two different queries return same results by ryguy7272
I’m calculating average returns for stocks over two time periods; 30-days and 90-days. These two queries always return the same results for different time...
February 24th, 2010 06:54 PM
by J_Goddard via AccessMonster.com Go to last post
5 291
Difference between fields in query by NPell
Hello, i have a query in which i am trying to show a total number of items, then a total number of items with a criteria from a different table. Then...
February 24th, 2010 05:46 PM
by Marshall Barton Go to last post
1 266
Update Query and Too Many Rows by mwilsonh
I have 700 records I want to update. When I view the the data sheet view of the query, it looks correct, but when I actually run the query, I get a message...
February 24th, 2010 04:47 PM
by mwilsonh Go to last post
4 189
dcount by bmalak via AccessMonster.com
Having trouble getting dcount to work... I have a table "providers" with the fields: provider (as date) volume In a query, want to see the provider month
February 24th, 2010 04:21 PM
by bmalak via AccessMonster.com Go to last post
9 260
query to locate which record was not added by buddyr via AccessMonster.com
Hello, will try to explain. i have 4 employees. jim, jack, joe, and john. every week a report is created that needs to have one record from each of them. But...
February 24th, 2010 11:55 AM
by buddyr via AccessMonster.com Go to last post
2 330
how can I concatenate fields that contain numbers? by Lorina
I need to take a series of numbers that are in different fields and combine them into one number. I am linking to a spreadsheet that contains our UPC codes....
(Multi-page thread 1 2 3)
February 23rd, 2010 11:30 PM
by David W. Fenton Go to last post
22 539
Subquery group by by ram
HI I wouldlike help with the following question. I recieve the can't group by in the where clause error in the following subquery. Can someone tell me where...
February 23rd, 2010 11:29 PM
by ram Go to last post
4 244
update query based on two fields by Versace77
Hello: I'm looking for help with an update query, i am looking to have a field changed based on the value in two other fields on the same row, Column G and...
February 23rd, 2010 10:27 PM
by Versace77 Go to last post
4 227
unstable query by Bibi
I have a reservation database that I designed and have been using for 7 or so years now. I had help designing the query I show below from a discussion...
February 23rd, 2010 08:39 PM
by Jerry Whittle Go to last post
2 213
Help with a subquery by Justin
This is a subquery that Duane helped me with to calculate hours for the previous 7 days: HoursLast7: (SELECT SUM(On_Duty_Hours) FROM t WHERE t.Hours_ID =...
February 23rd, 2010 07:41 PM
by KARL DEWEY Go to last post
5 223
Anyway to join between two different data types? by foghat
Hi all, I have a Access database that is linking to Oracle tables. I need to join on two different data types. Number and Varchar2. With a oracle query, it...
February 23rd, 2010 07:27 PM
by Jerry Whittle Go to last post
4 257
Linked Table - Query Table List Missing Fields? by LightBulb
Hi, I have a Access 2003 mdb that I have used for years that has worked OK. Recently one of my queries malfunctioned to an external Progress db's linked...
February 23rd, 2010 05:33 PM
by Jerry Whittle Go to last post
2 221
Expression typed incorrect or too complicated by wallymeister
I have a database that I am updating w/ new Models. Got all the Models added and then tried to run the report on these Models. Report uses Query2A which...
February 23rd, 2010 03:20 PM
by wallymeister Go to last post
6 259
Pivot Table rounding by Ben
I setup a pivot table in Access. The property for the values is two decimal places. When I view as a Pivot Table, Access is rounding the stored values. ...
February 23rd, 2010 02:38 PM
by Ben Go to last post
3 248
Post New Thread


Display Options
Showing threads 1101 to 1120 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 04:18 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.