Recent content by SammiH

Just in case someone replies to my problem- I finish work for the day now and won't be back until Monday - it's not that I am being rude if I don't respond. Thanks Sam

Hi, I have read through other posts, but still can't solve why I can't get Bob Larson's tool to work :confused: I have opened the tool. I have specified the 3 locations - 1) My existing front-end master which is a .mbd file here : S:\PIT1\Reports & Data\Database\Database Development\Front End...

Hi, I will pull in data from April to current month for monthly reports and there is also a quarterly report that I will need to set up in a similar way, so that will use data from 1st Q, 2nd Q and so on. The caretaking report so far only has sample data in it for the 3 months. The bit I'm...

Hi Thanks for reply -sorry for not posting sooner as I don't work the end of the week. I have tried crosstab query, but not sure if it will work as I need more than one columnheader, and crosstabs only allow one - be grateful if you could explain how I can use a crosstab to achieve the report...

An update and a bump - I've managed to create what I want with a Form using Pivot Table wizard, which successfully opens in Excel where I can update the data using refresh. What I need to do now though is : 1. Refresh the form within Access rather than in Excel 2. Create a report in Access...

A sample is attached for the ASB service- each indicator is on a separate page (title in red). For caretaking, there are only three indicators, so they want them on the same page under each month, so month as column heading and indicator underneath each month, also as a column heading, but...

Thanks for your very quick response - the report at the moment has a drop-down box to select which service we are looking at (eg Caretaking), the date field as column headings and the block and indicator fields are row headings, so the performance appears on separate lines. What they want is...

Sorry in advance as I am totally self-taught and need very basic explanations if you can help! Can I present the attached table in Excel in a database report? If so, how would I design the report/ query? I have included the basic table structure that I have at the moment (it is a very large...

Thank you- I've now solved this using the ElseIf code: If Me.Text61 = "On Target" Then Me.Image3.Visible = True Me.Image2.Visible = False ElseIf Me.Text61 = "Not On Target" Then Me.Image3.Visible = False Me.Image2.Visible = True Else...

Thank you very much - that worked, but I have a third variable where I don't want either picture to appear, how can I phrase this? In other words, the txtEvalControl can be "On Target" (Image1), "Not On Target" (Image2) or "na" (no image).

Not sure if this is possible, but I have a text box that currently returns different text based on an Iff query. I've set it to Wingdings, so I get a smiley or sad face depending on whether a value meets a target or not (True/False). Here it is: =IIf([Text61]=" ","...

Someone please help me on this, as I am now tearing my hair out and have a deadline to work to!

Ok - seems this is quite a complicated request! I'm still trying! Does anyone know if I should put the calculated true/false field in the graph query or in the underlying report query? I have put it in the report query, but then I get 2 graphs - one showing the "trues" and one showing the...

I used insert chart - I have Access 2000 premium and I can't see a 'pivot chart' option.

Thank you for offer, but it is a database I use at work and it contains restricted data, so I can't send it to anyone. I'm wondering if in the graph query, I can produce a calculated field to show 'true' or 'false' for met target, then get the graph to look at this field in a vba code? Sorry...