i am wanting to be able to pull multiple records based on a store number.  i
have 6 stores each with a different number. I can currently pull the
information based on a beginning and ending date,  which i want to continue
doing but right now i can only request the info per one ...

Hi, I'm just trying to create a simple search field for every field that I
have in a lengthy table. I have created these search fields in a Query and it
produces output records only if the complete data in one of the cells is
input in the criteria. I can't get any outputs if I ...

I have a right join in a query. When there isn't any join on the right side I
want a zero placed in the column. I am using Access 2003. I have tried the
following:
In one column I have

I have a 9 in the front of phone numbers that I need to remove in order to do
a comparison query.

Does anyone know how to convert a foxpro database to an access
database complete with the forms and other objects in the foxpro
database?

I have a report which is based on a table called tblStreetSweeping and
has the fields (Date, TicketNo, Type & Weight). Each finacial year
runs from April to March, the data in the table ranges from April 2006
to July 2007, in my query I have the formula SortMthNum:

I have a table that changes daily and contains 2 fields: ID(unique
value), Score(with a range of 20 to 200)
I want to be able to choose the maximum number of records that will
always have an average score of 45.

Hi--I am trying to figure out how to give a raise to a select number of
people in my query.  I have it set up by social security number and wage
rate, what I am having problems with is the people are not getting the same
amount of raise and I cannot make it work so only the right ...

I have about 5 tables that I cannot enforce referential integrity
on... 3 of them have a common field, but the error messages I am
receiving are way above my head technically.  Any suggestions?  Or
even documentation on relationships (from the very beginning) would

My colleague told me that there's a function in sccess that can accomplish
this.
I need to check every month's report against the last. As I don't want to
waste time checking those entries that were checked previously, I want to run

This is probably not very hard but I am very new to access and am trying to
build an entire database.
I am making a query from a table and I need to pull out records that are
done in April in the Month field but I want it to leave out the records that

can someone please help me with this IIF Function in a Query.  I want
to write an IIF statement that only performs an action if the truepart
= true.  If the truepart = false then I want the statement to perform
no action.  is this possible using iif statement.  If it is not then

I'm trying to add the numbers from two different text boxes together
in a third text box. Pretty straightforward, right? Well, instead of
getting the sum of the two numbers, Access is putting the number from
the first text box next to the number from the second text box like

I am trying (in vane) to get a basic db function.  Search for a record and
allow the user to update it once it is found.
I do not want to use the basic Filter By Form feature as there are too many
records in the drop downs to make this practical.

  I am trying to create a query that shows a person's ID number if they did
not check a service date box.  The table has a 32 fields total - 1 person's
id and the other 31 are 1 per service date.  What I am trying to do is creat
the query so it displays the person's ID number if ...