Search results

Im trying to create a report that will require data from several different queries. In the past, i've created a report and then bound the data source to a specific query. Because of the amount of data necessary to create this report from different queries, I figured if I didnt bound the...

Is there something I can replace the start dates with so I dont have to go in every year to replace the starting date criteria? Something to make the year of the start date default to that year?

I am trying to build a query to show year to date case counts over a period of three years. The start date of course being the first day for each year and the ending date or "to date" would be "Date()". I'm not exactly sure how to even start building this in addition; howe do i make "Date()"...

Pat, Thank you very much for the direction. It appears as though you are right as to your suspicion of me putting the criteria in the wrong spot. Rather than breaking it up into the "calculated field" and then setting the criteria, I had it all in the field calculation part. After looking...

That doesnt seem to work either. I would like the query to return all data from two years prior, in this case 2011 without having to manually change the dates every month or year. The "last year" criteria works perfect, but now I need the data for two years ago.

I am trying to create a query to return data from 2 years ago. I found critera to return data for a year ago which is working. I'd figured after some slight manipulation it work work for a two year time frame and well so far no success. I tried Year([caseDate])=Year(Date())-2 The criteria I am...

I am working on a database which will generate a report for data based on week numbers. Everything is going good so far with an exception to one problem I am having. When a year starts or ends in the middle of a week, its throwing the data off for that one week when referencing the week...

I have a button in the main menu that I created that opens a new form for "maintenance" capabilities. I dont want just anyone who uses the database to access this form so I found this code to "secure" a button. Dim PassWord As String PassWord = InputBox("Enter Password") If PassWord =...

I am trying to create a report to show total time and miles to account for miles ridden on a bike. I currently have a report showing the basic part of what im looking for IE: total Miles and time ridden in each record. What i am trying to do is make a calculation to show me how many total...

John, I think you were involved in my initial posting that this was referenced in. I am relatively inexperienced with writing vba which i believe is causing a lot of my own confusion. I had this same issue in another database I built that referenced First Name Last Name and date of birth...

I am trying to figure some things out and thought of something that may solve my problem. I have a table as followed; EmployeeID: PK FirstName MInitial LastName Company:FK Department:FK What I want to do is create a new field that automatically populates based on what is entered into the...

I've got some calculated queries using that combination and work great. Is there a way to do this similarily in a text box within a form?

Well thats cool. Just thought of something that may resolve my issue. If i create a new field in the tblemployee table that combines data from the firstname,MInitial, LastName, and Company ID and then "index" that specific field, it should work. Question is; how do make inforomation enterd...

Just to clarify, you said you have this code in a text field. Is the text box saving to a table? or just referencing the table? In the text box, where are you putting this code?

At this point i'll give anything a try, can you tell me what this code means and what information I need to change to accomodate my table?

I'm having some issues with stopping duplicate entries in a table and have tried a copule different ways with no avail. In one table in particular, I have a table holding employees as followed; EmployeeID: PK FirstName MInitial LastName Company:FK DepartmentFK What I am trying to do is...

While brainstorming this I was thinking it would be more customary to put a rate to a person; thus the post. In this situation, the rate is really going to be based on the company the person works for as they are "contracted" to work on the property. The rates are paid to the contract company on...

Thank you very much for the reccomendations. I've followed your layout with a couple minor changes. IE: I changed "position" to company as the position only applies to one of the associated companies involved in the project i'm doing. Hopefully it makes sence once you see the layout. After...

Im brainstorm some table information and wanted to be sure I understood this fully before I started drafting table settings and relationships. I have an employee table: FirstName LastName Company Position The position option will be based on a separate table which will contain two...

Can someone help me with the best way of setting up a table containing the following date/time fields. StartDate StartTime EndDate EndTime Ultimately I will need to be able to subtract these date/times to get a total time between the two. Should I combine the start date and times in one...