I have a timesheet, with 2 fields, date/time format,medium date format, called PayperiodFrom, and PayperiodTo. I also have a field called DateWorked, and...

table A carrier price year op 3333 2009 ot 233 2009 op 1200 2008 op1 1400 ...

I have a table containing (amongst other things) a person id, a date and a score (an integer value from -4 to +4). First I want to total the score for each...

I am running a monthly report to summarize the inventory & commodity spend for our department. The way the chick prior created the queries is rather...

I am using the following which works. i simply do noot know where to subtract a person's lunch in the calculation. The field is called 'lunchTime" and is...

Dear all, kindly solve my problem I have created a table d1. d1 fields, Id, date ,r1,r2 r1,r2 are numeric values only. I want to get a result which will...

dear all, kindly help me in 2 problems i have created 2 tables, d1, d2. d1 fiels, id, date ,r1,r2 r1,r2 are numeric values only. d2 fields id, x1,x2 ...

This running sum formula works fine with a query: RunTotal: Format(DSum("","","=" & & ""),"$0,000.00") I'm unclear where to Add criteria so it only runs a...

I need to get annual census of the patients taken care of at a center. The table of patient has date of admission and date of discharge. In the query based...

So all my files and apps were in server A ... I.T.. moved them to server B and now my applications do not work because the path is looking for server A ... How...

Access 2007 I am getting a "Specify the table containing the records you want to delete" error when trying to delete rows in a linked table containing an...

Question 1 (the most important of the 3 related questions) I have a date of birth field(DOB) and I want to get the age in current years and months to display...

I am using Access 2007 in Access 2002 - 2003 file format. When I run an append query from a table with 129 records, to a table with 0 records. I get the...

I am querying from tables from another program.. When a user of the program adds an item, then deletes it, the programs writes to the table like this: Item...

I'm trying to write a formula in a query to determine an expiration date. Expiration rule is: 18 months not to exceed a calendar year. When is the due date?...

Hi, Here is my situation. I have 3 database files stored in a folder. There are queries that make table, append between database. (ie. Click make table in...

I am querying the production database against a spreadsheet of updates and looking for mismatches on one column. The format of the query is as...

I have two tables linked by INV_NUM. Where there is an invoice in each table, I want to delete that entry from table1...sounds simple enought. I drag in each...

Using Access 2003, i have several tables, each table has 3 common fileds, "ID", "Description" and "ActionDate" amonst other fields. im trying to build a qry...

I have sorted values in Access Query, the sorted query contains more than 150 records, how can i get top30 records only? many thanks!