How do you refresh data on pivot table form in Access:
According to access help:
"Each time you open a PivotTable form, the PivotTable form shows you the data
that was current the last time you activated the PivotTable form. To display

I feel a little silly, but I'm just going to come out straight and say
it: I play Dungeons & Dragons and I thought that it might be fun to
try and build a character sheet database at home so that I could play
around with some of the program's features and learn more about

My query is not giving me the right information.  What I'm trying to
get is a list of Club Members that have Remote Access.  I thought it
was accurate, but several records are missing.  I'm sorry this is
probably something super easy...

Okay, I feel a little silly telling you guys this, but I'm just going
to come out and say it: I play Dungeons and Dragons, and since I'm
still learning how to use Microsoft Access, I thought that it might be
fun to try and build a character sheet database at home so that I

Hi I am looking for a query that I can use to total al calls which came in on
the 1st or 2nd week of a group of Months.
example
Total calls:1000

Appreciate your help!!

We have some users that we have directed to only get their information
from a report that has been set up.  Because of that, I set up a
parameter query to make the information more easy to see.
The parameter query prompts for last name or broker #,  is there a

Okay, I feel a little silly telling you guys this, but I'm just going
to come out and say it: I play Dungeons and Dragons, and since I'm
still learning how to use Microsoft Access, I thought that it might be
fun to try and build a character sheet database at home so that I

Hello...I am using a parameter query to check if patients received or did not
receive an injection during the rate range (Start-End Date) specified. The
following code (see below) is working successfully for patients who did
receive an injection during the date range. But I would ...

HELP! I am going crazy trying to solve this one.  I have a query, lets call
it Query1 with the following three fields, Id (an ID#), Run (a Run#) and
Result (a test result that is either a 0 or 1).  I need help creating the
programming to create the fourth field, the RunningSum ...

This is probably a very simple question and I'm sorry but I can't figure it
out. I have a query with a field named "priority" and in the "sort" line of
"priority" I have it set to ascending. I have done this before and it works
find but now when I run the query it goes in the ...

I use MS Access occasionally but have coded in QMF.  I have a MS passthru
query noted below.  I want to require the user to enter the dates.  I found
the commands [enter date] but am unsuccessful using this in my sql query.  
Are there other commands that will prompt the user to ...

I have a union query that runs without error however, once it completes
running no results are displayed on the screen. If I copy out each subquery
in the union query and run it the results screen appears. THere are some
subqueries that return null datasets none ever error out. ...

All tables are linked with weak entities. However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.
It wont work and i have no idea what to do at this ...

If someone can help me that would be great.
First problem:
I have a table basically contains time spend on various projects so most of
the entires are the same besides time and date and name. Is there a way to