The recordsource is currently a query - but its a crosstab so its all dynamically assigned on load.
I will try the totals option though. Maybe I can dynamically assign the query total to those textboxes.
Hi
I am attempting to print a form which contains several subforms. The data in the subform header and detail sections displays fine. However the figures in the unbound textboxes located in the footer are not displaying - only blank boxes are visible.
My print code is (although as a side...
Thanks for your suggestions @Pat Hartman
The tables are in SQL Server so how would I check it is Null not 0 in SSMS ?
Note - these are tables we have been using for many years without an issue!
Just checking back in to see if anyone has any ideas on how to resolve the Avast blocking issue.
Any insights or suggestions would be much appreciated. Thanks!
Hi there,
I am managing a MS Access DB coupled with SQL Server backend.
Occasionally users report that records go missing and I it may have to do with the following error although I am not clear on what it means and what to do about it. If anyone can enlighten me I would appreciate!
I'm encountering an issue with Avast antivirus blocking a macro that's intended to automatically update Microsoft Access to the master version. Despite adjusting settings, I haven't been successful in resolving this problem. Below is the code to run:
Option Compare Database
' global variable...
My solution was: £#,##0.00;(£#,##0.00);\0;"£0.00"
FYI this was very useful in explaining
https://documentation.help/MS-Access-Visual-Basic/acproFormatNumber.htm
This is the CT query:
TRANSFORM Sum(qryDailyLeadsShort.CountOffldOrderID) AS SumOfCountOffldOrderID
SELECT lkptblDays.fldDay AS [Day], Format([cfdate],"dd-mmm") AS [Date]
FROM (lkptblSupplyFit INNER JOIN qryDailyLeadsShort ON lkptblSupplyFit.fldSupplyFitID = qryDailyLeadsShort.fldOSupplyFitID)...
Hi
I have the following crosstab query which summarises the sale figures for each day. However I would like to have 0s in place of blanks.
When I try Nz() or IIF(null()) it doesn't work - probably because there are no rows to summarise for those days.
Any ideas how I can do this?
I'm also thinking there can be a logic to get this working. For example if I number each row and hide any numbered above 1.
I'm sure it would be possible somehow.