Search results

Thank you - that worked

Sorry if this is simple - but it is Friday afternoon - I am sick - and probably simple myself. I have a table with a column that has two values - one is empty and the other is "NY". When I print my report I want the empty (or blank) to show as PA and NY to show as NY I have tried...

I pull data from 2 linked SQL Databases. The information includes header information and detail information from invoices. Header information is due date, terms, ship to, etc. Detail information is individual items shipped I then need a report that combimes the has a these by invoice IE...

Ok - I'm new to VBA so bear with me I have a REPORT that I need to export in a Tab delimited format. The report has header rows and detail rows - starting with H and D respectivly. As I have searched and tried to use: DoCmd.transfertext acExportdelim, ,REPORT,C:\REPORT.txt Everything...

Didn't work for me. I am trying to export from an Acess REPORT - not just from the query. I don't know if that makes any difference Thanks, Jeb

Thanks for the reply. The problem is that I would like it to export directly from Acess into Excel- without opening an Excel worksheet and formatting the cells. Is there a way to have Excel recognize numbers as text when being exported? Thanks, Jeb

I am exporting a report from Access into Excel. One field has a store # - say 029. I need to have the leading zero in the field - but I can not get Excel to leave it there. Any suggestions? Thanks for the help. Jeb

I have a report that I would like to e-mail in a tab delimited text file so that the recipient can import it into another data base. I do not want to have export to Excel then save and send. Is there a way to insert the tab character in the report when I sent it as a text file? Thanks, Jeb

I am pulling 4 fields from a from a database through a query. They are: qty_ship qty_uom (unit of measure) alt_qty_ship alt_uom The units vary - but an example would be CTNS as the primary and PCS as the alt. If qty_shp has a value then alt_qty_ship is zero (not blank) I want to print just...

OK - Here is the deal: I have a report that is pulls sales by item sub-totaled by ship to addresses. The only problem is that there are 2 ship to addresses for the same store. The first designates if it came from our warehouse The second designates it was shipped directly from the mfg These...

I am trying to write a query that will sum the total of payments to invoices and create a new table with these totals. The fields are: DUEDATE, INVNUM, NAME, PAYMENT The table contains multiple transactions to one INVNUM (IE an opening balance - payment + credits, etc). I want to sum these...

Is it possible to turn the results of a query into a new table easily? The results of my queary are too large to export into Excel and import back in. Thanks, Jeb

I think it is in the link to the table. I tried the same query on another PC and got the correct results. I am reviewing my network settings to see if something is amiss. I will keep you updated. Thanks for the help. Jeb

Rob: It is a text field and changing to "like" did not make a difference. I have also tried "*200*" and variations thereof and nothing worked. PDX: I can not post the DB There are over 459,000 records. I am only pulling 12,000 so the criteria I entered is filtering somehow. I just can't...

Casey - if I delete the quotation marks I get a type missmatch error. PDX: This is an exact copy from SQL. I can't figure out how to paste a copy of the design view into this thread. SELECT infor400_sadet.prodgrp_sadet FROM infor400_sadet WHERE (((infor400_sadet.prodgrp_sadet)="200"))...

OK here is the scenario. New PC on my desc - new AIX box that I am pulling records from through ODBC Access 2002 I started to write a query and got strange results. I worked back to one table and one query and I am still getting strange results. SQL: SELECT infor400_sadet.prodgrp_sadet...