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 Reverse Sort Order / Thread Starter Last Post Replies Views
Zero instead of null by SHIPP
I have created a cross tab query with a count. How do I get the cross tab query to display 0 instead of a blank and/or null? -- M. Shipp
May 14th, 2007 12:39 AM
by Duane Hookom Go to last post
1 51
zero in query count by andrew
Hello all! I have a query to count how many records meet a certain specification, which is then routed to a form. (The count is set to count the number of...
August 27th, 2004 09:48 PM
by Ken Snell [MVP] Go to last post
1 160
Zero filling a string by Jerry
I have an autonumber field that I want to put into a text field with a field size of 10, and left filled with zeroes - for example, the first autonumber field...
January 6th, 2005 08:44 PM
by Jerry Go to last post
2 81
Zero fill field by Marcie
I have the following calculation FormattedTotal: Format(,"000000000") it takes the value 15192.3 and turns it into 000015192 I need 001519230. Can anyone...
October 27th, 2009 03:01 AM
by John W. Vinson Go to last post
5 144
Zero Fill a Field and remove decimal by ms
Access 2000: I have numeric fields in a table with decimal and non-decimal values. I need to zero-fill these fields and remove the decimal but keep the 2...
September 29th, 2004 08:31 PM
by ms Go to last post
9 145
Zero Count not showing? by triplespiral
I have a query (two fields - one sale type, one lot #) in which the lot is set to count. The current query I have displays the information as zero if there...
January 5th, 2007 06:08 PM
by Jeff Boyce Go to last post
4 101
Zero comes before 8000 in a descending sort?!?!? by Phil
I have a table with Five fields. I give it to you here in CDF...
February 13th, 2006 07:06 PM
by Phil Go to last post
6 92
zero a field in duplicate rows by Manny
Hi, I have a table with duplicate rows, which is fine, that's what i need to display. i have the same field 'balance' in all those rows. My question is; how...
February 8th, 2007 11:58 PM
by Smartin Go to last post
5 79
Zdouble Problem by Benjamin
Hi, i have an DSum function to sum the "St=FCckzahl"(quantity),=20 in that function i got an Zdouble criteria. The Zdouble=20 refers to "Datum"(date). I want...
August 25th, 2004 10:23 PM
by MGFoster Go to last post
1 118
YTD Subtotal by wburbage
I’m not sure if this question belongs on this board or an excel board, but hopefully you’ll be able to help. I have an access query set up that I use...
May 14th, 2007 07:55 PM
by wburbage Go to last post
0 84
YTD Subquery problems by equalizer
I am trying to create a report that allows the user to select a specific month and year for which to see MTD and YTD sales figures for specific products. It...
January 4th, 2007 08:16 PM
by equalizer Go to last post
4 111
YTD Subquery is not including December why? by jeromez
Hi Allen: I created a query with a subquery to sum the hours worked by period (i.e., month) and then YTD hours next to the month hours. However, it's not...
December 2nd, 2009 02:15 PM
by John Spencer Go to last post
5 239
YTD previous year by [email protected]
Hello, Im trying to get the prevous YTD to work. The current year to date works fine. Projects: Sum(IIf( Between !. And !.,1,0)) Here's the expression for the...
January 17th, 2006 10:28 PM
by Krizhek Go to last post
1 94
YTD Formula doesn't work for Oct-Dec by Phil
I have records which represent invoices including the date and invoice total. In a query I add two columns converting the date to a month number (1-12) and...
October 7th, 2004 05:12 AM
by Allen Browne Go to last post
1 161
YTD for the fiscal year by Alex
I have a fiscal year from August to July. How could I set up a date in my query to show YTD showing only completed months data for the current and previous...
March 16th, 2005 11:55 PM
by Alex Go to last post
5 89
YTD by Jessaudrey
I Have a table that lists total incoming calls for a week for each agent. I would like build a report/query that gets year to date information as a running...
March 2nd, 2006 10:07 PM
by John Vinson Go to last post
2 54
your microsoft exchange server is unavailble by adel amer
dEAR SIR I bought pckect pc recently, and every time i try to sync with my PC through ms outlook i get this massage(your microsoft exchange server is...
November 4th, 2004 02:56 AM
by Douglas J. Steele Go to last post
1 226
Your advice for Many to many relain.. by Tom
I have a database that keeps track for all properties I'm doing a title search with the folowing tables. I have a database that keeps track for all properties...
July 30th, 2004 09:56 PM
by Tom Go to last post
0 120
You tried to execute a query that does not include the specified expression... by Nancy via AccessMonster.com
I originally thought this problem was with my report so I posted it under the reports section but not I'm seeing that it is a query problem so I am re- posting...
April 20th, 2010 05:21 PM
by KARL DEWEY Go to last post
1 655
you tried to assign the null value to a variable that is not avariant data type - MsAccess 2007 by Jaycee[_3_]
INSERT INTO WINB_LOYMESSAGES_VER ( LM_MSG_CNT, LM_MSG_NUMBER, LM_MSG_TITLE, LM_MSG_STATUS, LM_MSG_PRIORITY, LM_MSG_ADDED,...
October 8th, 2009 09:26 PM
by Jeff Boyce Go to last post
4 105
Post New Thread


Display Options
Showing threads 61 to 80 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: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.