Search results

godofhell, Thanks for the sample, I had looked at this as an option before, is there a way that you can lock the form so it open up right underneath the button, even if the main DB screen has been moved or resized ? Thanks for the help. MattP

Ok this is a bit long winded and I will try to explain, I have a main form, with a title at the top, then a row of buttons underneath and underneath the buttons I have a sub form. Some of the buttons can have a dual function (or multiple function) so rather than open up another form I have...

Can anyone help with this query ? Thanks MattP

Just to add to the earlier entry: If I run this query today then it will return data from 16th may - 31st May. The query does nto have any results for the 21st or 22nd, 28th, 29th, 30th as these were weekends (and a bank holiday) and therefore there is not data. Excel creates the graph as...

Ok, not sure if this is a fix with the report chart or the query, I run a query that captures the last 15 days worth of entries, however currently it counts weekends, which are blank, as such I do not get a full 15 working days worth of data. This is fine when exporting the data to Excel as the...

The Doc Man Thanks for your help, it worked, though I moved the format around to show "mmm-yy". it worked perfectly. many thanks for your help MattP

Pat, Sorry for what is probably a basic question, but where would you use the DateValue expression, I want my query to report the date only and it already has criteria, on the date entered, that only collates the last 12 months worth of data. I want the query to have a 2nd column that give me...

Ok I tried the following formula and it seems to show the right results Between DateAdd("m",-13,Date()) And DateAdd("m",0,Date()) However, I had to set the final query to Zero instead of 1, to show February's data, else it only included January. Is that because today is the first or a bug in...

SJ MCAbney, I am trying to use the formula you suggest : Between DateAdd("m", -11, Date()) And Date() And it does seem to work well and pull sout the data as indicated, I can also change this to show 12 months of data etc... H owever can this be adapted as I want my query to show everything...

ColinEssex, Ok many thanks, I'm sure I can get this to work in the query criteria, my query is not run via the DB, it is accessed via an Excel report, that extracts the query data and creates several pivots and charts. I'll give it a go. Thanks MattP

Guys, thanks for the quick responses, ColinEssex I assume your formula would be in the criteria for the date entered field within the query? Again thanks for your help. MattP

I currently have a query that looks at the "date entered" and then returns the data for the last 15 days. What Formula do I need to put in to capture the last 12 months worth of data ? Basically if the query is run anytime in February it would show the data from January back 12 months ? Any...

Is there a way you can set where a from Opens in relation to a button or a piece of text you select. Basically I have a main form, with some selectable options on the LHS of the screen, rather than use buttons I have text boxes programmed to open a form using the "On-Click" event, I want the...

I've checked the threads for this one but have not found anything specific. My report is designed and setup in a landscape format, yet when I send it by email (in rtf format) the attached document is in portrait format and I lose the neatness of the report. Is there a simple bit of code I need...

ANy further idea's ? thks MattP

ColinEssex, Thanks for the code, but I really need to do this without a form, I need excel to grab the data out of the query, without the user actually opening the DB or running a form. Is there any other coding that coudl be added to teh query itself ? or a module to run ? I appreciate your...

Colin, Thanks for the code, but I really need to do this without a form, I need excel to grab the data out of the query, without the user actually opening the DB or running a form. Is there any other coding that coudl be added to teh query itself ? or a module to run ? I appreciate your...

Colin, yes I need to exclude Saturdays and Sundays, I have tried the following code in the query criteria for "Date Entered": <=Date()-0 And >=Date()-15 However this does not giveme 15 working days of data, because the weekends are blank it just misses those days out, preferably I would like...

I would like to set up a query that captures records entered from the previous 15 working days, not including today? My table records the date entered but how do I tell it to gather 15 "working days" worth of data, up to yesterday or the previous day.? Additionally I will be setting up excel...

Sorry I should have posted this under queries