I am trying to export a table to a flat text filw with fixed widths and would
like to get the last column to right justify.  Any suggestions would be
greatly appreciated

I have 2 question.
1. How to link two table that contains same fields like another but
differnt time periods(example: one is 2005, another one is 2006). I
want  to create a query to filter from both tables.

I have a database to which I just added a timestamp field.  The update query
I'm using uses an ID number from the form used to edit data as criteria and
is set to update the timestamp field to Date() when the user clicks a command
button on the form.  It works fine except for a ...

We are using Access 2003 as a front end to a SQL server, but one of the .mdb
files is not functioning correctly, it will on a daily basis become corrupt
and demand to be repaired, using accesses auto repair function it appears to
be repaired fine but when you access a particular ...

i have a query (for a report) with a main table and 2 1-many tables.  all
joined by the primary key in the main table caseref.
i have a form based upon these and can enter data no problem.  the issue i
have is as follows

Hi!           
Please help me how to write Rank in SQL,        
Code    Date    YTD    Rank
220-00    20-Oct-06    25.25%    4

I am trying to calculate elapsed time.
The first field in the query:
Arrival Date/Time     99/99/0000\ 00:00;;_
The second field in the query:

I have a command button. that runs query. I want  to sum the one field
in query result. anybody give me some suggestion.

One of my MDB applications in Access 2003 uses a large network of
interrelated queries behind reports and forms. I am starting to lose track.
What third-party tools would you recommend for visualizing dependency
relations among these queries? The provided Property Scanner is too ...

I am trying to use the switch function in a query.
I am trying to get the result to be as follows
when [down]=2 And [distance] >3 And <7
I am not sure exactly how to write that?

I want to create a query that finds records that are duplicated. An example
I have is a table, Parts, with three primary keys, partID, partFilename, and
partDirectory (this is just an example, not the actual table I have).
I want the query to show records that are have the same ...

Before running code I would like to check the result query has been
created and is still in the database.
check  query exists else  msgbox  "query missing"
What code would I use ? is this an error thing or is there some code

I run a query from a command button on a form.
If I reselect and click on the button again the underlying data in the
query changes.
However the still open query displays the first selection.

I have a table in which I need to import data from another (smaller) table.  
The larger table needs to be populated with this new data, then other data
entered to be sent to a vendor.  I keep getting the above subject error.  
here is the sql for my query:

I'm rather new to totaling via queries, and I'm not very sure of what
I'm doing. I have a parent-child relationship between 2 records, where
the parent is literally information about the parent, and the child is
information about the child.