Hi Tony, I woke up this morning thinking about how you probably (might) want your queries to be updatable. One method is putting the group by in the Where...

In a form, i have a command button with a code like below, which is making a sellection from a query (which represent the current state of a stock) to display...

Hi Bob, I have helped several people do similar; it is for sure doable and fairly straightforward.... but I would first like to know how you will be limiting...

I have a crosstabquery. The 8 column headings are weeknr based on DateDif. The value is the sum of Kg (double) The rowheadings are fields from the customer...

Hi all, I am trying to join two queries together, but the join is on a normal field in one query to a calculated field in another. The join is working fine,...

I am trying to run this pass-through insert query but everytime I try I keep getting ODBC connection Failed and then when I click OK I get an Oracle error ...

Just like in a checkbook, I want to create a query that contains 1 field plus 1 expression: - Expenses (field) - Remaining Balance (expression) Naturally, I...

Hi all, I am trying to join two queries together, but the join is on a normal field in one query to a calculated field in another. The join is working fine,...

I need to do a tabelar report with header and footer. For every change of each one of 2 of the parameters from the header, it is requested a new instance of...

Hi, I have a table of 2004 sales and need to create a report of weekly sales for the year. The data is stored in a table called 2004Sales which is constantly...

I'm not sure I'm posting this in the right spot, but here goes...I would like to design something to remind users to run a certain report every thirty days. ...

Hello I have a form who have 10 fields from TABLE1 that after make calculations with them i build the field M1 from TABLE2 The event that fires those...

"fredg" wrote in message ... On Sat, 22 May 2004 10:59:00 -0400, C & J Jones...

Although I can view, I can not post in most newsgroups. Please help. tia, al

Now that my former post has gone through, when I am in other newsgroups using Outlook Express, I can view all ngs I visit. But I can't post in ANY of...

I have a query attached to a form. On that form I have a combo box w/ a 'notinlist' event that is supposed to add a record if the 'id' is not in the list. I...

Hi, CurrentProject.Connection.Execute "DROP PROCEDURE toto" will drop the procedure (not procedute, as in my first message, sorry for the typo).

Hi if I try saving the flowwing query access 2k crashes: SELECT CAPTIONS.Key, CAPTIONS.Translation FROM CAPTIONS, (SELECT ALanguage.ActiveLanguage AS...

Hi I have one important question: It so so easy to make powerful and fast queries on an access db, but how can I write data more easily in a certain bd...

Andy, I wonder if you have figured out how to change query selection criteria using vb. I cannot use the form idea that Allen B. have suggested because I...