I was not aware of the "NotInList" event, and have scratched the query that I mentioned before. I have tried finding the code example through Access HELP,...

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

Hi everyone, I've been trying to figure out how to do this query. I have a table and let's say it has three fields: site name, type of measurement,...

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

When I use the command button wizard to create any command like "save" or "new record", I get the following error. " The expression On Click you entered as the...

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

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

MASTER Table: CHARGES Fields: ChargesKey, ChargesDate Data: Row1 = 1, 05/25/2004 DETAIL Table: SERVICES Fields: ServicesKey, ChargesKey, ServicesDate,...

Please help me. I have a table with fields Salesman, Customer, Comparison(% of sales volume compared to last quarter). I would like a query that gives the...

Hello My time clock database uses "short time" format for calculating total hours worked, etc. The problem I have is that there is a field called which is a...

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

I have a table with 2 date fields startdate and enddate. They vaules are long int in yyyymmdd format. I want to check for any overlap between records. Eg if...

I tried the previous code, it produced an error. Looking at it, I think would calculate the sum of the yield. I need the cumulative percent yield. I have...

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

Yes the month is a result of a crosstab query. In fact its a row heading with an alias - Month: Month(). I have right clicked on the column in the crosstab...

I inherited a database and need to make some changes to some queries. The table and field names are crazy (include spaces, etc.), but I have nothing to do with...

I have two fields which is a contact number and which is Cell, Home... I have a report where I want to list each person's home number and cell number but I...

I have a combobox with an event that adds a record if the 'id' doesn't exist. I try to requery the control (combobox) but I get an error 2118 saying I must...

I have a table that have a field that holds dates and i have name it as "Mera" , now i want to make a query to show me the products from that table in a...

Hi I really need some help on this one: I have one table containing tools to be maintained: There is a . The third field is the one that needs to calculate...