Solved

create 2 reports from table1

Posted on 2014-04-08
2
167 Views
Last Modified: 2014-04-08
Hello,
attached database example:
Need to create 2 reports from TABLE 1.
In the table you will see numbers like 099-885-173 and other numbers with no dashes and different number of digits.
1 report needs to only include records with numbers in the ScanNumber field like 099-885-173 ( with dashes)
2nd report needs to only include the numbers without dashes
( note: the numbers with dashes will always have same number of digits and will be formatted same)

thank you
test-a-database.accdb
0
Comment
Question by:davetough
2 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39987133
Use this sql for the record source of report 1:
SELECT TABLE1.[Building#], TABLE1.[Tracking#], TABLE1.ScanNumber, TABLE1.SDate
FROM TABLE1
WHERE ((InStr([TABLE1].[ScanNumber],"-")>"0"));

Open in new window

And this sql  for the record source of report 2:
SELECT TABLE1.[Building#], TABLE1.[Tracking#], TABLE1.ScanNumber, TABLE1.SDate
FROM TABLE1
WHERE ((InStr([TABLE1].[ScanNumber],"-")="0"));

Open in new window

0
 

Author Closing Comment

by:davetough
ID: 39987727
thanks for your help!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now