Hi all, I have several queries that we run on a daily basis and afterwards
manually type the query results into an Excel spreadsheet. I'm trying to
figure out if there's a way that I can create a report or somehow make
Access populate the particular cells in the spreadsheet with the ...

Is there a way that I can modify the data as it is brought into the query to
create 3 fields with the YYYY MM and DD vs 1 field with YYYYMMDD?

I was trying to use a parameter to open a query.
I looked at this page:
http://office.microsoft.com/en-us/assistance/HA011170771033.aspx
I downloaded and opened the "Using Parameters with Queries and Reports.mdb"

Hi, how can I create a simple select query that will select records from a
table with only inputting partial name from the record ?  Hope that makes
sense. Thanks.

Have tried to find the answer to this question here but have not.
I am building a query to identify the correct PropertyCode for each record
based on the dollar amount of the record.  There are two options.  If the
dollar amount is above the threshold the record would have a code ...

i keep getting an error 2349 when i try to open microsoft outlook

I have a table that contains data on people we have paid in the past.  The
table contains the fields: ClientID, LastName, January, February, March,
etc...  Sometimes, we will begin to pay a person in January, but not in
February or March.  Sometimes, we will begin to pay a person ...

Hope I can explain this correctly.
I have a database that looks like this:
Record#    Type    Time
1    12345    93000

I have a db for a new music teaching business.  It includes the following
tables/fields:
tblMusicTeaching (with student details)
strSurname, etc

Good afternoon,
Please could you let me know how to format the following as a number field?
VALUE: IIf([VALUATION] Is Null,"0.00",[VALUATION])
When I now try and perform a calculation on this field it does not recognise

I have a query that pulls a list of all loans secured by one or more
vehicles. Until I upgraded to Access 2003, the criteria I was using on the
Collateral field worked fine. Now, it also pulls loans secured by savings
accounts, probably because the word "savings" also contains ...

Is there a way to update multiple records based on the most recent record? I
have a table with several columns. The PK is always different, but everything
else should be the same. I'm looking for an easy way to update previous
records with the current information. Is this ...

I have Access 2003 (Office Professional) on a PC running under XP
Professional.  I have some simple queries that are normally run once per
shift.  These queries do not contain any VBA code.  They access only one
table.  These queries have the following conditions:

I want to fill in values of a column that have some blanks. The blanks are
supposed to have tracking numbers in them but some don't. I want to assign a
number to them such as CTW 1, CTW 2 and so on. How do i do this?
Thanks in advance

Hi.  I'm sure this has been answered but I searched and searched and couldn't
find it.  I have two tables.  Table A has a invoice # and invoice dates.  
based on invoice dates, I want to return a value.  For example:  
If invoice dates between Date and date, "A","".  Right now I ...