This is now doing my head in !!!
My form Orders, has a sub form called Order Details.
The subform Orders Details has a field called ReSalePrice:
The value in this field is entered for each item within the order, thereby resulting in a number of values in several records under the field name...
Thanks guys - I have checked and double checked the spelling and it's correct.
The only thing I can think of, is that there is something wrong with the expression that references the qry where the totals are calculated.
In the field where I want the data to appear I have the following...
This refers to a basic Customers / Orders database.
I have a form Orders, with a subform Order Details, the order details subform has a field called ReSaleValue
The Orders form has a field called Order Value, which I want to be populated by the sum of the ReSaleValue from each order.
I have...
This is driving me nuts - despite several emails and calls to BT Tech Helpline, I am still unable to send email via Outlook Express.
Allow me to explain:
Outlook Express is set up with a mail account via BT Internet - I can receive email via this server but cannot send. I have checked...
Hi,
In A97 is it possible to rotate a field name through 90 degrees in order that fields with longer names don't hog the width of the page so much ? ie the field name sideways above the data cell.
I am sure I have seen this posted before but cannot find it.
There is a way of calculating the days remaining in a month less weekends.
Please point me in the right direction
Many thanks
Hi,
At the end of each month I import data into my A97 db which via an append qry updates a table with with new data. The attached SQL shows what is going on. The problem I have is that at the start of a new month I have to go into the qry and alter the month, in the code area, [Alloc...