Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

how can i do a month search, by entering in a month throug..

 
   Database Help (Home) -> MS Access -> Tables DB Design RSS
Next:  Misplaced authenticity code. Is there any way to ..  
Author Message
Heavenly Hash

External


Since: Feb 21, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 21, 2005 8:37 am
Post subject: how can i do a month search, by entering in a month through
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

I'm creatinh a database that stores the leave of the employees and i want to
create a month/date search, where the user can input a month/date and it will
bring up , all of the employees who are on leave for that month/date.....

Thank You in advance

 >> Stay informed about: how can i do a month search, by entering in a month throug.. 
Back to top
Login to vote
Duane Hookom2

External


Since: Mar 18, 2004
Posts: 9



(Msg. 2) Posted: Mon Feb 21, 2005 12:31 pm
Post subject: Re: how can i do a month search, by entering in a month thro [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

What is a "month/date"?
Do you have a table structure that you could share with us? How about some
sample records?

--
Duane Hookom
MS Access MVP
--

"Heavenly Hash" wrote in message

 > I'm creatinh a database that stores the leave of the employees and i want
 > to
 > create a month/date search, where the user can input a month/date and it
 > will
 > bring up , all of the employees who are on leave for that month/date.....
 >
 > Thank You in advance

 >> Stay informed about: how can i do a month search, by entering in a month throug.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Day, week, and month totals - I need to create a Database that will allow me to create a report of the data by day, week, and month on one sheet. Each day has only one record, but there are multiple fields in each record. Along the top of the report would have to be a list of..

Where to store the Fiscal (Tax) Month & Year data - I'm making an Income and Expenses database where the transaction (income or expenditure) dates need to be sorted by the Fiscal (financial) Year and month ie the Fiscal Year starts on the 6th of April and ends of the 5th of April in the next year so 6..

Multiple users entering data - I would like to build an Access database for multiple users to enter and retrieve data. The database will be on a shared drive, but does Access support multiple users possibly entering data at the same time? I’ve built one for a smaller group (2-3...

Error - "Search key was not found..." - I'm getting a strange error in one particular record. Somehow, a duplicate record was created, and I cannot delete the record. I get the message "The search key was not found in any record." It's an error 3709. What might be my issue? Thank...

Search in multiple databases/tables - I have three databases with the same structure, table and field names (data tables are not linked, but can be), I need to be able to search all three databases for document number. THe user would like a drop down of all documents from all 3 databases...
   Database Help (Home) -> MS Access -> Tables DB Design All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]