Search results for query: *

Hi, I am trying to export an Access data to Excel via a report and noticed that the Report Header is NOT exported, only the page headers (Field column Headers) and row data are exported. I was thinking of a template of which an existing Excel File has a Report Header AND just append the...

I have a list query sitting in a tab form that needs to be requeried/refreshed when i update variable field in Form A. The tab form is sitting in Form A. How do you requery the list in the Tab Form if the event is placed in the AfterUpdate property of the variable field in Form A? Thanks +++

I need help on this. I have a table of which REMITAMTINCLADJ is updated from REMITAMTINCGST, ADJ1, ADJ2, and ADJ3. All fields reside in the same table and are of currency type. I am using Update Query to update the RemitAmtInclAdj The formula in the Update Query is...

I need some help on this... I have Form B sitting inside From A. Form B is not really a subform of A, they are not linked. In Form A, I have a text field (not save in database) called PERIOD. In Form B, I have several fields called by a query, a field in Form B called PAID_PERIOD will be...

Hi, I need some help in making the data below to be in ONE LINE (see desired result in Result 2). The data below is already the result of query from several tables. I could not go any further--please help.[sadeyes] Result 1: ========= SOPNUMBE LNITMSEQ CMPNTSEQ ITEMNMBR SERLTNUM ---------...

Hi, I created a query to update a MS acces table from Excel spreadsheet. When I run the raw append query it works perfectly well. when I add a parameter value in a field to append only certain records in raw query it also works fine. But when i pass on the parameter value in a form and the...

Hi, I would like some assistance on this append query. If I remove the INNER JOIN, the link source table, and just add the fields from the source table the query works. Otherwise, the query below doesn't work. Is it because i link two fields? or Is is because in my WHERE CLAUSE i have two...

How do you merge two or more excel files with the SAME FILE STRUCTURES into one. Everyday i receive excel files and usually cut and paste (append) this one into a master summary for the month with exactly the same columns. This become cumbersome since there are several files to cut and paste...

Hi, I need some help on this. My objective is to place the sum amount from one tab sheet to another. Source Sheet Tab: ---------------- Dealer - TrnType - Amount ------ ------- ------ ZT5 RUBY $100 ZT5 RUBY 150 ZT5 PORT 90 ZT5 PORT 110 XXX...

Please help! I am having trouble with this. I am trying to query records with duplicate Invoice Number and combine the other fields in duplicate records to the first record. Sounds confusing but I will illustrate below the source table and the desired result required: In the source table, all...

Hi, I used to create new user by just copying existing user and rename appropriate fields. All the attributes of the old user is copied. We are using MS Exchange 2000. Lately, using the same procedure it doesn't copy anymore the attributes. I have to recreate the smtp, x400 email addresses...