Okay, so i have been learning very slowly the dos and dont's of access.  But
when I try to make a query (perameter or simple) it is not coming up with the
info that I need.  
I have a column in my table that I list which community a person lives in.  

I have a form where you can enter new product names and it is stored in
table1.  I then have a query that combines the productname from table1,
product category from table2 and then the retailprice and wholesale price
from table3.  However, because the new productname is stored ...

The following is an if-function i am trying to get working but it doesnt
accept it and shows me if the cell [7_Evaluaciones_Auditoriias_cuentas]![11]
equals to 5 it gives in the cell for 'Índice máximo 1' an #Error-message
(instead of doing the calculation of 5*10) and if i put ...

I  pulled data from 4 different tables. This data now needs to be sorted into
months using the Receipt Date if it has one. If there is no Receipt Date,
then we will use the PO Date. If there is no PO Due Date, then we will use
the PR Due Date. If there is no PR Due Date, then we ...

I am trying to replace the first six numbers of a Social Security NUmber with
Stars and display only the last four digits in Microsoft Access.  I would
like to be able to do this in a table and a query.

I created a form to display record details based on a table and then also
based on the results of a query I use to specify which records I want to
see.  The problem is that whenever I open the form based on the query, when
the record is displayed I cannot then go back and edit ...

I am using subqueries in my reports and I am looking for a way to pass one
parameter entry to the other fields without having to type in the same entry
2 or 3 times to get my results. I need the user to type in a PO Number but
Access request it 3 times because I am using that ...

I have a Lookup Table that has 2 text fields - Code and DeptName.  There are
100 entries in the table like - Code = "001", DeptName = "Accounting", etc.
In the Main table there are 10 fields called Code1, Code2, ...Code10.  Each
of these has a 3 digit entry like "001", "002", etc ...

Hi, Please help...
I am trying to build a query to look at an exception of jobs planned.
I have a table of No Entry visits, Job Num, Visit Date ( this talbe can
have a multiple number of visits) my second table looks at the appiontments

I have a Form with a combo box on it.  That control is used in the criteria
of a Query which feeds a report.  When a user selects an item in the combo
box it passes it to the Query and everythign is fine.  The syntax I used is
[Forms]![frmCriteriaForTakenNotTakenRpt]![cboCoSA].

I need to run a quick check on a table which will tell me the most
characters used in each field.
I can use
SELECT Max(Len(myfieldname)) as fieldnameMaxLen,

I have 7 CheckBoxes for days of week:
1. SUN
2. MON
3. TUE...

I'm so bad at trying to get an unmatched query to work.  This is what I am
trying to do.  Ii have a table that holds all reports that are received on a
given day(tblAMURptsCheck).  I have another table that holds all the reports
that are received in the department on any given ...

How do i check against each value of a list box !!!!
I have a list box whose row source is modified based on entry in
another field "IDNO". The list box has two columns "DESC" and "MAXNO" .
I want to check (the checking procedure may be initialised by a command

I have a problem with recordset/SQL statement.  The following is the code.
Private Sub Command1_Click()
Dim SqlQuery As String
Dim RcdSet As Recordset