Search results

Cant thank you guys enough, Im only and analyst and dont have the SQL knowledge but know the right questions to ask to get there. namlian and plog have been invaluable recently to me.

Hi I've PM'd you, I just wanted to automate this without having to edit every month an rreplace February with March etc 6 times (its a 5 minte job) but still there must be a way.

Hello again, the statement below is a snippet from a union query and is repeated 6 times within the SQL Statement for various reasons, I have to manually change this every month, again is there i tiny bit of code I can insert to replace the following so that it automatically runs the previous...

thats didnt work my friend, my fieldname is called AttendDate, if this helps, Im assuming you have to do something with the (date) bit???

Every month I have to go into numerous queries and change the dates (as below) so that it runs the previous months data. Is there a criteria where no matter what day of the month you run the query it always pulls back data from the previous month (eg if I run the query in March 1st or 30th, it...

Age: DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd")) This has worked for the last year, and today I tried running the query and got a compile error, very odd!

Is there a way I can automatically run a macro which formats a spreadsheet upon opening a spreadsheet. I have database which exports a query to an Excel File, but each time I export the file i have to manually go into the spreadsheet and format the thing. Would be great if i could do the export...

>=Date()-IIf(Weekday(Date(),2)<3,4,2) And <=Date()-1 This did the trick and matches exactly to my orginal report, Ill trial this for a week running both to ensure it works, huge thanks you my friend and very much appriciated.

Ah got it mine was picking up 1 date [AttendDate] and your has picked up 2 dates, to simplify I was running a report for all attendances on a single day except when I run it on a monday as this will be Fri, Sat & Sun (s days). I probably got it wrong somewhere. When I took out the additional...

Do I have to put my field name anywhere in the criteria of just copy the above, I have run it and ended up with more records than the one i ran today using my old one.

Huge thanks for that my friend, however working in a hospital although I dont work weekends the report needs to tak into account the weekends, thus on a Monday I run an extra 2 days worth before going back to the usual routine during the week

Hi again this is slightly more complex, again I run a report based on dates I enter (see below) >=[Date you wish to view DD/MM/YY] And <=[Enter the Date after DD/MM/YY] I would like to automate this if possible, the dates are enter are always a set pattern If its Monday I enter the previous...

Hi guys, wondered if there is way to simplify this. I run a query daily and have to alter the date in the design view (as below). >=#01/04/2013# And <#11/03/2014# All I want is for the query to run 2 days behind, so for example today is the 12/03/2014, I use the above, and then daily change...

Hi chats I have 4 columns PostCode District District Name Count of Postcodes = Count(Left([hull_PostCode.PostCode],4)) Now some Postcodes display 4 lines as they cover 4 Districts, my questions is I only want to show the highest Count per postcode and disregard the rest, Ive tried many...

Hi guys again, Ive exported some data which has 3-4 address line within the same field which is very odd. The row has all the usual data, but when I look at the data in datasheet view the adresss line 1 shows only but when I click into the field and press down, more address info comes up. Is...

Is it possible to search a field for a Lowercase letter. All data should be capital, but occasionally a user may ann a record in lowercase, and was looking for a query to pull back all records in lowercase

Hi guys this is going to sound odd, but am stumped on every google search. I have Access 2012. when i (RIGHT-CLICK) on any query, you normally have the options OPen, Print Preview, Design View, Export etc. When I right click the Export... and Save As.... are blanked out meaning I cannot use...

Hi guys, I have a small task and having a mind block. I have set up a Parameter query which works, and use this on a form. What Im having a problem with is using an unbound field on the form to be the parameter. For example in the Empty feild/box on the form I would type SMITH, and this on a...

Very simply, how do i convert 20130214number into 14/02/13 date.

ODBC--call failed. [Microsoft][ODBC SQL Server Driver]Timeout expired (#0) today I came accross this error message and came a bit unstuck, Im not the developer of the database we use, and tried compacting/repairing, also copying the database, I tried many backups from weeks ago, and also...