Hello All I have a large-ish table (~80,000 records, 25 fields) which includes the fields 'employee' (text), 'mthnumber' (integer) and 'nicode' (text). Most...

Hi! I have searched through the postings on this site but can't seem to find a solution - so hence this post. I have a table where there is a field with...

I need this to run overnight every night. When I simply open this select query, I get a 14 field query with about 80 rows of data. Access 2003.

Is there a way to create a query based on one table that totals fields (without using the grouping) and also allows new records to be added when it's used to...

The database I have tracks work orders that have been complete. Once we verify with the customer the issue is resolved, using a form we change the value of...

I am a novice to Access : is it possible to sort a database of education establishments by creating a query that will find only schools containing the text...

Hello, I created this db in MS ACCESS 2003 and recently our office upgraded to MS ACCESS 2007. Everything was working fine, until a User noticed that after...

I'm trying to set up a form to allow the user to exclude certain transactions if they enter the transaction code to exclude, but if they leave the field...

I need help in creating a query that will find all unmatched records in a table. I have two tables: The first table T1 has just has a record number The...

Hi, I'm sorry if this is very basic but I haven't had much sleep lately. I have three tables: Machines Processes Process Instances Machines is a listing of...

Hello, I want to display Column 1 of my Combo box in a Query. Query----- Error @ !! SELECT DISTINCT tbl_FC_ImportData_2a.AssetID,...

I have two tables, Demoraphics1 and Demographics2. In Demographics1 I have a lot of different data of which ID and Age are two sets. Demographics2 contains...

I need to select all records where the date is more than 3 years old. I've tried "5/1/06" and "Before 5/1/06" and neither seemed to work. Please help. ...

Hey everyone, I have read TONS of questions on this issue but I can not seem to cut through them to find the one I need. I am sure its out there, so I am...

Hi This query, which is basically returning a record set of names NOT in another query is taking 15-30 seconds to run. Is my structure making it so...

Hi, Hopefully someone knows this: I have a table in Access that looks like this: ...

I have a table with Locations listed. When an order comes into the database it is qualified by the Location table. The location, along with corresponding...

Need a little help here. I have a table that collects information on Referrals made to each Contractor from each Worker. I need a query to return results...

Hi, I am developing an Access Database in 2003 for timesheets. I have a form that a user can enter the employee number and the dates they want to look up....

I want to run a query that will display ALL records with ANY null fields. For example, on addresses, if a state or zip is missing in one record, and the...