Queries

Run DOS Prompt
Hi there, I need to run a .exe file to run some exported data through a programme before importing it back into Access. Where/how can I run the .exe file from a query or macro to automate the process (I'm fine with exporting and importing the files - just need to know how to run the .exe). Thanks ... 29 Jan 2006 11:53

General question Acces Database Queries
Goodmorning, I would like to have the most suitable solution for this particular problem I have a tabel A with the following fields Mattercode, mattername, rtk, date, amount and comments. some mattercodes are detailed and are put in table B with the following fields mattercode, mattername, date, amount, th... 24 Jan 2006 08:31

Many-to-Many relationship Query
I've got a database with a many-to-many relationship between two tables (Employees and Customers). By this I mean I have a table that sits in-between both tables and records the relationship. I want to create a query which lists all the Customers with a calculated field that lists all the Employees within it. ... 23 Jan 2006 14:46

Calculation
Hello All I need to calculate the average weighted interest rate for a report. I know how to calculate this manually (using a calculator) however I cannot manage to have MS Access calculate it. The formula is:- Loan Amount -------------------------------------------- (<==== Divided By) ... 22 Jan 2006 09:10

Name order streamlining
Hi. I have a query that's sloppy, and I'd like to revise the name order. I have members that can be spouses. If there is a member spouse, I'd like their names to appear in a particular order: John Doe and Susie Anderson (rather than Susie Anderson and John Doe). Originally, I was relying on SignificantOtherID... 9 Feb 2006 10:00

Finding the 70th percentile
Hello, I have a huge amount of data in a table. These are times taken to fly somewhere. I want to group this data by month and year, and for each month I want to consider all the flight times in ascending order of duration. From this I want to capture the 70th percentile data. Take this example: We have... 27 Jan 2006 08:39

Merge different rows to same column in Access
I've looked everywhere to find out how to do this but I couldn't figure it out. I need to take a table and where the TG_ID is the same but has different NPA and update ALL_NPA to look like that at the bottom and where it only returns one line per TG_ID with all the NPA's in ALL_NPA on the same line. Query3 TG_... 19 Jan 2006 15:00

query unique count for field
I am trying to count a sorted number field in a query. For each identical number I want the count to increment by one. For example Number Count 183 1 222 1 222 2 222 3 343 1 thanks ... 27 Jan 2006 06:58

split names in into 2 fields in access
I have a name field that has the complete name in it. I need to seperate it into a FirstName and LastName fields. The names are entered with space between names, in the following format: firstname lastname. The problem I am having is when the first name comprises of two names . Example mary kate olsen. I ca... 18 Jan 2006 18:39

Opening Stock ----- KRISH
Hi! Everybody........ Anyone help me how to calculate Opening stock, Stock-in-hand(closing stock), stockreceived, stockissued in single query of stores. Is it possible? please help. Thanks a lot. KRISH ... 17 Jan 2006 00:38