Search results

Hi Jose Unfortunately, I dont have a specific answer for you, but I would consider the following. 1. Create a select query that has a field which identifies the dates into a group, using a group dates per quarter function. 2. Use this query to generate your crosstab.

I have developed a db in Access2007 - it was used to generate and print barcodes for our library system. I have recently upgraded my MS Offcie to 2010 and need to add another component that manages loans of our hardware. So I thought I'd upgrade the front-end of the original db for use on a...

You are correct about being PC correct and taking "CYA" precautions. I have simply told management that what they want, cannot be done. They have to take what they get. Hopefully they will now drive a process of change. (but I'm not holding my breath) I strongly suspected that there was no...

Awesome idea Jon. Wish i had this when starting out. One thing you might need to do later is group the videos into the different object types (Forms, Tables, Queries etc) as you could have 100's down the track. Also - You might need to advertise the fact that these exist. I came across them by...

thanks Stopher - now i learn too.

thanks SpikePl - that confirms EXACTLY what i thought. Just following order to do more investigation.

Hi there i realize that this is an access forum, but was wondering whether anybody knew if it is possible to interrogate data in a OneNote file? If so, are you able to share an example. We are thinking of recording student data (behaviour, Movements, Contracts etc) in a OneNote file, but I...

Hi Fleury I read one of Bob Larson posts earlier which advises some of deprecated items in Office 2010. I seem to think that the calendar OCX was one of these. Perhaps you should reconsidder if you want to update your DB to Office2010 later.

Hi Neil Not sure what you mean by your question, but as far as i am aware, one cannot change data in a Cross-tab query anyway.

Thanks Bob In effect, by putting in the "IsNull", you are saying "Show me all the records that DONT exist in this table". Very interesting indeed. I was recently asked to extract data based on what is NOT known and i simply couldn't get me head around it. I suspect that this is the solution.

Hi Xaysana I have found that a crosstab query has some limitations. Maybe this is one of those? If you are getting the correct result from a select query, why not get the form to check the select query, but display the cross-tab?

Hi LearningTheRopes Unfortunately, the best advice I can give is to point you in a possible direction. Can you use the DCount function in this case? (Essentially, this can be used to count records in a given domain. (ie unique records) - So if 3 meeting took place, but each was attended by...

Hi Philgo Its a bit difficult to comment without knowing exactly what you data structure (tables) looks like. see this site for some samples (http://www.databaseanswers.org/data_models) Look for the Schools /Student records links on this page.

Hi Parsolamew I have found that it often helps to create a normal select query, and then create a separate cross table query, based on the select on. Are you trying to do both in one step? what version of Access are you using?

Hi Gary I think that exporting ALL the data to excel is actually a good thing, as you could simply apply a FILTER to the data - by currency/type. Or is that not an option?

Hi Paul There are 2 ways that you could accomplish this using a cross-tab. But in both cases, the data will not be presented EXACTLY as you propose. By far, the quickest/easiest is to export your data to Excel, then create a Pivot Table (known as a cross-tab query in Access.) You can find the...

Thanks JDRAW - I did take a gander at a number of the data modeling diagrams. And yes - they have been useful. But, (i think) my problem is not with the structure of my rather. Rather, it is with the internal process of the organization. Unfortunately a culture that I am not able to change...

Each month, I need to collect information related to equipment in vehicles at a particular location. Other than getting a written report from each location, I do not know what vehicles are there until I get the report. I need to keep a record of past data. (easy enough) . . . but In order for...

A revision date will work, but you could also use a batch number. eg 201101 and 201102 for the first and half half of 2011 respectively. or simply start at 1 i would suggest that you add another table that stores some kind of reference for you. Say that batch one was questions about pets and...

First of all - remove the combo box from your form. Create a table to store the rates - Populate the table with the rates that are applicable. Now add a combo box to your form - it should prompt you and ask what it should do with the field that you selected.