Search results

Hi there, I'm just getting into using VBA with Access to generate queries and filter reports. I also know a fair amount about Excel. What I'd really like to get into is generating reports automatically which include a whole range of (possibly dynamic?) graphs, linked to a variety of queries...

ah I see what you're saying. hmm.. not sure. I've found if I stick a parameter on (query 1) then it WILL feed through the others, because they are all linked to that first one. So if the master one is filtered by date (or whatever) then so will the others? As I said I'm still experimenting...

Hi there. Sorry I am new to this so not great at explaining. I specified it in the master/final query4: the break down is this tables (various) ---> query1 ---> query2 ---> query3 (crosstab)-->query 4(crosstab) the form orginally had a combo box but now just a text box, into which I can put...

It sounds like we are doing something similar- I am trying to run one query that links to a chain of about 4 or 5 queries (don't ask, it seems to be the only way I could get the data ordered and grouped correctly) I tried creating a form as described above and also using <a...

great, ok thanks neil.. I hadn't thought about going back to day 1, then subtracting a day, too caught up in how to go back a month right ok! thanks for pointing me in the right direction, I will go and investigate further... all the best, Catherine

Hi Neil, thanks for this right, that may well be the problem. Thanks for pointing this out! I will go and change them to something more unique * I only record the month end dip; on the last day of the month. Other values eg total delivery value might have a different day connected to it -...

aah : those are not field names as such, closing = table name, which has a field called DATE. I'm trying to get my head round how the SQL query part works in Access - I've noticed sometimes it puts things in square brackets eg "SELECT [closing].[DATE]" or "SELECT closing.CLOSE AS [OPEN]"...

Make table query? Hi again.. I just had a look at the 'make-table' query in Access Help - this sounds like it is what I want to do, the problem now is when I try and do from "SQL view" of the query back to "design view" I get an error message "Microsoft Access can't represent the join...

Hello, thanks for your response! Sorry I think I've been a bit confusing. The different tables I have are not one for each month, but rather one for each type of information. So, one table shows each tank with the closing dips for all the months I have, one table shows the total sales for each...

Using previous month's "closing" value for this month's "opening"? Hello, I've been looking through the archives and learnt a fair amount about date manipulation, but am still a bit stuck. I'm sure there is a way to do this and would appreciate any ideas: Basically I am monitoring changes in...

Hi Murli, thanks a lot that's great! Just what I needed. It will help me out with a few other problems as well :) all the best Catherine

Hello, I'm new to the forum and relatively new to Access. There's something I'm trying to do but I'm not sure if it's even possible so I'm hoping someone can help me out and point me in the right direction the situation: I have one very big table containing data for around 250 petrol...