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
if statement results by chartmaker
How can I make an "if" statement return an empty cell? (Not just a ""). A chart based on those cells keeps giving me zero values
July 6th, 2008 06:33 PM
by Chris O'C via AccessMonster.com Go to last post
1 295
Duplicate entries in a query by Oldsfan
Hi. I don't know if I can explain what I'm trying to do. Maybe I'm over my head. I've got a car club database. One table is name/address information. Another...
July 6th, 2008 01:10 PM
by Ken Sheridan Go to last post
3 184
Date - Beginning of Month by Chris Gorham
Hi, simple one - I need to calculate the date of the begining of the month for the date Post Date which is in another field of the query. Tried this -...
July 6th, 2008 08:15 AM
by Rob Parker Go to last post
1 187
Query Join on Multiple Field Indexes by John D
I have one Table with a 2 field Primary Key. A second Table has a 2 field Index. Each of the 2 fields is defined the same in both Tables. I want to Join the...
July 6th, 2008 08:09 AM
by strive4peace Go to last post
3 311
Expression Builder by Elizabeth Reynolds
I am working in a query that I want to put the address, city, state and zip into one field using the expression builder. When I do this the state which is...
July 4th, 2008 10:31 PM
by Elizabeth Reynolds Go to last post
7 258
most close return by inungh
I would like have a query or method to get most close value like following: Code Value A+ 95 A 90 A- 85
(Multi-page thread 1 2)
July 4th, 2008 09:39 PM
by [email protected] Go to last post
15 463
How to look-up ID# by jmuirman
In my query I use the following to look up a case number which is really the Auto Number ID: Like & "*" However, when I look up record 28, it finds all of...
July 4th, 2008 08:42 PM
by John W. Vinson Go to last post
3 182
Formatting a Number in a Query Field by Brad[_6_]
All, I have a field value that is formatted currency. I need to format the field in a query to have leading zeros and retain the decimal values without the...
July 4th, 2008 07:20 PM
by Brad[_6_] Go to last post
2 194
Help to select record by checking multiple child items by Renaud_D
Hello, I have a table consisting of student names linked to another one with the date and status of passed tests (one to many relation). It does happen that...
July 4th, 2008 05:52 PM
by Marshall Barton Go to last post
2 193
Simple update query question by K M
I have a table containing city names. They are all in uppercase. I'm trying to use an update query to change them all to proper case (first letter upper,...
July 4th, 2008 04:25 PM
by K M Go to last post
3 156
Really weird query responses. by bmacrow
Right, this has been confusing me for days now and I have thrown in the towel and need to get some advice. I am getting some really weird results from a...
July 4th, 2008 12:02 PM
by bmacrow Go to last post
2 166
Subtract positive number from negative number by Brett[_2_]
I have a query similar to this: SELECT Sales.ThisYear - Sales.LastYear AS SalesDifference FROM ThisYear, LastYear; This works fine if they are both positive....
July 4th, 2008 10:11 AM
by scubadiver Go to last post
4 218
Crosstab Query Rows by Andrew Glennie
Hi All, I am reporting on training and need to include YTD training for each month as well as the current month. Currently, I have a crosstab query which...
July 4th, 2008 01:47 AM
by Andrew Glennie Go to last post
6 229
Crosstab Query Rows by Rob Parker
And a follow-up ... My last-night's post is correct, but there may be one other problem: The name of the region field from your tblRegions is shown (in the...
July 4th, 2008 01:38 AM
by Rob Parker Go to last post
0 178
Record Count by Kay
This is a field in my query Field Eligibilty Date: DateAdd("m",7,) Table Total Expression Sort Show Yes Criteria Format mm/yy
July 4th, 2008 12:19 AM
by Ken Snell \(MVP\) Go to last post
2 193
query tables using multiple listed values from another table by TomC
We are trying to set up a query where we have a table with static data that is all located in the same column and we want to use this data as a search...
July 4th, 2008 12:14 AM
by John Spencer Go to last post
1 177
Ranking query by BruceM[_2_]
I have a query that assigns row numbers to the recordset returned by another query: SELECT Insp1.RepairDate, Insp1.DetailID, Insp1.UnitID (SELECT...
July 4th, 2008 12:11 AM
by John Spencer Go to last post
7 204
Ranking (tried a solution by John Spencer, but didn't work) by Emgee
This is my current table "allunitbatch". Want to automatically rank the batch Ids within each MD Batch Id group so it gives the results shown in the Rank...
July 3rd, 2008 11:25 PM
by Emgee Go to last post
1 127
how do i use input parameters with criteria by EKV@VWR
I have a select query which is mainly made up of expressed columns based on "IF" statements comparing the two table in the query then returning a value. I...
July 3rd, 2008 09:16 PM
by EKV@VWR Go to last post
0 161
'Current Row' or similar for query-based combo box by Dan Smith - Sojourn
Apologies if this is an obvious question, but I can't find any suitable query function or operator. I have a series of tables with RI enforced foreign keys....
July 3rd, 2008 08:31 PM
by Dan Smith - Sojourn[_2_] Go to last post
5 181
Post New Thread


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