davetough
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER