I'm trying to publish an ebook at Barnes and Noble. I have the book on pdf format and using Calibre it's converted to epub. The problem I have is that B&N allows only 20 MB file to publish an ebook. My pdf file is 19 MB but every time I convert it to epub format, it increases to almost double...
My computer is very slow when some Windows applications are running. I defragmented and fixed bad sectors of the C: drive, I deleted open and running applications through regedit, I removed all the unnecessary programs, cookies, temp files, scanned and fix antivirus. It is slow only with Windows...
I have a Database (MS Access 2007) in a public folder; many people have access to it. Therefore, we encounter an inconvenience lately. When a record is filled out, I have no control over some other users to make changes after the deal is completed. In other words, once the deal is done, I...
Part of my Access Database has two fields that I want to work on: [Models] and [Gross]
[Models] has a drop down list with ( “A”, “B”, “C”, etc,) options. And the [Gross] field has Currency as a data type.
How can I get a breakdown of the total Gross of each individual model? An example of...
I have two expressions that I want to Subtract.
Code 1:
Abs(Sum([BDC Info Table].[Pre-Owned or New]="New" And ([BDC Info Table].[Sold Date]<=#12/1/2008#) And ([BDC Info Table].[Sold Date]>=#11/3/2008#))) AS [CountNew]
And
Code 2:
Abs(Sum([BDC Info Table].[Status]="Sold Not Set" And ([BDC Info...
I'm trying to Count data in a Query Combining two different fields based on the “Date” the product was sold, and for some reason I get a wrong data. When I use only this expression, It works fine:
Code:
Count(IIf([BDC Info Table].[Sold Date]>=#11/1/2008#,0)) AS [CountNovSold]
But when I want...
I’m building a Database which the data is constantly changing. Some fields have 0 (zero) data until the transaction is finished. Now, when a calculation is a division in the Query, for instance [Sold] divided by [Appointment Kept] I get a #Error message. We all know that the quotient of 0/0...
How can I Count the number of Customers that a Sales Person had in a City X? The idea is to Group By [Location Name] and Sub Group By [Sales Person], and then Count the rest of the fields. This is the scenario:
[Location Name]...[Sales Person]...[CountOfCustomers]...etc
.......CITY1...
I’m trying to do get a total count between two fields: [Appointment Kept] and [Internet Source]. The name of the table is “BDC Info Table”.
I have this expression which works perfectly in the Report Footer (Grand Totals)
Code:
=DCount("*","[BDC Info Table]","[Appointment Kept] = True And...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.