create 2 reports from table1

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
davetoughAsked:
Who is Participating?
 
MacroShadowConnect With a Mentor Commented:
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
 
davetoughAuthor Commented:
thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.