Apologies if this is an obvious question, but I can't find any suitable query function or operator. I have a series of tables with RI enforced foreign keys....

Hi, I'm new to Access so be gentle with me ;-) I'm currently doing a project where I need to count the number of cities (in a 'City' field) which meet...

Hi, I'm new to Access so be gentle with me ;-) I'm currently doing a project where I need to count the number of cities (in a 'City' field) which meet...

Hi everyone Hope someone can help with this one.. Background: I work in vehicle fleet, I have built something to 'predict' when a car/van service is due...

ACCESS 2007 query Two months ago, I created a small database (20MB), consisting of two tables - '34rows x 5columns' and '353rows x 6columns', I have now...

I have searched this discussion group to no avail. I am trying to bring data from two different tables together to produce a report. The first table is my...

Hi I have a form with a list box and a sub form. The list box is bound to a query. The query uses a field from the sub form in its selection criteria. The...

After running the "find duplicates" query, it returns all the duplicates in my table. How can I then delete one of each duplicate without manually deleting? ...

I have a form with a command button which searches for a specific value in a table. When the dialog is opened the initial default for the 'Match' drop down...

Hi I would like to set the default of the 'Find' Dialog to 'Match any part of field' Is that possible and how? Thank you, Samuel

Just how does this -FIRST- aggregate formula work? Example ProID Name Address City State Zip ==== ==== ===== === ===...

What is the SQL sytax for doing a full outer join (all rows from both tables)? Thanks, DOTJake

I have a local table of twelve (12) records. These are utility rates, which include the date they became effective. Two (2) of these rates (flagged) have...

I'm getting 'Invalid argument' error trying to save this query. User claims it ran fine until last Friday. Can anyone see a problem with the syntax? How do...

In Access 2003, I'm trying to write a query using the Query Designer/SQL window. Basically, I'm trying to execute a query with "LIKE" in it, with a prompted...

I have two tables and each table has a field called 'firstname' and have text values in them. I want field in another table or query that displays 'firstname'...

I have a database set up which tracks the recruitment and selection process. I have been asked to change the way in which the vacancies are...

I have areally bizarre one here... I have a Referential 1-many link in a DB between primary and foreign ID keys. Standard stuff. But in a query using this,...

Can someone explain why this query wont run? I get 'Must be updatable query'. I clicked on Help but nothing made sense. UPDATE tblActivityQuestions SET...

Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now,...