I have a query looking at 3 tables that I am trying to pull user access responsibility names out of. However, I have criteria for the name structures that...

I have access to a Cisco ICM database. Whenever I make changes to the ICM system, it updates the tables. To monitor the changes and to keep track of the...

I have no idea if what i'm asking is possible, so any help would be appreciated. I have two date fields. I want the second field to be populated with a...

I have a 2 part question. 1) How do I convert text stored in a table to numbers. It differs from question to question, but basically I need to convert T to1...

how to convert uppercase Address field to propercase

Hello, I have a string of characters like "NP,VY,21SPC,A,PNCPCY,VFB,1750" or "NP,VY,ECO315,A,OVEXCY,VBG,55" and I would like to isolate the characters...

how to convert uppercase to proper name using update query

Where does a SELECT Statement get placed? Is it in a query in a criteria or field expression? Can you give me a detailed example please? Thank you. -- kate

Hi I need a query to sum the column example: AGE 10 10 10 30 - the query should give the grandtotal as well the data

In Excel there is a function called Floor which allows me to round down to a specified mulitple. Is there a way to duplicate this in Access? I have a bunch...

Working with the following: SELECT JeffC_A_Dates., JeffC_A_Dates., JeffC_A_Dates_1.Admit AS InitialAdmit, JeffC_A_Dates_1.Discharge AS InitialDisch,...

Hi there, I have a table in the following format: Month Category Value Jan A 1 Feb B 5 Mar A ...

I have a table with multiple duplicate entries for "employer" and need to query only certain "types" if they exist. For example, from: Employer A ...

TEM TYÖ JA ELINKEINOMINISTERIÖ ________________________ Helsingissä 27. päivänä toukokuuta 2008 "Mielipiteitten esittäminen julkisuuteen nettiin...

I have several queries (MB59, MB59 Skimming, MB59 RD, and MB59 Obsoletes) that are retrieving the same data (MB59 data), but are applying different filters...

I have been researching and spending time in help - looks like I can write a sub-query to do this but it is over my head - can anyone assist? Below is an...

I have a DB that I would like to pull the correct rate from tblOcean that corresponds to the each shipment in qryGetBasePerContainer. I am trying to do this...

In Column A I have an ID #. Column A Column B 1 1 1 2 2 1 2 2 2 3 3...

I have an inventory table which has duplicate values and am looking for a way to update the table so I can add the duplicate value and combine into one...

Thanks to this and other forums, and the access MVPs out there (especially John Spencer), I'm so close to getting the data I need. Here's the SQL view of...