I'm trying to convert a numeric field to a short date format. The current
value looks like "20080115". I would like to change that to 01/15/2008. Any
suggestions? I thank you in adavance for your help.

I am having a display issue with a form that I am using as a subform in
datasheet view. When run alone everything works fine but as a subform it does
not initially display a vertical scroll bar even though there are more
records than can be displayed in the space available. To ...

Hello, I have used this before to find out what is in LIst A that's not in
LIST B.  It is not working this time.
SELECT ex_VehicleInventory.[is unique?], ex_VehicleInventory.[Is good
length?], ex_VehicleInventory.Sequence, ex_VehicleInventory.[Full VIN

The data to populate a combobox resides in a separate database.  I need to
use the sql returned by my function below to be the rowsource.  Is this
possible?  The result of the function works in a query in design view.
I'm open to other suggestions.

This wasn't answered the first time.
A record can belong to one of three groups and each group has a total
monetary value attached to it.
How can I calculate the total for each group as a percentage of the overall

On our Sales Order Entry Form, I've built a comprehensive 'filter' based on
concatenating strings into the WHERE of sql, which is then used as the
recordsource for the table, thereby 'filtering'. (I did this since some of
the criteria that's being filtered on is in subforms and ...

Can a Yes/No field display data in any format other than check/no check?  Can
it display Yes/No or -1/0?
Thanks,
Patrick

Dears
While we making a query by using query wizard' there is a option to get
sum,min ,max,avg in summary option if the data is in number type.
Any body can sujest any logic to get max and min value if the data type is

I asked a question a long time ago and received a response that involved
retrieving the userid from a user's login to filter the results of a
database.  Essentially, I am looking for the creation of a report that is
generic in design but specific in results based on who is ...

In one database, I can type "ny" in the criteria for "state abbv" field and
the query with return all records with "NY" in the field.  I can't do this in
a different databse that I made.  WHY?!
for example in the new database, i have field LOB that contain WC or EO.  When

Hi i work since one week with access 2007. And i want to ascending my qeury's
by name or description. How can i do that? I don't mean in the query but
where all my qeury tables etc are.
I hope someone can help me

I have three queries that produce the same three fields:
SELECT A.ProductID, A.Description, A.Quantity FROM Query1 AS A
SELECT B.ProductID, B.Description, B.Quantity FROM Query2 AS B
SELECT C.ProductID, C.Description, C.Quantity FROM Query3 AS C

I'm trying to save a query (select) as a table but there is no option to save
as table.... just query, form, report or data acess page.

I have used the query wizard to create a simple unmatched select query which
runs wonderfully and returns the expected 51,000 records.  When I use the
same criteria, or try to switch it to a 'make table' query for export, I get
"invalid argument".  New to SQL, but the code ...

I have a table:
Run_point_List_ID 1 (Autonumber)
Run_point_Venue_A
Run_point_Venue_B