Hi, I've created a form from a query.  When a button is pressed, a question
is run regarding the check box field, being 'Is the student enrolled - 'yes'
or 'no' , the user should enter 'yes' or 'no' (without the commas' to run the
query with the correct information chosen, ...

I need to return a value as a nearest multiple of 0.25. - similar to Ceiling
Function in Excel.Any ides how do I go about it?
thanks
Barb

I am trying to reference a column in the same query (DateCalc2) for purposes
of grouping.  When I run the query, I get a message: that MS Access can't
find the name of the column in my expression.  I have read that referencing
of this sort is not the best way to go but cannot ...

I have a survey that has 20 questions.  The records have survey IDs.  The
problem is i need to count the preferred responses in each field, then
determine the percent of preferred responses, and convert that to a readable
percentage (*100 then isolate using Left 4 characters.)  ...

Instead of using an INI file or other means of containing application
variables I have
created a appvariables table in Access 2000.
The table will only contains 1 record with 1 or more fields.

I need to create an IIF statement in a query that will check an item on a
form and if that item is a certian value select only that value but if it is
any other value select all values. I have tried the following:
IIf([Forms]![zfrm_SwitchboardSplitSkill]![cbo_ServiceDesk]="CBO ...

I have many products, each which can appear in multiple catalogs.  I want to
show the product numbers down the left side and then show each catalog that
the product appears in all in one row.  It should look similar to this:
Product    Catalog Prefixes

Not sure if I am doing this correctly or not.  I have a form that has
several combo boxes on it that allow a user to pick a name from a list.  I
need to have the next combo box be requeried and not include the selection
from the first box.  This has to continue until four boxes ...

Lets say my table has fields 'text name', 'text class', 'check box enrolled'
When I create a query with 'criteria' in the check box section stating 'is
not null' this works fine, I get my answser, when I use 'is null' I get
nothing

I am trying to calculate the number of days, excluding weekends, between two
dates.  I am using the "workingdays" VBA code.  I have pasted the code in a
module, naming it "mdlWorkingdays".  The code is listed below along with a
sample of the data.

i have a combo box on my form which allows me to select data and add to my
list box and works well. now i want to add data from a different table to the
same list box? help please

I have some raw Excel data in the format:
2170696969
2021965
2023241

I have one table and I want to bring a count based on the section and
subsection.  So basically I want to know for each dealer if a technician
called about the same section and subsection which I have combined the fields
in the query, how many calls were there.  It is working for ...

Please bare with me as I am somewhat new to Access. I am trying to set up an
IIf expression in a query and it is not returning any results. I am trying to
calculate the amount of overtime for my department. The overtime is based on
the amount of open items that are more than 20 ...

I am trying to use an update query to change a field to a concatenated field
using the criteria below.  In a select query, it works fine but in the updae
query, it cuts off at the first space in the field.  
any suggestions?