Accuracy Accountancy at http://www.accuracy-accountancy.com ¦b http://www.accuracy-accountancy.com ªº "ºë½T·|*p" E-Mail : ¹q¶l...

Hi all I have a form with 6 combo boxes.. c1,c2,c3,c4,c5,c6. each consists of 10 items. a sub form is added to display all the required records.. now when a...

Hi Everyone, I’m creating a database that has a table called History. History contains 7 fields; ID, Year, Schedule, Hold, LType, Painted, Approved. The...

I have the following query as the source for a combo and I am getting the above error message. SELECT tble_employee.Employee, tble_employee.Dept FROM...

I'm trying to summarize some vegetation data that involves putting the trees into categories and classes based on their diameter and their "status" (live...

I have a crosstab query and would like to change column heading. The data are "YES" ad "NO" in the table. The PIVOT clause put the "YES" and "NO" on the...

SELECT , FROM Events WHERE ((=(Event Catagory))); The above is what I have in my query builder Events is a fld Datatype autonumber EventName is a fld ...

I need to create a total on a report that sums hours from one day with the previous 7 days for each day of the month. I will also group this by driver, quarter...

I have three fields that I need to total. When i do run the total nothing appears because one of the fields has a 0 value. The expression is not counting 0...

We are using Access 2007. There are several parameters that my db users have to input to "filter" the data that will complete reports for the agency. I have...

I would like to run a query to determine if a datetime field in table1 falls between start date and end date in table2. If so I would then like to assign...

Hi, I am trying to make a change in value for a field in a query which is displayed on a subform. I have tried this: Up: IIf(="Fail","F") I get a circular...

I need to export a query (to excel format) for use in uploading data to a system. That system requires specific column headers on the upload file. One of the...

I have two tables - Barcodes (fields: Barcode, Event, Callsign, Registration, Type, Operator) and Movements (fields: FltDate, Callsign, STA, STD, ATA,...

I have a query that calculates captures a date filed 20 days after the date which is entered. It then gathers all the dates after the 20 days has been...

I have a field for date of service and another field for invoice date. A date range is entered for date of service and I need to allow invoice dates between...

Hi am currently using MS Access 2007 I started off by using a template to create a customer database, the template already contained a text box which you...

I have a form that is filtered using Allen Browne's ajbFindAsUType module (http://allenbrowne.com/AppFindAsUType.html). I want to now create a query that...

Hi all, I have a form with a combo box , listed with 5 items. when each item is selected it will execute a query and result will in spread sheet window like...

Hi all.... Need your help badly.... example.... table t1 fields are name,place, designation,company query q1 select count(designation) from t1; query...