Access Query

Access Query - Repeating fields

I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this Software/Hardware used: Microsoft Access 2003

Grouping Query

I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 ...

Make Table query Produces different result than same select query

In MS Access what would cause a make table query to produces differnet results than same query as a select query

How to use lookup query to return only entries matching the related field of active record

I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

Windows Sharepoint Servs 3.0 - Linking existing Access 2007 Database with new list.

Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

Problem MS Queries Refresh in excel file located on client network

I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as "ODBC Microsoft Access Driver Login Failed" Disk or network error.

Using WildCards in IIF Statement

Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

Using Access query data in Excel

I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection...

Sort Access Query From Variable

I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it's sorted by the field name I type in the text box. Any help would be greatly appreciated.

Export from Access to Excel shifts decimal position randomly

I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...