I have a Macro to be run through clicking the Command Button: openQuery.
The TableQuery is to download the data from an ODBC-table in my remote
office Mainframe computer.  At times the link is broken due to the connection
or whatever reasons, in other words the query is not ...

I've build query in access that bound for more then one table.
If i delete record from the query. it it not only delete the master query
but all the related tables.
This thing is catasfrofy. is there a way to keep the joins in the query and

I am trying to run a query based on the values in text boxes on a form
(Advanced_Search).
I have worked out the following embedded if statement to use as the
criteria:

Hey everyone,
I have a query displaying total customers within specific sectors using the
groupby and sum arguments. The only issue being it doesn't display sectors
with 0 customers at all (i would like it to list them with 0 total). I just

I am having a problem getting a query to pull correctly.  I have a table that
has: Associate Name, Date, Function, Subfunction, Incoming, Processed, and
Holdover.  I want the query to ask for the Associate name and date.
I have gotten the query to ask for the dates (using a ...

I am making a table with counts of a certain class, for ex.:
Count  Class
2         1
3         2

HI...
Can anybody solve this problem..?
One small problem...
In the following query, i should get only Non-Zero balance in the

This might not be the right group to post to if its not could someone get
me in the right direction. I would like to be able to use excel to Insert
new data
into an existing access table or Import the new data to an existing access

Hi. I have a table that is relationed with some other tables. I made this
links with relationships.
I'm having this problem. I wnat to manage issues. Well there's a main table
with the issue name and number. And there's other tree tables, one for dept.

I have the fields LastName and FirstName in a datatable.
I need to combine this information into the format "LastName, FirstName*".
Can anyone help me do this?
Thanks!

I am trying to build an expression for this query. I need a query that will
display [Corrected_Reason] unless [Corrected_Reason] is "REASON CORRECT" Then
give me [Reason]. Here is what I have so far:
IIf("REASON CORRECT[Corrected_Reason]",[Reason],[Corrected_Reason])

    I am facing problem of sorting text field, cause it contains
numeric values in place of text.And now i cannot change my datatype
from text to number.
Exp.

I want to get input for query criteria.  Here's the code I'll use to get the
input:
   Dim BegD As Date, EndD As Date, Inv As String
   BegD = InputBox("Enter beginning date", , "010105") 'Date)

I have a table that lists products sold by date. I want to display how many
of each product were purchased. I wrote the following query:
SELECT First(Productid) AS [Productid], Count(Productid]) AS [Number
Purchased]

I have a project that I am not sure how to do...
I have a list of 5000 names and I need to create lists of 10 names for each
list.
I have not created a table yet, so I can do whatever I need.  Once the lists