Search results

I have done all that. It is identical to the form which works. That is what has me stumped

Hi Folks This is a weird one. I have a text box (OtherDec) on a form. The form is bound to a table and it works fine. I have copied this text box and others from the form to a report to use the same layout. All the other fields work fine in the report except for this one where I am getting a...

As I said in one of the other posts, the control source is called "MonthName" in the crosstab query structure but I have used column headings to display each month (if null values exist). When I view the dataset the column heading is definitely "Jan"

I am a bit confused trying to do this. The crosstab has a field "MonthName" which obviously generates the month headings but some are null. The column headings settings fixed that. Here would I put the Nz in the query?

It Is =Nz([QrySalesTYEvents_Crosstab].[Jan],0)

I do but only as I added the column names in the column properties. It does show Jan though in the query

Thanks. I tried that - same result with error message

Hi I am trying to replace null values on a form with Zeros. I have placed the following in the control source of the field but keep getting a #Name? error. =IIf(IsNull([QrySalesTYEvents_Crosstab].[Jan]),0,([QrySalesTYEvents_Crosstab].[Jan])) Could someone please point me in the right...

Agreed but I am working on calendar year from 1/1 to 31/12.

I used "Month<=" & [month] & " And Year=" & [Year] but modified it to "MonthNum<=" & [monthNum] & " And Year=" & [Year]) where MonthNum is the number of the months 1-12 sorted in ascending order.

Yours worked for me

Thank you so much for this. The data does have multiple years so this works perfectly for each year. Cheers

Hi I am trying to create a running sum in a query based on both months and years where both fields are integers. My expression is "RunTot: DSum("TotalSales","QrySalesbyMonthandYear","Month<=" & [month] And "Year<=" & [Year])". This seems to work when I only use the month criteria but when I...

Hi I hope I explain this properly! I have a query that includes three fields, "Group", "SubGroup" and "StockItem" where the items in subgroup are related to groups and stockitems are related to subgroups. I have a form where the user selects each of these from separate comboboxes. At...

Thank you all. Using Filteron worked! Appreciate your assistance folks.

It is FrmStockOutHistory

Sorry I don't know what that means

Thanks folks I tried: Me.FrmStockOutHistory.Form.Filter = "[StockItem] LIKE '*" & filterText & "*'" But still does not work.

Hi folks I have an unbound form "frmStockInvHistory" On this form I have 3 tabs, each with a different form displaying different information. These are "FrmStockOutHistory", "FrmInvAddedHistory", and "FrmInvUsedHistory". I am trying to apply a filter to a field "StockItem" on each form but at...

Thanks very much for that. I will have a look and hopefully get the hang of this. Thanks again for your help.