Hi Experts, Back again. I have a query that refuses to proceed when there is an ' in a text field it needs to process. Any help or guidance to resolve this...

I found a common workaround for the lack of additem in Access 97 and 2000. Tablebox is the combo box I'm populating. Fields are a little harder. You have to...

I've done a query which gave me sums of quantities for different items. Now how do I get a grand total for all the sums, in the same query?

I hope I can explain this with my limited english. I´m trying to create a stock list. So far I have 3 sum queries. One to calculate purchased items, one to...

I am a little confused by the 'first of' and 'last of' options when using the totals in queries (despite having done a search in this group and reading the...

I am creating an online database for our school employees to be able to enter their walking miles every week. I'm doing this using a web page, form, and then...

I have a table named tblPerfArtsCamps as follows: PerfArtsCampsID AutoNumber CampDate Date/time Season Text ********* I have a query based on...

ok I've seen tons of answers to this question but none of them really work for my purpose, or I just simply don't understand. Here's what I'm trying to do: I...

Hi I'm using DateDiff() in an expression in a query which works well until I try to use the SQL as the source of a report. (I'm using Access 2K) I get an...

I would like to calculate a monthly average by Customer ID in a query by using the Expression Builder and without having to resort to SQL. Here are my...

Hi, I'm having a problem with an update query. In one case the query reports it will update 56 records but on inspection only updated 8. Changing it to...

I'm running MS SQL 6.5 as backend to Access 2002 program. To enlarge a field in my SQL table, I added a field with the same name plus "BIG", transferred the...

I have an update query that was working great until there needed to be a change made. Previously, I was told to gather the most current score by...

I made a 'Delete' query. It works fine. My issue is that every time I run it, it prompts me telling me it is about to delete X amount of rows. I am confient...

Apologies for this somewhat basic query, but I'd be grateful if someone could help. I am creating a database in Access 2000 with two related tables, one with...

Using VB6, we have numerous tables that have codes and their related descriptions. We would like to load them into separate combo boxes for each table. ...

In the table (not the form) I am trying to get a value a user selects from another field to append to my SQL statement so it will read from teh correct...

Hi, I have a table where I keep track of volunteer titles. It simply has three fields, Person, Job Title and Activity Name. The Person field is tied back to...

Does anyone know how I could find all the values in one table that are not in another? I have a table named login; the fields are ID, first_name,...

I'm trying to use an expression as the criteria in a query field and I can't understand why I'm getting a data type mismatch. The field is a text field. The...