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
unable to run the query by Niroshana
I have upsized my Access 2007 database to SQL server 2005 database (Front end Access Database and Back end SQL server Database). Following MS Access query...
December 7th, 2009 06:48 PM
by Daryl S[_2_] Go to last post
2 246
Trouble shooting a query by Brigid
I have a database which collects sales for a company that sells burrito's. We deliver a certain number and a certain number is wasted. The Difference...
December 7th, 2009 06:45 PM
by Daryl S[_2_] Go to last post
1 188
Displaying Yes or No rather than 0 or 1 by Jerry Anderson[_2_]
I have a query that includes a Yes/No field. When it displays the results in a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this...
December 7th, 2009 05:42 PM
by KARL DEWEY Go to last post
1 195
wish there was a CountDistinct() function by h2fcell
I have to create a query that counts the number of DISTINCT Agencies that contribute to the sum of GrossSales grouped by Division. The follow query returns...
December 7th, 2009 03:46 PM
by John Spencer Go to last post
6 199
MS Access Query criteria Problem by Niroshana
I have upsized my Access 2007 database to SQL server 2005 database (Front end Access Database and Back end SQL server Database). Following MS Access query...
December 7th, 2009 03:41 PM
by vanderghast Go to last post
2 164
Add % to Existing Number by Hari[_2_]
Hi All, How can show my filed with rounded number and with % in other field. ex (0 = 0.00% 0.1 = 0.01% 2.5555 = 2.56% 5.666777 =...
December 7th, 2009 08:58 AM
by Allen Browne Go to last post
1 164
How To Specify No Criteria by Bobmeister
I am using a form to enable a user to specify criteria for a query. On this form there are several fields that the user can fill in. I am using these fields...
December 7th, 2009 05:04 AM
by Duane Hookom Go to last post
1 151
How do I query multiple data values in same field? by dcMcK
I need to create a query that returns first record of every group. So far, I can write sql statement to pull all occurance of defined groups (i.e. Peach,...
December 7th, 2009 01:16 AM
by KenSheridan via AccessMonster.com Go to last post
2 278
Query with common fields to all records by Prohock
I have a query that is collecting information from three tables. One table has infromation about each student and another table is an incident table and...
December 6th, 2009 11:31 PM
by Bob Barrows Go to last post
6 147
excel calculations in Access by sdg8481
Hi, I have a complex query written in Excel which i want to replicate in Access, however when i do it flags a error message saying undefined functions. So...
December 6th, 2009 10:51 AM
by sdg8481 Go to last post
7 204
Add existing table by cowichandave
I have an existing query and would like to expand it to include data from another table not included in this query. I can add it to the existing...
December 6th, 2009 08:05 AM
by Rob Parker[_3_] Go to last post
3 114
Why do these two queries give me different answers? by Tony Williams[_2_]
I have written two queries which total the same fields but I get two different answers. Here is Query1: SELECT tblmaintabs.txtMonthlabel, Sum(+++++) AS...
December 5th, 2009 11:08 PM
by Crystal (strive4peace)[_2_] Go to last post
4 185
How to append running number by Boon
Hello, I have a table A. the first field in table A is called ID. the data type is integer. I have created a query. In this query I would like to be able to...
December 5th, 2009 08:13 PM
by KenSheridan via AccessMonster.com Go to last post
2 167
query help by igg via AccessMonster.com
access 2003: I need to get to tableC from tableA and TableB. I tried hard to get to TableC but had no luck. tableA: ID N1 N2 N3 1 12 A1 B1 2 12 D4...
December 5th, 2009 08:13 PM
by John Spencer Go to last post
8 186
IIf Statement Error by Mary O[_2_]
I'm trying to formulate an if/then statement in a query and it returns with error as the value. I've a calculated expression as Expr2: Expr2:...
December 5th, 2009 08:01 PM
by John Spencer Go to last post
3 171
Modifying subform's underlying SQL statement by DoDev
I am trying to make modifications to the SQL statement underlying a subform. I make the changes using Access Query Builder view. However, after I make the...
December 5th, 2009 04:43 PM
by DoDev Go to last post
2 216
payroll query sample by Rick Stahl
Does anyone know of a good MS Access payroll system sample I could look at ? Preferably one that uses promotion dates with new job rates, calculates employee...
December 5th, 2009 02:56 PM
by Levere Catlyn Go to last post
1 125
Not equal to zero by Jessy MM Jules
Hi I have access 2007 and have set up a simple table called orders. Within the table I have set up Order ID, Order Date, Cutomers Name, Total Sales...
December 5th, 2009 07:15 AM
by John W. Vinson Go to last post
3 120
Creating queries asking for counts by John
I have a database for our hospital diabetes center. We created a great set of forms etc... to stream line our paperwork, now we need to create some reports....
(Multi-page thread 1 2)
December 4th, 2009 10:03 PM
by KenSheridan via AccessMonster.com Go to last post
11 291
crosstab query? by pat67
I use Access to run my pool league. I am trying to get if not a crosstab query, some query whic will give me one team's wins vs. another team. Right now I...
December 4th, 2009 09:14 PM
by pat67 Go to last post
3 150
Post New Thread


Display Options
Showing threads 2021 to 2040 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 07:13 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.