I am trying to generate the following information and I could really use some
help with it.
I have a Qry called [Qry_Pt Satisfaction Points Counter] and it contains
several fields [B2] [b3] [c2] etc 20 in total. each field is either Null or

I thought someone could help me with this small problem.  I have two
parameters in my make table and one of them is the table name for the
make table.
When I run the query, it filters based on the [DeptNo] fine, but when

I'm trying to set up a parameter query and also have a count of the same
field with parameters.  I keep getting errors.  Basically have employee first
and last name, then on the Gender field [Enter Male or Female] and I also
want to have a total for the gender field but cannot ...

I just took over a DB from the former developer.
I go to "Create query in Design View" or "Create table in Design
View". Do anything or nothing.
I try to close. It prompts me for a Save As, and won't let me close

I am using a form to supply data to a query it has two different IIF
statements embedded the first returns an empty string if a field is left
blank. the second checks a different box on the form to determine whether the
user wants to search for an exact value or a similiar value.

I know this will probably be something simple but it is beyond my
current experience.  I have a table and I want to use a make table
query that will create a calculated field called pageDeltas. The
existing fields are printerID, pollDate, and pageCount.   PageDeltas

Hi, hope someone can help with passing two values from one form to
another by way of a command button.  I have spent a week on various
code taken from this site, but still no luck.  Please ... someone
help!!

I have a query as follows:
SELECT TOP 1 qryVisitData.timeIn
FROM qryVisitData
ORDER BY qryVisitData.timeIn DESC;

i have a calculated field in query like this
amount=[fcamount]*[roe]
is property set to standard and 3 decimals.but actully it is not saving only
3 deci , but saving it full.

Here's a classic:  I have a list of phone numbers, several per customer.  I
want to arrange these phone numbers in multiple columns (titled phone1,
phone2 - just 2 phone cloumns), rather than appear as a list in a single
column.  How can I do this?  It seems a crosstab won't do ...

in query criteria.
this would show the last 2 weeks. if I look at it on the 15th day, it will
show the correct data.
Between Date()-Weekday(Date(),0)+1 And Date()-Weekday(Date(),0)-13

Hi,
I'm hoping for some help in regards to a job which has just landed on my
desk. I have been given an Access database in which there are two tables. A
table which lists documents which exist as electronic versions, and a table

I have a date format of 19850617, I need it to be 06/17/1985.       The
19850617 is in text format and when I run a query to change it, it comes out
as 105 - for everyone.....May I please ask for some help.

I want to add amounts from all records in a query.
For example, each record has a field called "Amount".  I want the sum of all
these amounts.  Can I do this in a query?

Is there a standard way to determine, in a query or set of queries, where
there are 3 fields (customer, date, phone number) what the phone number is
that corresponds to the max date?   Using a single aggregate query, setting
the aggregate function to max for date, phone numbers ...