Sometimes you start off on a path and neglect looking for alternatives.  I
believe i'm on such a path and need some help.
I asked a similar question last week and got an answer that worked for
SQL2005 (using "for XML path('') ).  Unfortunately, I'm stuck with using SQL

I have a table with employee data. I am trying to get summary data for each
job title.........for EACH title, I am trying to get the following counts:
number of all employees with the title, number of females with the title,
number of minorities with the title. Also, I want to ...

I have several tables with many fields. On each of these tables,
combinations of 4 variables gives a unique record. What I need to do is to
create a single table with all the information(variables) form each of my
tables plus some additional calculated variables. I ran a series ...

Okay, I've tried several times to find this answer may someone can help here.
I have a query that looks at three separate tables and pulls out financial
information based on the assigned "Cost Code". Some of these items will have
changes. The Original is locked and revisions can ...

I've created a query with criteria to find all records attached to a specific
item number.  I also want the query to pull all item numbers.  For example:  
Item # field has criteria for Item 1234
The query pulls up all Model #s (say 100) that are under Item 1234

I have the fields Apples and Oranges. I would like to show the ratio of
Apples to Oranges. If there are 4 Apples and 6 Oranges I would like to have
another field that would contain the ratio 2:3 (Apples:Oranges). Is this
possible? Thanks

I'm trying to change the column heading on a query (for excel).  I'm getting
to the "edit column" screen but when I type the heading I would like to show
I get the message "Expected lexical element not found: <identifier>"
any help would be appreciated.

Has anyone ever seen this before?  I am using Access 2003 and while in design
mode of my queries, as I put in a criteria for testing, and close it, it
usually prompts me to save and I say no because it is only a test.  But
recently, after converting my database from Access 2000 ...

How can find which records in one field of a table are not in another field
of a table?

I have a database with the progress history of data:
for same jobnum I have records with increased periodnumber and periodend.
The query create a view with jobnum, periodend and periodnumber of previous
record for records with periodend = last friday:

new to ms access - i'm trying to get the autonumber in my main form to
copy to fields in my other tables - the customer Id is a constant
between my 4 forms - can anyone help????? starting to pull out my hair!

I currently use an Excel worksheet function that allows me to take a value,
write an IF statement against that value that outputs a new value using the
ceiling/floor MS Excel worksheet function.  IF(CEILING(#val,500) - #val)>390,
FLOOR(#val,500), CEILING(#val,500))  Basically, if ...

Hopefully this is easy.
Does anyone know if it is possible to change the default number format for
number fields to "standard" (or any other format).  I'm getting very tired of
going into properties all the time to flip the setting so that large numbers

I have been searching for the answer to this and can't seem to find
it.
I am trying to apply a filter to a recordset in VBA and it works
perfectly except for when one of the conditions is a wildcard.

My database users want to change an existing text field over to a checkbox.  
Right now, users are entering "Complete" for finished work items, and the
items are then transferred from the active table to the completed table.  
What they want to do now is just check a box for ...