Recent content by ice-9

thank you for replying Victor. I tried this one, but when i select the store_key it will still give all the stores in the result. When i remove store_key it will show the correct amount, but with no store_key... n2

OK, i have 1 table which contains salesfacts. There are 2 things I want: 1. Show the revenue and store number. 2. Show only the store with the lowest revenue. the first one is simple: Select store_key, sum(dollar_sales) from SALES_FACT group by store_key; This shows the revenue per store...

Can someone give me a good clear example of column prompts. Is it a prompt where the user can select the columns he wants to see? or else? Thanks in advance. ice

Hi, I have a question about query's. I am writing a document about business intelligence, and i came across the following elements: can someone give me an example of what is mend here? Thank you. iCe-9

please help i have a few days to duedate please help

HI i never needed help this much. i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird. I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell...

strSQL = ("SELECT onespace2(MeetingMinutes!MinutesID, '.' ) & " - " & [MinutesTitle] AS Item, MeetingMinutes.MeetingCode, Minutes.*, MeetingMinutes.MinutesCode, MeetingMinutes.MinutesID ") strSQL = strSQL & ("FROM Minutes INNER JOIN MeetingMinutes ON Minutes.MinutesCode =...

made a work around with popups.. damn im behid sceduel

whats happening is that i have cascading comboboxes on a datasheet. The controlsource of combobox 2 changes when combobox 1 changes value. This will result in a list change. But because you have a view of multiple records, the list changes for all the records, eliminating those values that are...

to difficult or not possible maybe ?

why wont anyone help

kick kick kick

please help,

i am affraid its a more expert question. its a datasheet form, as the topic title reveals. Im not realy sure if its the query that is te problem, area: SELECT Area.AreaCode, Area.AreaName, Area.AreaDiscription FROM Area; subjects: SELECT Subjects.SubjectCode, Subjects.SubjectName...

I can get the lists corect, only the displays is wrong, because of the change of list. Let me explain by picture: The area is determining the information in de subjectcombobox when i add a new record, and select a diffrent area, the subjectlistbox changes, but it changes over the whole sheet...