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
Aggregating Data by randlesc
I have a table called Observations which has a field called JOBTITLE. In this field we list various types of MDs, RNs, HAs, etc. Most of my reports require...
March 1st, 2010 10:15 PM
by Bob Barrows Go to last post
3 206
commission by sunshine
How do I calculate commission on a sum of prices per worker?
March 1st, 2010 10:08 PM
by KARL DEWEY Go to last post
2 235
Difference between numbers by S
I have a query that outputs "student name" and "entry#" Entry# are in ascending order. Some students may only have 1 entry# or multiple entry#'s...
March 1st, 2010 09:49 PM
by S Go to last post
5 236
Calculate percent return for different stocks by ryguy7272
I’m trying to calculate the percent return for different stocks. I need to get the (-)/. Here is my (non-working) query: SELECT SharePrices.StockSymbol,...
(Multi-page thread 1 2)
March 1st, 2010 06:59 PM
by Daryl S[_2_] Go to last post
11 431
Query wants parameter value by Bob H[_4_]
I have a tools database which been used for over 12 months on a network at work. Just lately I have noticed that on the main tools query, when I open it to...
March 1st, 2010 05:59 PM
by vanderghast Go to last post
4 192
Report-not required to print if field is null-concatenated field q by Anni
Please tell me how to configure the field in a report not to print if the value is null (simple concatenated field in query (ie &" "&years old). The age...
March 1st, 2010 05:54 PM
by Dorian Go to last post
1 172
Getting info from two tables with disimilar headings by Steve
I have two tables of similar (but not identical) headings and different data in each table similar to below. Prices change each day and are listed in the...
March 1st, 2010 05:47 PM
by Dorian Go to last post
1 180
Calculate Percent Return for Stocks by ryguy7272
I am working with this SQL: SELECT SharePrices.StockSymbol, SharePrices.StockPrice AS StartPrice, SharePrices_2.StockPrice AS EndPrice,...
March 1st, 2010 04:57 PM
by ryguy7272 Go to last post
5 307
Calculated query field will not filter by Ceebaby via AccessMonster.com
Hi Everyone I have a query of addresses where I would like to filter on even door numbers. The StreetNo field is a text field and so I have used the VAL...
March 1st, 2010 04:17 PM
by Ceebaby via AccessMonster.com Go to last post
8 312
Query performance Access 2007 by Cesar
After converting an Access 97 application and database table to Access 2007, queries became extremely slow. This is a split application; front end runs local...
March 1st, 2010 03:40 PM
by Cesar Go to last post
1 190
Query-matching data with multiple choices by Solv123
I have two very large tables of data. One is a table of vehicles that are on order and have an order number. The other is a table of vehicles that are...
March 1st, 2010 03:38 PM
by Solv123 Go to last post
5 323
How to make multiple values show up by Clddleopard
I have a table that has the fields SpeciesID and Frequency (both Long Integer). Example Data: SpeciesID Frequency 1 3 2 ...
March 1st, 2010 03:14 PM
by Clddleopard Go to last post
2 198
Dinamic Naming in Design Grid or SQL by John
I have a union query that gathers financial data from a current period and a prior period. The users uses a pick list to pick two dates. The union query...
March 1st, 2010 03:06 PM
by John Go to last post
2 182
Add percentages by CMarshall
I have a report that counts the number of technicians at different locations and then counts the number of techs that have attended training at our...
March 1st, 2010 03:01 PM
by John Spencer Go to last post
1 194
Checking if a record is also in another list by Mafukufuku
Can I check wether a ClientId is also in another list and get a true or false answer? preferably I would build a query with columns about clients and their...
March 1st, 2010 02:51 PM
by John Spencer Go to last post
7 224
NOT IN (SQL) or Find Unmatched (+ other stuff) by Farkyss
Big issue here trying to build a query that lists records whose serial number DOES NOT appear in another table. In SQL, would use the condition: WHERE...
(Multi-page thread 1 2 3)
March 1st, 2010 01:29 PM
by vanderghast Go to last post
21 460
Joining Multiple Tables by Logo
I've been trying to create a query to print a revenue and expense report. I finally got the dates to display correctly after about 100 hours of work! ...
March 1st, 2010 08:53 AM
by PieterLinden via AccessMonster.com Go to last post
1 180
How to break some SQL into VBA by ryguy7272
I am trying to figure out how to break some SQL into VBA. I feel like I’m almost there, but I seem to be missing something. Below is my VBA: strSQL =...
March 1st, 2010 04:39 AM
by ryguy7272 Go to last post
3 208
Get Subform Data by Jonas
I'm looking for a way to get the data from a chosen record in a continuous subform. I have a customer form and a continuous subform with all of the charges...
March 1st, 2010 03:18 AM
by Allen Browne Go to last post
1 226
Need help with creating condition to produce follow-up list in Acc by Smitee2006
I have an incident management database with a separate table for tracking status of file. Users managing the incidents can select a status type such as...
March 1st, 2010 12:49 AM
by KenSheridan via AccessMonster.com Go to last post
2 176
Post New Thread


Display Options
Showing threads 1041 to 1060 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 03:28 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.