Search results

nothing even that complicated. something similar to clicking the "Create Query in Design View". I just need that option available to the users but when the Db goes live the Db window wont be available to the users so i need to put it on the switchboard.

I have a switch board in a Db - I would like one of the options on the switch board to be "Create New Query2 Does anyone have any idea of anyway to create a completly new query either using code or any other way? any adive is greatly recieved.

ok. Im trying to count the number of order per month. As far as i could see i couldnt simply count the months in one query - access seems only to allow me to count one month per query. Anyway i was given some advice that suggested that i should create a base query and use dateserial to change...

I have created a base query which gathers together dates from a query and using dateserial chnages the date format so that all of the dates start wioth the day(1) eg 01/12/2002. I had planned to use the basequery in another query to count the number of dates per month. However when i come...

thanks for the reply i was really looking fo a way to have mulitple counts in one query one for orders in january then one for orders collected in febuary. something liks January Febuary Count results12 Count results12 I could...

Ok im using this SQL to count the number of orders that are created that are month old. SELECT Count([tblEnquiryRegister].[enqRecieved]) AS [One Month Old] FROM tblEnquiryRegister WHERE (((tblEnquiryRegister.enqRecieved) Between DateAdd("m",0,Date()) And DateAdd("m",-1,Date()))); I would like...

Rich thank you so much thats a problem that has been bugging me for days. I didnt think counting a certain date would be so complicated. I hadnt realised i needed the two collums with the CountOfJobID: Count(tblEnquiryRegister.enqRecieved). I have looked in books and in help and there is nothing...

Ok i have tried this where enqRecieved is the field i wish to search and tblEnquiryRegister is the table the date is within ## =DCount("[enqRecieved]","tblEnquiryRegister","[enqRecieved] = #12/12/02#") the date is definatly in the table but the query doesnt return any results. Someone must...

I didnt write the sql i used the design sheet and entered the Between Date Add fucntion in ti the criteria field. Heres the Sql tho. SELECT Count(tblEnquiryRegister.enqRecieved) AS CountOfenqRecieved FROM tblEnquiryRegister HAVING (((Count(tblEnquiryRegister.enqRecieved)) Between...

I was entering the date data as a test. I was collecting inforamtion abour orders taken one year ago from date() using Between DateAdd("yyyy",-1,Date()) And Date() This is what i need in the criteria. If i just want to list the dates then it works fine when i add the count fucntion...

I have a table with dates in it. If i count the number of dates in the entire table then everything works fine. If i put a date in the criteria such as #12/12/2003# (you do need the # to tell access to look for a date dont you?) then the query returns nothing. The data is in the table and the...

Thanks

Thanks for all your help. In case you were wondering the criteria that finally worked was Between DateAdd("y",-1,Date()) And Date() Only one "Y" was needed. for the year. I probably should have seen this earlier. But then its always easier in hindsight. Thanks again Chris

Newman Your English is probably better than mine and im English and thanks for all of the replies. I get what you mean from the first post. I have put it in Exactly as you said in to the criteria field on a query. The field it is referncing is set to date/Time and it is set as a short date...

Sorry about the delay ive been away. Looping th=rough the ranges will depend on how the data is organised. I know i keep giving you links but there is a good page which expalins ranges in excel quite well http://www.microsoftexceltraining.com/VBA/ExcelRanges.htm The way that you loop through...

Sorrythats what i meant. My fault. Its just i pasted it in to the criteria and changed the date (YY) and i get an invalid proceedure call message. Is ther anything else i should be doing?

try this link... http://www.mrexcel.com/board/viewtopic.php?topic=21909&forum=2

Is that to be put in to the criteria field of a query in datasheet view?

you can import data from excel from the import extrernal data found on the file menu. Select import and then on the file type select Excel file. Then follow the steps. It allows you to create a table with all of the data from the excel file - you may have create named ranges first in the excel...

Is it possible to have a query collect data that is One year old or newer. Im sure it would be possible but im not too sure on how to create date criteria. Thanks for reading and for any replies Chris