• RRN and JOIN…

    I have two files and I'd like to join and make a group-by on a xycod, in order to count the number of occurrences. This is the question: What happens on the RRN filed when i try to do group by statement? There is one-to-many relation between records and RRNs, so which is the RRN assigned to it?

    Devilva15 pointsBadges:
  • dBase locking

    Why is it when one certain user is in the DBASE no one else can get in - but when everyone else is in and this user isn't, she still is able to get in - all our settings are the same - Shared, no locks and the open database by using record-leveli locking is unchecked, this person was checked but i...

    Stallojc5 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • Recovering data from crashed database

    i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks &...

    Venkatdbait35 pointsBadges:
  • Sending an email with a link to a .csv file that’s too large to email

    My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?

    Kprazor45 pointsBadges:
  • How to use the data from other table into the main table in Access 2003 and 2007

    I'm trying to use data from other tables to make a sum and then display the result in a "Total" text. For example: I have in table1 3 qty's, in table2 2 qty's and in table3 5 qty's. I want to sum all those qty's and display them into the Main Form. I use MS Access 03 and 07

    Eddy20 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • Replacing dictionaries on Windows XP SP3 with Outlook 2003 & Office 2003

    I want to replace the dictionaries on all of our windows xp sp3 with outlook 2003 and office 2003. I want to include the company name as well as last names of employees and push it out. How can I do this as easy as possible?

    ITKE413,390 pointsBadges:
  • Adding column to existing table in a database

    When I add column in existing table. it contains null values in older records. it is possible to assign a value when add column so older records are modified with value

    Shrirama25 pointsBadges:
  • Best practices involving admin rights for user on user system

    We are currently in the middle of figuring out the approach we are going to take in regard to a user having admin rights on their system. Typcially we set up a new user as an administrator on their system when they are logged into the domain. They don't have a local admin account on the system,...

    Kevins740 pointsBadges:
  • Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,045 pointsBadges:
  • Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?

    Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

    BCF5 pointsBadges:
  • SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • Error using CPYFRMIMPF

    I have a .CSV file that contains a header record and then several detail records (random number as it is the EDI invoices). I use the CPYFRMIMPF to copy the first record to the header file and then I do it again for record 2 to *end. The problem is that it will copy the header fine but then it will...

    Cooking5 pointsBadges:
  • ID_NO INCREASE VBA ACCESS 2007

    PLEASE TELL ME HOW TO INCREASE ID_NO THROUGH VBA CODE IN ACCESS 2007

    AnandaDebnath280 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following