Recent content by sb4216

Thanks Paul.

I want to start by saying I am new to Access programming, so please forgive me if my terminology is not correct. I have 2 tables (master and journal), the Journal table contains a foreign key to the Master table. I have one form that contains a subform (child form that is a datasheet of the...

I have been asked to take a file, import it into MS Access to massage it to the desired results then export it to MS Excel for use by another department. Everything is going good until I get to the Grand Total. I query the specific data to get the individual records totals, then I "union all"...

Not a problem, your answer led me down the right path. I didn't really have a path before you answered. Thanks again. Sherri

Thank you Bob. That lead me in the right direction, however Access still couldn't open the file even though it now had the appropriate extension. I did some additional research and found that it is because changing the extension and saving as an excel workbook aren't exactly the same thing...

I am trying to write a macro that will import a file. The file is created from a mainframe export and the file does not have a file extension. I am using Access 2007 and it will not let me import from a file that does not have one of the standard extensions and gives an error of such when I...

In general I understand that....but my desired results contain both sets the ones that I can match on region as is and the ones that can't match specifically based on the data. So my desired results contain the South, North and Other regions. Not just one or two at a time. This query is just...

I am trying to find out how to join 2 tables (in reality one of them is a query that I am trying to join to a reference table) based on different join criteria. I am tyring to join [South]=[South] in one case and [Other] like "Other*" in another case. I am not having much luck. Here is a...