I am desiging an access form with auto records, such as an auto number (transaction number), an auto date (today's date), and fields that are populated with sums of other fields, ie one field divided by another.
I am then trying to append these records to a table but when I append it the...
I have now managed to see the most recent information and the customer information but can not update information on the table with the customer on it only once in the view.
Is it possible to do this?
Thanks,
Claire
Is there a way to view the most up to date informtion from a table when linking tables that have one record per customer on one table and more than one record on the other table?
For the table that has many records I just want to see the most recent record.
Thanks,
Claire
I am trying to develop a form that contains information from tables with more than one record and tables with each customer only once. I want to show just the most up to date information from the tables where there are more than one customer record.
Can this be done?
Thanks
I am trying to set up a database of customer information and I am trying to set up a drop down with all companies beginning with a certain letter. For example, if you know your company begins with the letter B, you key in B and all of the companies beginning with that letter come down.
Thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.