Search results

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...

I have 2 combo boxes on a datasheet. combo 2 is depedent on comboxbox 1. But when i work on futhter and click other occurenses, the values change (because of the query looking at the first combobox) this is very annoying. can someone pleeeeease help, ive been trying for 2 days now thanks Joost

please help, its urgent!!!!

please help, its urgent!!!!

i have the same problem. is there a way aroud it ? i have 2 combo boxes on a datasheet. combo 2 is depedent on comboxbox 1. But when i work on futhter and click other occurenses, the values change (because of the query looking at the first combobox) this is very annoying. can someone...

How do i call a existing query and use its fields. i have the following Dim cnn As ADODB.Connection Dim rs As New ADODB.Recordset Set cnn = CurrentProject.Connection rs.Open "CountFollowups", cnn CountFollowups is my query. But i keep getting the error 3001. Arguments are of the wrong...