Search results

Seems like, I'm GMT+5. My boss says that everything we're doing with Databases is to move away from Excel sheets and he doesn't want to use Excel at any stage. He says it is possible that you come across some nearest acceptable reporting format in Access, but we certainly don't want Excel. He...

Ok, almost 9 o'clock in the night and am still in office. I know things about queries and reports and will read about cross tab tomorrow morning. I think we have a big time difference, could u post something about exporting to Excel thing and things you spoke about earlier so that I won't waste...

Thanks, at least something is in the right direction. Well, i rarely worked on Excel and at the moment i'm spending all energies to learn Access. Some hint on how to achieve this will be useful, for me to work out in that direction please? How is it possible to get sub total, of another set of...

Uploading the database, you'll be able to look at relationship diagram. This is what i'm able to come up at this stage. I'm trying to use report to apply with my solution, and I made a bit of change in your initial table suggestion to get my calculations...

Yes, and I achieved almost same with Cross Tables and then Reports. At the moment, I'm stuck with totaling.When i Total all components of a Job Pack (X represent Job Pack in Screenshot 1) it works correct by Grouping on JP in header (Job Pack), but when I go further and Sum based on 'Area', it...

Thanks for feedback. Ok, basically I work in Oil and Gas industry for an Electrical, Instrumentation and Commissioning company. Electrical services major, this is why you're looking at lot of Electrical terms in uploaded files. Our company provide these services to drilling companies, mainly...

Well, the Excel sheet I pasted above is what I received from our Costing and Planning department. Basically, this sheet is based on cable pulling project and shows percentage of overall work, percentage of work component from this overall work, man hour required for the job and then division on...

Attaching screenshots. Uploading XLXS version of Excel file at Google, maybe you'll be able to open this?? https://drive.google.com/file/d/0B40aEpxbK6NfQkZ3V1I4dEJNYjQ/view?usp=sharing Thanks.

So how do you suggest how i deal with reporting this kind of a sheet in Database way?? Like i said, i'm not very experience with Access so I need additional guidelines in addition to advises, at this stage.

well, I'm getting crazy for on this. I'm looking to create reports which should be as close as possible to Excel sheet i'm attaching. i've used suggestion by 'plog' in Tables forum and took a single field 'Step' for all 10 steps shown in Excel sheet, and it no doubt is a right way. Now boss...

sorry, wrong version of xls as posted, attaching the correct one Thanks

Thanks again. Numbers in Step_Desc are just for sorting purposes in CrossTab, like i posted in another post. Again this is just a testing )... By the way, did you get a chance to look at 496D sheet from Excel file? Re-attaching.

I understand your point. I'll try to make it useful. Actually ROC sheet is basis of all calculations for all other sheets in early Excel file i attached. For e.g. 496D and 496G (496 is project number). That is where it'll start making a difference in calculations, that's why I was trying to...

Hi, Another question, on top of my first question already in Table forums. I've problems setting up a sequence/sort order in CrossTab Query. I want to display result in CrossTab in a sequence as shown in 'ActualTable' screenshot, but I'm not able to order/sort as i want for SubDiscipline row...

Thanks. Yes, I'll be able to show the part of the total percentage after summing, but there's no automatic way to calculate before entering the data per component (non-bolded items in the first column), for e.g. that 'Cable Installation' is 50% of the total job. One has to calculate the values...

Thank you plog, at least you made me get started. I'm not worrying about Normalization for now, i'll do later once i start getting sense out of it. you see the structure is fairly complicated and sheets ROC, 496G and 496D are inter-related. I just accepted to create a database on Costing and...

I could not find better way to represent Excel sheets in Access tables. I'm attaching Excel file, sheet ROC in attached file i need to represent in Access table. I've tried to explain a bit in Description column in the end, so that it could make little sense to you guys. I need to convert other...

Something like: Dim int1 As Integer Dim text1 As String int1 = 2 text1 = DSum("CurrentStockLevel", "tblEquipment", "invoice = " & int1 & "")

Thanks Glaxiom, DLookUp solved my immediate problem. Marlan, thank you for RecordSet references. Next chapter in my VBA is on SQL and i've seen RecordSet discussed there. I've quickly seen your references and they're packed with valuable information. I'll get back on them once I go through my...

Update Query could be something like below, based on your tables. Paste in SQL view and have a look in Design view. Make sure you place all other conditions in place, like remove quantity should not be more than quantity in stock, or whatever your conditions are. UPDATE tblEquipment INNER JOIN...