I am having trouble figuring what is wrong with this query - I'm not very good at queries. I have a parts and supplies table and each item has a minimum and...

Okay, I have a query that works perfect. I have two tables, one for changes and one for markups. The expressions added will multiply the value of the change...

Hi I'm having trouble with the following sql query. Any ideas? SELECT * FROM SALES WHERE ACCOUNT = "O'NEILL" The error is: syntax error: invalid filter in...

I have a query with several fields and want to use 3 or more criteria to make it easier for the customer to find something. The fields I want to use criteria...

I am having a problem appending some data from a table in a remote db to a table in the local db. My code is: Private Sub pvtRefreshSubDepts() Dim...

Good evening (at least here in South Africa) - could somebody please assist with the structure for update queries. I am trying to accumulate two totals in a...

I have worked in Excel for years but now find that I need to perform a query in Access because of database size limitations where the total lines exceed the...

Hi all, I'm trying to extract information in an Access table into another table which shows information in a tabular format. For example the table I...

You sent me this code: Public Function GetLetters(strBookCode As String) As String Dim lngCtr As Long Const conAlphabet As String =...

I am generating a query on a database and one of the fields has either a 1 or zero which represent a Yes, or No to the application that uses the database. In...

I have a single table database (access 2003) with client survey info. Many of the questions are simple yes/no answers. I used the lookup wizard to create...

I have a field which has a description of a file - I need to be able to "query" this field - I've searched all types of parameters, but logical or...

Hi, I have a table contain like: Clientid Productid 000001 10 000001 11 000001 12 000002 ...

I'm using the following criteria in my query: =DateAdd("d",-60,Date()) ....basically returns a date 60 days before today. Really I want it to return the...

Hi, I have a database to print labels and all is well with that as long as I want to print all the labels. A page of labels is 4 wide and 10 down the page....

I'm trying to build an expression that will allow me to do a Total the Amounts for APPROVED and DECLINED records in the Status field. Anyone know how to do...

I have a query that pulls up data from tables (i.e. missing orders, aged po's etc), and I added 3 fields into the query to calculated points for each...

I have 3 text boxes that I want to be able to use for searching. srcID scrCustomer srcAddress I have a list box below these text boxes that I want to...

So here's a new one.... A client's internal auditors is looking for a list of all queries in a db and their SQL statements. The weird thing is that if I...

Hi all, I'm trying to create a transform query with VB6, ADO 2.8 and Access 2003. I'm basically doing the following: 'Create catalog connection Set...