Scott Williams
-
Scroll Bar to the left (vertical) of a Sub-Table
I have a sub-table which I have sized to an area which I want. Once the data in the sub table goes beyond about 10 lines, the oldest data drops off the bottom and cannot be viewed.…
-
Sub table To a tab
I have a sub table on a 'contacts' page which shows me a list of booked appointments for that contact. I want to move this sub-table to a tab - is this possible?
-
Sort dates chronologically
I have a date field in to which i am entering customer birth dates (day,month,year) I want to be able to sort these dates to show their birth day and month.…
-
Can I use the Sum from a list of formulas in a view table to create a new formula
I have a view table in a form which is based on a date range. I want to add a formula on the form which shows the result of two values, in this case "Franchise Fees" from the sum of one of the…
-
Customised print with view table.
I have customised a print from a table that has a view. The view is a list of appointments relevant to the table (customer record) When I incorporate the view in to the print,…
-
Show a form within a form and link it to a contact.
I have a Form which is called "Contacts" for my customers. On this form is data such as name, address etc. I have another form which shows around 30 choice fields for pupil progress,…
-
Show sub table formula result in main form
I have a sub table that shows appointments, a marked delivered checkbox and invoice value. Within the sub table I have a formula that will add up the invoice values of all delivered appointment.…
-
Return sum of values between two given dates.
have appointment dates and sales on a a table in one line. E.g 10/09/2019.....£45.00 each entry is relevant to individual customers. I would like to run a report on all sales in a given time frame…
