Recent content by janeyd

Thank you - I will give this a go!

Hi I have a crosstab query with one row heading and lots of column headings that show over several pages. Is there a way of having the row heading appear at the start of every page? Thank you

Perfect. Thank you :D

Hi I have created a simple query to show pattern requests from a trade show set out as follows:- Cust No. Name Pattern Comments SGE1 Kinga NJ42-1 All SGE1 Kinga NJ59-5 All SUK4 Jones NJ42-1 Col 3 To make this easier to read/pick i created a crosstab query from...

Thank you both. I have gone back to basics and am building what I need one step at a time - seems obvious but couldn't see wood for trees at first!

Thank you. Funny how it's always obvious when someone tells you the answer :-)

Hi I have a query which includes a calculated field as follows: Free Stock: Nz([Total Stock],0)-Nz([SumOfKg],0) In some cases this returns a negative number and I would like this changed to a zero. I have tried the following in the criteria IIf(Nz([Total...

Hi I work in a small company warehousing yarns ready to be woven into fabric. I have created a simple stock database, and can enter customer orders with an estimate of all different yarns required for each fabric. (not an exact science unfortunately) So i have queries/reports of total yarn in...

So... Another step forward. I have used:- Me.Yarns_Query_subreport.Visible = Me.Yarns_Query_subreport.HasData which although still shows the labels headings in report view, when I go to print preview they are not there. This is fine as I am only one going to look at it in access, everyone...

I've been trawling the web and found lots of solutions to this, however they aren't working for me. I was wondering, is a tick box in a report - even if it is unchecked and just the actual box, classed as data? Thanks

Ahh - I just added sent to mill to the yarns query and set that criteria to null. Now I am getting closer (I hope!). The info doesn't show but the box and labels do - is there any way of not having that show if there is no information in it? Thanks

I'm afraid not. The sent to mill box is in the first subreport (Order Details Query subreport) therefore if I set criteria to null it doesn't show any of these details. I still need to see these, including date I have entered until the order has been despatched. thanks

Thanks moke123 I am hoping it is just my wording but have tried a few variations of what you suggested and still can't quite get it :-( I have uploaded my database if someone had the time to view I would be very grateful. The report I open is 'Orders Query'. On the record Order No...

Using subforms makes it difficult to present data how I want. I think I may have to give up and put everything on a big excel sheet. :-( Thanks for trying to help though

Hi Thanks for this however doesn't quite work. When I add the Report load event to main report, it doesn't recognise 'SentToMill'. This field is actually in first subreport, therefore I put your code in load event of that instead and although it didn't show up as an error, it didn't work...