A
Angel_G
How do I hide duplicate records on a form?
help Please!
help Please!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
GVaught
Why do you have duplicate records to begin with? If they are true
duplication, field data to field data then delete them.
duplication, field data to field data then delete them.
A
Angel_G
I do not want to display a customer's name for every record, only when the
customer's name changes.
customer's name changes.
R
Rick B
Sounds like you have a one-to-many relationship. The customer's name should
be on your main form. A sub form should contain the other details. For
example,
You might have a form with customer information in the top section, then a
box in the middle of your form with all the customer's invoices.
Sounds like you are not following standard design in creating your database
or forms.
Rick B
I do not want to display a customer's name for every record, only when the
customer's name changes.
be on your main form. A sub form should contain the other details. For
example,
You might have a form with customer information in the top section, then a
box in the middle of your form with all the customer's invoices.
Sounds like you are not following standard design in creating your database
or forms.
Rick B
I do not want to display a customer's name for every record, only when the
customer's name changes.
A
Angel_G
This is a linked table from a SQL database. Unfortunately I do not have
control over the design of our MRP system. The table I happen to look at,
contains detailed info from every customer (PO data) but for every record it
displays the customer's name, which is fine by me but I do not want to see
the name repeated several times unless is a different customer.
control over the design of our MRP system. The table I happen to look at,
contains detailed info from every customer (PO data) but for every record it
displays the customer's name, which is fine by me but I do not want to see
the name repeated several times unless is a different customer.
E
Ernie
You can still control the data that displays in Access.
Create two queries, the first will display the customer
name and any other information that you want to see just
once. Use either 'group by' in the qbe pane or 'select
unique' in sql (if you need to resort the data then
use 'select top 1' in sql instead), to get the name just
once. Bind a header form to this query to display the name
once.
The second query will show the details of the table but
leave out the customer name field. Bind a subform to this
query and hook it to your main form in a parent/child
relationship.
HTH
Create two queries, the first will display the customer
name and any other information that you want to see just
once. Use either 'group by' in the qbe pane or 'select
unique' in sql (if you need to resort the data then
use 'select top 1' in sql instead), to get the name just
once. Bind a header form to this query to display the name
once.
The second query will show the details of the table but
leave out the customer name field. Bind a subform to this
query and hook it to your main form in a parent/child
relationship.
HTH