The table looks like...

Hello, I have a form with a list of items for a shopping list. I have check boxes next to them that add them to the shopping list when selected. Is there a...

Here's my setup. I have 3 tables--Child, Adult and Track. Adult has a 1-to-many relationship with Child. Child has a 1-to-many with Track. I am filtering...

I have an Access 2003 database running multiple queries that was written on XP, where it works perfect. I recently installed Office 2003 under Vista. One...

Hello, MS ACCESS 2003 on XP Pro I have a query that looks at a table and finds the records corresponding to a value stored in a text box on a form. Here is...

I have a table (tblTransactions) set up in a one-to-many relationship with another table (tblHistory). tblHistory has the following fields: LinkField (text...

I have the following simple query with the criteria that one field does not equal another field. The main table has 20,644 records and I should be getting...

Hello, I have created a database that will be used as a time tracking function. I have it set up so that people will click a button to clock in, which...

Hello, I'm having difficulty writing a query and was hoping someone could help me out. I have a table 'orders' which contains numerous fields, of which 3...

I have a table that has a numeric column "sales" that ranges from 1 to 1,000,000. In a query, I am attempting to assign a banding marker to each record. I...

First some background, I have two tables called 2007 Grid and 2008 Grid, in these tables I have a field called Census Rec'd. For my query, I need to create...

I created a table that will allow the user to assign similar items to the currently viewed item. It works almost as planned. For example: If a user adds a...

I have a column that is for Page Numbers, and this particular table contains a letter in addition to the page number. Here are examples: 1A 3A 10A 1B 13B I...

Here is part of my query (a column from the query builder window).. ChildsLocation: (SELECT "(" & IIf( Like "Resident*",IIf(IsNull(),,),) & ")" FROM...

I'm trying to execute an append query (qapdCopy&PasteProperties) with visual basic, but I get an error. Run-time error '' Syntex error in INSERT INTO...

Hello, I'm joining two table in a query. One field is text, and the other is a memo field. It won't let me run the query. How can I get around...

Hi Everyone, I want to be prompt to give a value for the Sum of CounOfX. For example query should ask me to give a value and show me only the group sums...

hi there, I have a TRANSFORM query TRANSFORM Sum(.) AS SumOfaantbest SELECT ., Sum(.) AS Totaal FROM dbo_SalesQuery WHERE ((. Like "%124507%" Or . Like...

Please help me to write an append query that will append records from one table to multiple tables that have an inner join operation Thank you

I want to change the value in a txt box (or combo box) & then after update, populate a tree list control based on the value. It gets hung up when the...