Queries
in [Access]
|
Storing time as integers I have a call database that includes a field for length of call. I have created a query that includes employee, date, and length of call. I need to calculate the average call length per employee and as a whole. I found one post that suggested the following: "To store time intervals you should store them as inte... 4 Jun 2010 11:28
querying unrelated tables I have two tables - Employee_PunchTime table and Holidays Table. The PunchTime table contains three fields representing EmployeeID, Time-in and Time-out; and the Holiday table contains two fields representing name of holiday and the date. If the payroll period is 5/31/2010 (Mon) thru 6/4/2010 (Fri) and 5/31... 4 Jun 2010 14:47
Default Dates I have a query that calculates records between two dates as Between [Beginning Date] And [Ending Date] Is there a way to show a default value for the beginning and ending dates in the input boxes rather than having to enter a date every time? Thank you for any help Paul. ... 3 Jun 2010 14:33
How can I query a set of dates but exclude non-working days? Hi there, I was hoping that someone might be able to help me. My Access knowledge is at best, rather limited, and I am stuck now and cannot proceed further without help! I am building a database of records for work received on certain dates, and completed by certain dates. I need to be able to to query which ... 3 Jun 2010 11:10
Multiple Queries to Multiple Reports I have a database that tracks cadets that will commission into the military and they are broken into their year groups. My problem is that to generate a report for each year group I need a seperate query for each year group so I have multiple reports and multiple queries in my database. I'm trying to figure... 3 Jun 2010 11:10
Changing constants in a query to user input values Access 2007 I have a table that contains (among other things) Start Date TimeDown End Date TimeUp All of these are Date/Time type Example data: Start Date TimeDown End Date TimeUp 16/3/10 02:00 16/3/10 04:00 16/3/10 06:00 ... 4 Jun 2010 01:38
2007 Concatenation problems I am using Mr. Hookums formula he gave me for concatenation in Access 2003 and it works fine. As soon as I copy it into 2007 I get error messages. I have tried converting the database to 2007, but get errors. I created 2007 database and imported all files from 2003. Switchboard and concatenation no longer w... 3 Jun 2010 08:57
Delete Query not Working I have tried to follow many of the suggestions in other posts, but have not been able to get this to work. I have a table called DailyCalls and another table called PersonalCalls. A query was set up to return calls in the DailyCalls table that match calls in the PersonalCalls table. When I change the query to ... 7 Jun 2010 09:40
Last record/entry from a table My table has three columns, AcctNum, TransDate, SeqNum I need a query that only displays the last "SeqNum" when an "AcctNum" had multiple entries on the same day. For example, my table has the following data: AcctNum TransDate SeqNum 1234 6/2/10 698 1234 6/2/10 701 1234 6/2/10 ... 2 Jun 2010 12:03
Calculated field question I have a query that summarises sales data for a particular month and cost centre. The data comes from our accounting system and is held in a single table in my database thus: tblNominal ------------ CostCode - Long Integer ExpenseCode - Long Integer Desc - Text Current - Double YTD - Doube Month - Text ... 3 Jun 2010 07:51 |