Recent content by kat50

Thanks for the quick response I beleive I have more fields to sumarize than I can do in a cross-tab query...

Hello Folks. Does anyone know how to change the orientation of a report? I would like to have the field names on the left side from top to bottom with my summary data to the right of the field names - instead of accross the top from left to right with the data beneath. Thanks so much!

I appoligize if I have been unclear. I have multiple fixed width files their extension is DY3. I would like to open Access and have a function that performs as this excel macro does (to adapt this macro for use in access). Currently I have to open Excel run my macro, save the file, open...

How can I re-open this question? Thanks so much!

This VB works in Excel I want to adapt it to work in Access so I do not have to have the user preform multiple steps. My data is in a fixed width text file but it is not a .txt extension so I cannot use the transferText option in Access Line 1 in the file is blank and these are the next 2...

Hello folks, Can someone help me adapt this macro/module (that imports fixed width files into excel) for use in Access? I have pulled in the excel library, but do not know where to go from here. Point of interest: data is not in a .txt file and the header row starts in row 3. Thanks so much...

I don't seem to see the replly to my post. Can you advise what "strFile" stands for? Is that a wildcard? I will try to peace together although I do not know what to search on to create the vba needed... Thanks so much!

I would like to use a TransferSpreasheet (import) macro but I do not see a way to allow me to choose what file name to import from. Can someone give me some instruction? Thanks a million!

Essentially I have a table of customers for a given week. That table is broken down 6 times (6 queries) into various categories. When I want to compare to another week, I do the same thing. Then I use an unmatched query to show what customers are no longer in a given category. I need to show...

Thank you for the quick reply. I have 6 queries. I need to have the means t o state what customer # is in which query - I (think) I created a function to return that. I am hoping to do this witout liking all 6 queries since that slows down the computer...

I have created a function (Module)called mID, I would like to have the value returned in a query. When I use the expression builder and just choose this funciton it says I have the wrong number of arguemnts. mID is: Public Function mID() As String If Not IsNull(DLookup("Customer #"...

How can I use NZ with a checkbox where I am doing a query by form? I have my checkbox set to triple state, but I do not know how to have it return all values if is greyed... Is there anyway of setting this in the Nz function so that it will be true, false or could be either? I have...

I suppose I should have said "how do I layer an if statement?" I am sorry, beginners don't necessarily know how to ask the right question. I need to produce a statement as such: if[SumOf30To60DayDebits]>=[Balance] Then if([Balance]-[CURRENT]>0 then ([Balance]-[CURRENT] else 0 but if...

I try giving it a whirl. I guess I cannot do a nested if type statement:( Thanks for your advice. Have a great day!

I need to do if one thing then this if otherwise that... Over30: IIf([SumOf30To60DayDebits]>=[ Balance], iif( [Balance]-[CURRENT]>0, ([Balance]-[CURRENT],0), ([SumOf30To60DayDebits]-[Over 30]))) I am having comma issues...