Sorry if this is a duplicate, but I tried lots of searches here. I can't seem to find my answer anywhere. I have 2 tables that I need to join by date and...

I get incorrect results when I do the following query: Field a = "X" Field b = Not "Y or Not "Z" Field c = Between and

I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a “purchased system� table that has many field...

I get a weird error message when I try to run a make table query, but yet the same query will work as a select query. I know the file isn't currupt, as I've...

Now that my former post has gone through, when I am in other newsgroups using Outlook Express, I can view all ngs I visit. But I can't post in ANY of...

I am having trouble constructing an Update query using Lpad. I keep getting an "unidentified function 'Lpad'" error message. The same happens in Query.

I have set up a query to add up some data. I used the wizard to set it up, I set the fields I wanted added, then it asked how I wanted my dates handled and I...

You got the Left Join wrong way around. The way you have at the moment, the Query will show Records in tblPersonnel that don't have related Records...

Maybe it's a typo but Value2 is missing a leading double quote. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "John"...

Free Live Voice and Video Chat!Connect with Over 4 Million Members download now on http://www.tkqlhce.com/click-3714215-10516597

I am trying to develop a report where in the PartNum footer the average number of days between orders is calculated. I have created the...

I have a query which contains some memo fields. I am using Office links to transfer the data to Excel. There are about 500 characters in some of the memo...

Updating this question with a...

"fredg" wrote in message ... On Sat, 22 May 2004 10:59:00 -0400, C & J Jones...

Hi, I'm trying to pass multiple query criteria from form controls. I'm using the following type of syntax for the criteria: Like Nz(!!,"*") And this works...

Hi - I'm creating a parameter query that will ultimately have approx 6 parameter prompts. The user may only know the answers to 1 or 2 of the prompts. How can...

Hello World, I am writing an update query that changes a column value for a group of records based on the maximum value of another column. The query...

I need some help. I have 5 check boxes. There is one for each country of Canada UK USA France Germany And i want the users to be able to tick which countries...

I am trying to create a form for a union query that allows me to edit the data in either of the tables used for the query, but I can't understand why with...

I was wondering how this would be done. Currently I have a database set up tracking employees and all kinds of training, disciplinary, errors, etc. They are...