Search results

Thank you, It's working now.

Hello, I'll admit that I haven't used Access in quite a while. I am trying to insert a field into a existing table from the main menu. Once I have highlighted the column that has the data attributes of the new column that I'd to add (Yes/No button options), I am unable to locate the "Table...

Yes, this is imported data. I understand that the field names have no meaning to you, but I know for sure that the underlying data formats between both table are the same for the fields that I'm trying to compare. For example the PO ID fields in both tables that are indexed are formatted alpha...

Ok, thanks for your help. I have attached screen prints of the tables.

I guess I need to try another route. I do not see an option to upload a zip file. I see an option for inserting a link and and image.

table 2:

Ah, I tried to post two screen prints, but this site would not accept them.

Ok here are the two tables that I'm comparing. I don't necessarily need a new created, but I query that shows shows the records that do not match would be great. In the first table the BU PO ID matches field2(PO ID) in the second table formatted as text. I want to compare the PO_Amount in...

The two tables both have some financial data. I have both ID's fields that match and they are formatted as text. There is a currency field in both tables that I want to compare. The ones that don't match, I would like them to go into a separate table. I hope this helps. Thanks again!

Hello, I am trying to create a query in Access 2010 for records that don't match based on the following criteria. I have two tables with identical ID's and I need to do a comparison on the amount field between both tables and only return the records from one table displaying all fields plus...

Hi VbaInet! I really appreciate your help. I am going to try what you suggested. Thanks again!

The record source is a table. Can you help?

Hello All, I'm using MS Access 2003. I have a report that sorts alpha ascending but I want one the sort fields to be appear 1st and then ascend the remaining. For example the field that is being sorted at the second level starts with an "F" and the first level starts with an "E". I want "F"...

MI man, Thanks for the advice! For the time being I will tell my end users to do the simple approach. Copy and paste into another spreadsheet :D

:oI have a large voucher report that consists of about 250 tabs (separate offices) in an excel workbook. Does anyone know of a of way to email only one report "tab" via MS Outlook after opening the work and selecting only the report tab that a user would like to distribute without the email...

Thanks pbaldy! I figured it out!

The format property is set to general number. I used the following syntax =Sum(FormatNumber([Net Difference No of Claimants,UseParensForNegativeNumbers])) and it still doesn't work. Does anyone have suggestions?:confused: Thanks!

Yes Net Difference No of Claimants is stored as a #. Each time I attempt to use what is suggested for the Format function in the help menu and then attempt to view the form in print view, access treats the function as a parameter function.

I'm not sure how get negative numbers to appear in parenthesis. I used the Format function inconjunction with the Sum function to aggregate a field called "Net Difference No of Claimants" that exists in a table. I've tried variations of the following function; =Sum(FormatNumber([Net...

Hello, I am having a small problem inserting a 0 in a text field that contains a date. I work with large amounts of data derived from other systems and I have to format them to meet the requirements to be feed into others. I need a query that will only insert a 0 to the single digit day within...