Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Printing only certain information

Featured Replies

I hope this is the right place to ask this. My customer wants me to make several reports. The first one is all information in the database. The next two is what I have problems with.

I have to print all records that show an item that has not sold. The field I would have to work off of is Date Sold, if there is nothing in this field than I need that record printed. So the report would have Manuf,Remarks,Model,Cal,Received Date,cost of item. How would I go about doing this.

The other issue is: I need a report that would find the tax amount after a certain date. So for example: I need to know all the tax money I brought in after September 10th, or from Sept 10th to Sept 20th. How would I do that. It would work off of the field "Tax Amount" I know this is long. I am new at doing reports. Thank you.

Find all records with something in Date Sold, I usually enter >1/1/1900 assuming you do not have tax payments prior to 1/1/1900, then print.

Second question depends upon how you have the tax data entered. If you create a new record for each tax deposit, simply find for the dates in the ranges you require, 9/10/05...9/20/05.

Check out the manual for finds, it will give you much more information!

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.