Search results for query: *

For the group - but don't worry - I have worked around it by changing Make Table for a Delete and Append query routine that works fine. Thanks

Hi there I have a front end MDB file which contains some make table queries that create / overwrite tables in a linked backend database which work fine when I am logged in as an an administrator. However, when I log in as a data user to whom I have applied full admin rights over the tables...

Thanks I will give it a try.

Hi there I have a report which produces a chart from the SQL below: SELECT NewOutputSchemeOverallCombi.Trade, NewOutputSchemeOverallCombi.Percent AS [Overall %age], NewOutputSchemeOverallCombi.Site AS [Site %age] FROM NewOutputSchemeOverallCombi; This feeds off a query which produces blank...

Thanks I will have a look

Hi there I have a report which contains a chart which sometimes displays, sometimes not and somtimes generates the message "cannot use the crosstab of a non-fixed column as a subquery". The SQL to drive the chart is: PARAMETERS [forms]![dateselect2]![month] Text ( 255 )...

Thanks Remou - found function in Make Table query drop down box - my brain is not functioning today!!

Hi there I have a number of make table queries which I need to run over a split database. At the moment when the queries run they do replace the table in the backend but store the new version in the frontend. Is there anyway I can get the make query to automatically store the newly made table...

Thanks PHV that works a treat! Sandra

Hi again PHV - soss for disturbing you again - just one last issue on this - the solution works apart from the Nz function seems to convert the zeros and the percentages it produces to text so that they cannot be graphed properly in Access, I have tried changing the format in the query...

Hi PHV Well got it working eventually but only by making the two feeder queries into make table queries and then using your SQL on the new tables so thanks for pointing me in the right direction. Guess there must be something weird lurking further down in the query on a query etc., will check...

It makes no difference the contract number is just completely blank regardless of which contract number is used or whether there is not one entered at all. It seems the syntax in your solution is just ignoring the contract number completely.

OK here goes tried and to space columns but still wiggly - have used [tab] and is a little better but still a little wiggly so apologies for display - the first query is called NewExcelOutputTradePercent avgs per month and uses the SQL: SELECT Trade.Trade, (Avg([Resp])*8)/80 AS [Percent]...

Hi PHV - yes I can but I need to know how to make the output line up properly as when I just copy and paste the query results they end up wiggling (technical term!!) all over the page. I know you can use TGML but I cannot find the tag that keeps columns on info in line!! Can you let me know...

Hi PHV I used your syntax exactly and sort of gout a few steps closer in that I now get zeros but for everything and the contract number column is completely blank. Can you suggest why - even if I remove the actual contract number to show all contracts it still remains blank.

Hi Remou Thanks for trying but it seems to produce a lot of duplicates and no zeros - here is how I have translated the SQL above into my actual query (i.e. using query names etc. and selction criteria) Any other additions/changes to suggest to end up with list as above. SELECT...

Hi there I have two queries, one which generates monthly averages for the whole company such as below: Trade CoPercent Brickwork 82% Ceramic tiling 68% Decoration 93% Electrical 82% Flooring 45% Plastering 92% Plumbing 85% Roofing 88% Scaffolding 64% I need...

Solved it - got the smaller version of the query to make a table of its own first then ran the form selection criteria separtely - thanks for your efforts though

I don't think it is the number of tables/queries as it works fine if you just remove "))>=CDate(forms!dateselect3!year & "-" & forms!dateselect3!month & "-01") And (CDate([year] & "-" & [month] & "-01"))<=CDate(forms!dateselect3!toyear & "-" & forms!dateselect3!tomonth & "-01"))) It seems to be...

Hi there I wonder if you can help me, the following SQL works with no trouble at all: SELECT Trade.Trade, CDate([year] & "-" & [month] & "-01") AS CalcDate, (Avg([Resp])*8)/80 AS [Percent] FROM (Trade INNER JOIN ContractorDetails ON Trade.TradeID = ContractorDetails.TradeID) INNER JOIN...