A
angie
i have a table with the following fields:
1. field containing card numbers (unique field & primary key).
2. lookup field to customers' table based on criteria allowing selection of fast-moving clients. each customer may have more than one cards (relationship one-to-many with customers' table).
3.lookup field to customers' table based on criteria allowing selection of slow-moving clients. each customer may have more than one cards (relationship one-to-many with customers' table).
problem statement: i want to create a query that counts how many cards correspond to each customer and the corresponding card numbers (e.g. from 15 to 20 and from 51 to 52). how could i achieve that?
moreover, i want the query to show only field 3 and if it is blank to show field 2.
pls help me!
1. field containing card numbers (unique field & primary key).
2. lookup field to customers' table based on criteria allowing selection of fast-moving clients. each customer may have more than one cards (relationship one-to-many with customers' table).
3.lookup field to customers' table based on criteria allowing selection of slow-moving clients. each customer may have more than one cards (relationship one-to-many with customers' table).
problem statement: i want to create a query that counts how many cards correspond to each customer and the corresponding card numbers (e.g. from 15 to 20 and from 51 to 52). how could i achieve that?
moreover, i want the query to show only field 3 and if it is blank to show field 2.
pls help me!