I'm trying to run a querie using 2 tables. One table has faculty names including their budget amount. The second table has expenditures the faculty have...

When a new query is created and ENTER is pressed the result displays. Soon after a pause and the programme shuts down, reopens and has made a backup copy of...

I must filter out in my query all Clients who have animals or return all Clients depending on whether the Visitors form shows either Yes or No in the fear of...

I have a query to run summary of projects. The criteria of the query would be the project name. However in some cases, instead of showing just one of the...

My query uses a function (fclinetID) in the clientID criteria. Sometimes I want to run this query for all clientID records (not null records). Is there a way...

I've been learning Access andhave been pretty successful with it for the last two months, using a lot of its capabilities. Now I need to do something and I...

have the following programme.module for generating all possiible combination of in a group of 3 items and it works like this Private Sub Command1_Click()...

Hello - I have created a simple database with a query that is getting its parameters passed to it from a form I made. The issue I am having...

I am trying to produce a stock report from a 1) Product table (ProductID) 2) Inventory table (productID & Prorec) 3) Order detail table (productID &...

OK, there is probably a simple answer to my question: I have 2 tables with some of the fields being the same. I am trying to make a query that includes ALL...

Can someone help? Access 2000 I need all records from CarPart Table and only matching records using CarPartID (Primary Key) from Parts, if there are no...

I am getting exact matches to the List_Table using the IN statement, but... Consider a customer is inputting a "where did you hear about us" answer in to a...

I have specified two parameter values for entry when opening a report. One is a name and you can choose it from a combo in form, the other is a pop-up...

I have specified two parameter values for entry when opening a report. One is a name and you can choose it from a combo in form, the other is a pop-up...

I just want to write out a query that returns all records (from a single table)where a particular field contains more than 100 characters. Can someone please...

I just want to create a query that returns all records (from a single table)where a particular field contains more than 100 characters. Can someone please...

Hello. I am using Access 2000 and I was wondering how to write a query on a date field to find all records within the last 30 days. I tried Date()-30 and it...

I have a database of names of people and when that person checks in for a service their name is scanned in and the date and time is automatically assigned...

Should all of my tables (except for Lookup Tables) be stored as queries?

I made a query which among others have two fields that are contained in a table. One is 'Amount' the other is 'STax'. Now i want to get the total of both the...