if got tables tbl1,tbl2,tbl3; is there any way to make a query like "select *
from tbl%"? my access is 2003.

I received some help on how to assisgn the a network logon name to a field in
my table:
Private Sub Form_Unload(Cancel As Integer)
Dim strUser As String

BACKGROUND:
I work for a fostering agency and I have a sprawling home-made client
database.  Within it there is a carers table (one record per household) with
an Events table joined to it via a CareFamilyID.  Within the Events table you

I have a report that I created.  I am grouping by Week Number.  When I
display the date I need the date to come up as a week not a number.  What is
the best way to convert the date over to a week from a week number?

name  shipdate    units
carol   1/3/2010  12000
miling  2/3/2010  15000
marcy  5/3/2010  14000

I wan to open other databases from a macro in one database. I can't
seem to find the command. Can someone help?
Thanks

ziplow  ziphigh    GA   PA    IL  rank1 rank2
5                5       5    6   GA    PA
6       9          7    8    8   GA    PA
10      13

I am trying to create a sum function that will allow the addition of the same
fields across multiple records that have a common foreign key. Customers can
build up charges for part of an order (a job), i would like to create a field
in a query where I can see the total charges ...

 https://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.publi
c.access.queries&lang=en&cr=US
I usually go to the above address  also and learn about queries by reading
all the posts and their answers. Over the last few weeks only a blank page
appears and even ...

Hi Everyone,
I have a problem that I was hoping somebody may be able to help me with?  I
have a query that shows the dates entered when a person has a particular
vaccination - the SQL is below:

zip code  zone
100-150    1
150-200    2
200-300    3

Every linked text file I have in Access 2007 causes an error saying
that the information does not meet the criteria or some such(forgot to
write down the exact error).  However, when I change the criteria in
the query the append then works fine.  I would like to know how to fix

I'm trying to run a query on the opening and closing balances for several
years. The factors I need are:
opening balance
closing balance

I need your help to create how to split the words into four fields.
one field:     Address, City State Zipcode
change to:
FieldA :  Address

I have a problem that I hope someone can help me out with.  I have a
spreadsheet that I am importing into Access 2003 to be used for some
totals.  Unfortunately, the spreadsheet is not very pretty, it is
created from a pdf-type file that was formatted for printing.  I am