Search results

"select * from tbl where odatsa= " & Format(Me.txtDate, "\#mm\/dd\/yyyy\#")) funny thing, it looks the same now, must have done something wrong :(

I'm still having problems with dates :( I can't write a code that would select all the records with the same date as is in a textbox set rs= currentdb.openrecordset ("SELECT * FROM tblOp WHERE odate = #" & me.tdate & "#") I tried a lot of variations (as I'm ashamed to admit I still can't...

i have a continues form that lists all my active items and I'd like to use it to quickly check if they have all the data inserted, ie entries in each separate table. it looks like this I perform a simple check on form load chk = DCount("[phID]", "preh", "[phbID] = " & Me.tID) where me.tid is...

TRANSFORM Count(opTbl.[ID]) AS ŠtetjeodID SELECT opTbl.[AnType], Count(opTbl.[ID]) AS [Vsota ID] FROM opTbl GROUP BY opTbl.[AnType] PIVOT opTbl.[bPart]; It works... I'll see if I can do more complex stuff with this.

Sorry for the flood of replies. Using this SELECT opTbl.bPart, opTbl.AnType, Avg(opTbl.OpTime) AS PovprečjeodOpTime, Count(opTbl.ID) AS ŠtetjeodID FROM opTbl GROUP BY opTbl.bPart, opTbl.AnType; I get the left result What do i have todo to get the right composition?

maybe some additional data table structure bPart - string - 25 possibilities here, want the query on how many times they appear opTime- duration, number (minutes) AnType - string, can be local or general (other options, but this will do for now) query bpart - how many times it is used...

I think a lot of my problems come from trying to make one big report that would have all the data i want and just be able to send it all together on a click I'll make a separate report for each thing and then go on to adding things together now. New problem My query SELECT OpTbl.bpart...

That works, but what is the best way to display it as a part of report? the other thing probably won't work as i'm getting run time error 2136

As part of the report I'd like to have a table that would list all different values in column in column A and the number of times they appear in the table in column B. I have a bit of a hard time how to populate the table the easiest way. I have all the values in a separate source table, so...

hm... now i got the draft Nothing really happend in reportview, same old graph, but when i went to printpreview i got an error. [Reports]![MonthlyReport]![tdat2] is not recognized and something about ole... I use tdat1 and tdat2fields on the report to filter the time period in query. If i...

i know... nothing happens

I'm adding a graph to report. Currently theres's nothing else there as i'm stuck with graph, just the date selector to limit the query. Query gathers ids, age and age groups. I want a a simple age distribution graph. I add graph in design view, select data (age groups from the query) and want to...

I guess it's that i dont know how to add the graph. I chose graph, chose ag-groups from the query. Set x-line as age groups, y line as count and get what you saw in video. i'm sure there's a stupid mistake hidden somewhere, just can't pinpoint it.

http://youtu.be/-TL_z8B9iWs

that's great. got my age groups sorted So i insert graph, set age groups on x axis and count-agegroups on y and... get some default east-west-north grapha about 300 times.

it does, but I'm notgetting far with it. First question would be how toperform grouping in age groups, either by decade or custom.

Anyne knows how to make a graph for age distribution? Something like this https://support.google.com/youtube/answer/1715072?hl=en ihav e a query that has all the ppl and their ages in it

I use textboxes to limit the time periods for report the defaults are set to first and last day of previous month I'd like to add a button that would set you a month back/forward, but I'm stuck on how to change values to correspond to first/last day ofprevious month this is my onload code

I'm using a textbox to write a msg. I write in slovenian language, so there are letters that are in that encoding. Textbox, and more or less everywhere in access, displayes and stores values as I type them. But when i use the txtbox as a source for mail textbody it's send with strange signs in...

Dim f As Object Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show Then Me.txtAttach = f.SelectedItems(1) End If End If