Solved

create 2 reports from table1

Posted on 2014-04-08
2
166 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 26

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

706 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

19 Experts available now in Live!

Get 1:1 Help Now