Search results

Hi all Long time since I last posted in here!!! I have spent the last few hours trying to find a solution to an issue I am having with an XTab query, but to no avail, so was wondering if anyone else could cast their eye over it to see if it is even possible (I am thinking it might not be)...

Good morning all (at least, it's morning in the UK) Not posted for a while, but I have hit a brick wall with my MDB developed in A2007. I have a query, it's a Xtab which takes data from an Aggregated Select, which in turn takes data from a table. The query is not sorted in datasheet view...

Hello I have an issue with a make-table query. Im not sure if I should have posted this in teh Table or Query sections of the forum, so I apologise if this is inappropriately classified. I am using Access XP/2002 and the MDB is Access 2002 format and has user level security enabled...

Hi all, I am having a bit of trouble with a query I want to make, such that I can't actually figure out how to do it (tried trial and error, and about an hour of googling). Basically I have a Select Query with two tables joined. One table has a series of rows with a "sale date" field and...

Basically I have an append query, which takes data from a series of sub queries to append to a table. The sub queries are also used elsewhere in the database and have parameters. What I would like to do (if it is possible) is to have the append query use a "preset" fixed value for the...

i have a chart powered by a query, and can't seem to get number formats (the chart has a data table) to stick. i have tried setting them in query design mode and in the datasheet. is there some way i am missing? is there any sql code i can use to "force" the fields to be rendered as...

just wondering - anyone know the VBA function for copying an ole chart to clipboard? various places suggest the command oleobject1.copy, but that doesn't appear in my ver of access (2002). also do i have to clear the clipboard first? thanks

http://www.access-programmers.co.uk/forums/showthread.php?t=111547 this is an old thread, now closed, but still useful I think. I have tried to copy and paste the form into my Access database with User Level Security, but I get various errors when I run it (On Load Event - User Defined Type...

Hi - I've posted this on another forum and after a week I haven't got any replies. Hopefully here will be able to help or at least confirm it's not possible :) I have a simple query, polling on several crosstab queries with fixed column headers based on relative dates. Basically the infamous...

hello all got a bit of a puzzle i have set up a union query to give an extra row at the bottom of a cross tab query containing the averages of the above columns, with the last column being a total count of the above the code is: SELECT DISTINCTROW tblSold.[MOD] AS Model...

Hi everyone, Just wondering if anyone on here knows a way to get Pivot Charts generated in Access XP to "ignore" zero values. My situation is this - I have a pivot chart (line) with an X axis going back 1 year by month. I am plotting the prices of particular models of car over the year, but...