Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Comp2008
  • Content: Threads
  • Order by date
  1. Comp2008

    Convert pdf to epub

    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...
  2. Comp2008

    Slow when running some Windows applications

    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...
  3. Comp2008

    Read Only to a specific record

    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...
  4. Comp2008

    Add a total Dollar amount Within a specific group

    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...
  5. Comp2008

    Subtract two expressions in a Query

    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...
  6. Comp2008

    Count two fields based on Date in a Query

    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...
  7. Comp2008

    Replacing #Error Message

    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...
  8. Comp2008

    Count and Group By two fields in a Query

    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...
  9. Comp2008

    Count Combinations of fields in Group Totals

    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...

Part and Inventory Search

Back
Top