I have a query that pulls in records based on criteria a user inputs into a
form that looks up data in another table.  Basically they type a list of
countries and it pulls in support details.  In the query results I've listed
all the columns; however, I'm going to be creating a ...

I am trying to set up a crosstabs query with a parameter query to return
information based on recored between certain dates.  I have tried the
following syntax in the Criteria section of the date field:
Between [enter start date] And [enter end date]

I'm trying to do an append query where I add records to my "Services"
table where "Option1" (in this case bound to a checkbox on a form)
from my Guest table is "true".  I will be adding the following fields
to my Services table:  ServicesLink (a link to the GuestID in my guest

Not sure if this can be done, but I am trying to run a set of queries
in sequence which calculate age groups for customers in a specific
period, then apply a month and year value to an appended entry in a
table, all based on criteria of "between #variable-start-date# and

I have a database with a main table called "Tracking".  This keeps track of
all my orders and projects.  Any order/project that is over 3 years old needs
to be moved to another table (let's call it "Historical Tracking").  
I need to build a query that will

I have a Table, which i save different time slots
eg:
Time                       Remark  

If I have an access db with a table containing a date and another parameter
say a number benig read by oledb commands, can I send an sql select query
that will return all records matching that date, but in the ascending order
value of number field ? Is this something I can setup ...

I am creating a table called SalesForecast.  It has CustomerName, SalesRep,
Jan08, Feb08......Dec08.  I am going to create an input form for sales reps
and they are going to put in monthly forecast dollars.  I somehow want to
make it so that a sales rep can change a number but ...

I know i've done this before but for some reason i'm having problems here.
if i have 2 records:
  Policy_Number Rating Identification MaxOfPremium Amount
     RSA000128-07-00 1 00000058

I am trying to use the following in a form wirth a subform but it does not
work. [Forms]![TripsMain]![MemberNumber]
Any suggestions?
Quinto

I have an application which uses a master viewing form with a couple drop
down combo boxes for the Dataentry people to select variables - like Type of
item or Category.
Accompanying this I have an Item and a Category table which contains the

I need some help here.  I would like to group my data by week.  ie Week 1,
Week 2, Week 3 etc.  I can use the DatePart function to get the week number,
but the only problem is my week begin on Friday.  Example: Week 1 = Dec 29,
2007 - Jan 4, 2008  Week 2 = Jan 5-11, 2008 Week 3 = ...

I have a make table query and want to look at the records.  Is it okay
if I open it?  Will it open in datasheet view?  The table is very
large I don't want to chance recreating that table and loosing my
current data.

I have the following table in Access
Email                             Field1
person1@email.com       message1
person1@email.com       message2

is there any Function similar to the VLOOKUP function in excel for access