Thank you for your fast reply. Your tip helped me. I had to make one other change:
GROUP BY t2.sessionid, t2.personid
GROUP BY a.personid
because each person may have multiple entries for the same day.
Thank you so much for your advice, this site has been very useful to me for several years
freeskier
Last Activity: Sep 1 '11, 06:22 PM
Joined: Oct 17 '06
Location: New Jersey
-
Select date that a sum()'s threshold is met
I need to be able to tell the date of when a sum is met or exceeded. For example:
I would like to know the date for when sum(minutes) >= 400 for each personidCode:session(sessionid, personid, date, minutes) sessionid is PK, personid is FK, there will be multiple records for each personid
I've been trying something like this without success
...Code:SELECT min(a.dated), a.personid, thesum FROM
-
How to import denormalized CSV into relational form
How can I import a denormalized CSV file into Access and maintain relational integrity?
for example:
csv(fname, lname, workphone, fax)
person(personid , fname, lname)
workerinfo(pers onid, workphone, fax)
I have tried using a simple INSERT INTO but this does not keep the foreign key in workerinfo.
I would like to do this within VBA so that I can make it a macro because... -
Help inserting record to PG with MS Access frontend
Hello,
Sorry for the newb question; I've spent a good amount of time trying to figure this out. I am fairly new to the Postgre world. I am currently in the process of upsizing several MS Access apps to a single PostgreSQL system; I will continue to use Access as the frontend. I have duplicated the table structure in Postgre and have successfully connected Access as a frontend to view data.
I am having trouble inserting... -
Thank you, this works very nicely for days of the week.
However, StartTime does not group so easily. For example, a StartTime may begin at 10:15 or 10:07. I would like to get a count of all StartTimes between the times of 10:00-11:00...Leave a comment:
-
sorry it was a typo on my part...Leave a comment:
-
This gives me "You tried to execute a query that does not include the specified expression "Dated" as part of an aggregate function"...Leave a comment:
-
How to query time range and day of the week?
I have table Session (ID, StartTime, EndTime, Date)
How do I query this data to show a count during certain times?
For example:
StartTime Between Count
8:00-8:59 2
9:00-9:59 3
10:00-10:59 0
I want to do the same for days of the week (M, T, W, etc.)
Sorry if this has been asked before but I can't find... -
thanks, that got me looking at the problem in the right way....Leave a comment:
-
what event is triggered when assigning a value to combobox?
What event is triggered when a combobox is assigned a value?
For example, what event is triggered for the combobox in this code:
Code:Dim intMenu As Integer intMenu = 2 Forms!frmForm!cboCombo = intMenu -
thanks so much! yet another MS Access idiosyncrasy......Leave a comment:
-
when i enter that into the textbox it is automatically changed to read
=[Forms]![frmCriteria]![cboCombo].[Column](1)...Leave a comment:
-
how to reference combobox's column property from textbox on a report
hello,
i have a form that opens for a report. the user selects criteria from combo boxes, clicks ok, the form is hidden, and that criteria is applied to the recordset of a report that opens. i would like the value of one of the combobox to appear in the report title.
i have been trying in a text box:
=[Forms]![frmCriteria]![cboCombo]
and this works fine. however, i would like the value of the second column and... -
having trouble on form_open: set value of two listboxes
hello,
i have a button that opens a form and sets two list box values based on a value from a combobox in an open form. one list box's value are dependent on the others; there is a many-to-one relationship. so for example:
cboSchool on formA contains a value. i press a button, formB opens and the button runs this code setting the two list boxes to appropriate values.
...Code:DoCmd.OpenForm stDocName,
-
i don't see that link on the page or that subject in the table of contents but if you say it's got what i need i'll go purchase tomorrow....Leave a comment:
-
best way to gain exclusive access in multi-user environment
hello,
i have a split ms access database with front ends distributed to several users. it is a real pain to have to wait until everyone signs off for the day to make design changes to the backend. i was wondering what techniques people have used to gain exclusive access to the backend when tables, modules, etc. need to be saved/edited. i have seen several clever methods but am not enamored with any yet.
thanks in advance... -
that is very clever, thanks for the post...Leave a comment:
-
freeskier replied to Where should I SetFocus to resolve "can't disable a control when it has the focus"in Accessthis method doesn't shade disabled objects gray. i got a lot of feedback like "why can't i click on the text box"...Leave a comment:
-
parameter queries will not show either...Leave a comment:
-
freeskier replied to Where should I SetFocus to resolve "can't disable a control when it has the focus"in Accessis that really the best workaround? to create an empty option group and set borderstyle = transparent?...Leave a comment:
No activity results to display
Leave a comment: