Search results

Hi there. I'm having a problem with a data calculator that I've been using, basically I download this data extract that includes some dates, some numbers etc into an excel form. I've determined that the date values I extract are now being displayed as text (just 4/4/2011, instead of the...

Best: Starcraft (entire series) Doom2 Nethack X-Com Mario Kart Final Fantasy series. Worst: Don't hate.

Hi all, I currently have a database that I use to push out reports in the form of pivotcharts. I have a main form that has the ability to filter my data via a subform in pivotchart view. What I have been doing is export these filtered charts as pictures and building reports that way...

I have a quick and dirty way of building reports by exporting charts as jpegs and inserting them into powerpoint presentations. Is there a way I can just export the picture right into a specific slide in a powerpoint template? -Z

It is on a network drive, but our IT department is not the worlds most reliable and we've had trouble with data loss before.

Hi all is there a way that I can configure myfront end to make a backup of the backend everytime it closes?

Only one person would answer the questions in the template. Any additional comments might be made by another person, but it would be a separate email and easy to ID who said what. Much simpler to see who wrote what where in outlook vs access.

Yes. It is set up so that I and other consultants can add or edit records. I don't track the changes because there is only a small number of us, and there are controls to prevent accidental deletion etc.

Agreed, anything web-based is too complex. IT dept wont give me any server space to play with.

It isn't really, was thinking there might be easy way of tracking who logs into my database and records which chnages they make.

Hi all, I'm looking for ideas on how to corrdinate follow-ups for incident reports. What we have here now is a paper based incident report that gets sent to me with investigation notes attached to it. I input a summary of each one and use records to push-out data. Due to legal...

SELECT Risk_Data.[Near Miss], Sum(IIf(Risk_Data![Near Miss]="Near Miss",1,0)) AS totmisses, Count(IIf(Risk_Data![Near Miss]="Actual Event",1,0)) AS totact, [totmisses]/[totact] AS ratio FROM Group By Risk_Data.[Near Miss]; Now I'm getting a syntax error in FROM clause.

Maybe this will explain it a bit better. I have a pivotable that shows me the counts of records that fall under a few degrees on injury. None, N/A, Slight etc. I want to, on a pivotchart, show a line graph that displays serious, moderate, and grand total. I can't seem to find a way to get...

Hi all, Im creating a series of charts to shows trends over time. I would like to include a "grand total" of records series to go in my line chart, and I can't seem to find a way to include it. All I can get is the individual column fields. If I leave the column fields blank, I can...

Oh, I see thanks Here you go: SELECT Risk_Data.[Near Miss], Sum(IIf([Risk_Data]![Near Miss]="Near Miss",1,0)) AS totmisses, Sum(IIf([Risk_Data]![Near Miss]="Actual Event",1,0)) AS totact, [totmisses]/[totact] AS ratio FROM Risk_Data; Im still getting the error "You tried to execute a...

I don't use SQL, I'm just trying to do it in a design view query

Tried this idea. I keep getting the same error I did before. "You tried to execute a query that does not include the specified expression "Near Miss" as a part of an aggregate function" -Z

Yea sorry, I meant divided by.

Hi there, I have a field in a table that only has 2 possibilities: Near Miss or Actual Event. How can I create a ratio of one to the other, i.e. count the number of Actual Events by the number of near misses? -Matt

No dice, back to the drawing board.