Recent content by JimmyS

=if([cell ref] = "H", 1, 2)

I'm more of a searcher here than an expert, but these are the things I would try... You could try making three reports based on the three queries - insert 2 into the first as sub reports. Off the top of my head I think you can drag the sub reports into your main report, then you will have to...

So long as i am looking in the right place - I think it is disabled.....

Anyone know why my num lock light has started coming on when my PC shuts down ? It only started v. recently - I seem to remember it yused to do it - and the mouse stayed lit - but I found a fix (can't recall how - although I think I just changed the mouse from the usb to the serial port) and it...

Thanks. That'll be why I'm having so much trouble... :D I'll try something else.

How do I get a button push on a form in one db to run a macro that I have in a separate database. I have searched high and low, but what few things I have have tried seem to end end when Access can't find the macro - even if a get as far as getting the second database to open. :( Can anyone...

Hi, I haven't got round to trying this yet, but while searching for the same thing as you I found this article on MSDN: How to Create a Table of Contents or Index for a Report Hope this helps... If I get round to trying it i'll post upon its ease of implementation :)

Now I think - but i'm not sure, that you may have to create a form to enter your parameter into so that it is open with the date entered when you load up the report - it might be worth bringing this up in the reports forum to see if anyone there can help...

It is something to do with the parameters.. With the query open in design view go to Query/Parameters on the menu and put in your parameters and data type - e.g "START DATE" / Date/Time and "END DATE" / Date/Time Now if you refer to these in the query it should recognise them.... HTH :)

Firstly have you tried using the report wizard? It will create a report that you can then play around with, it certainly helps when it comes to then figuring out how everything works in reports, it should then become apparent how the source of text boxes are set and you can move on to building...

In the crosstab query on which the report is based, go to the column heading properties and put in fixed column headings in the Column headings property e.g. "1", "2", "3", ".....14" All the headings will always then appear no matter if there is data for them or not. That should help.. :)

This might be useful to use instead of your -format to week. Here's the expression I use in a query to get the week commencing date to group by (mind you its using the Sunday) Otherwise do a search here for 'week commencing' and you get some vba code examples people have posted hope this...

In this thread I posted a link to a samples database where it has a dynamic crosstab report which you can play with - although it mainly in code. http://www.access-programmers.co.uk/forums/showthread.php?t=66732 Its been plenty of work, but i'm almost there with making something work from the...

if only it were my data table - then I might try to work out what this normalisation lark is all about ;) Unfortunately that is how these codes are set in the source data - from another system - and I need to extract a certain few lines to append to another table...

Quick question - I have a set of data that goes A1, AS, A2, A6, BM, B2, GF, T3, 1B, 3G, etc... I would like to select only the fields where there are no numbers - so from the above set it would be AS, BM and GF. Can't quite suss it :confused: cheers Jim