I have two tables; "Orders" & "Cancellations". The Orders table contains the following orders: part# loc 1 a 3 b 1 a 5 d The...

My technical manager is asking me a tabelar report with header and footer. For every change of each one of 2 of the parameters from rhe header, he wants a new...

I am running an append query and get this error: You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to...

I have a table of payments made by clients. It includes the fields: PaymentID ClientID DateRec AmtRec I was trying to use the Last function on the Total row...

tblInventory + tblInvoiceDetail I would like to collect sales history for analysys. I'd like sales for various periods (based on tbleInvoiceDetail.date) for...

Returning the left portion of a string in a query. i.e. if the string is: " What combination of functions would return only "anybody" or...

Dear all, I have this problem with the queries that don't seem the work anymore. In the query I use selecion criteria in several fields (example Like !! )....

I have a bunch of Parameter Queries that I have been calling with VBA. But now I am converting my code to use ADO recordsets. How would I change my old code...

I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to...

Hi, I'm trying to highlight a cost field if there is a change in the field value. eg if previous cost was $2.20 for the last 9 weeks and this order comes in at...

Hello, The dates in a SQL2k table are stored as nvarchar (yyymmdd). When displayed, the CAST (DATE_FIELD AS datetime) syntax is used. Because of the...

I am trying to create a form for a union query that allows me to edit the data in either of the tables used for the query, but I can't understand why with...

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

I have a table (table 1) with many date ranges in them for grouping by age ie start, end dates for group 1, start end dates for group 2 etc. I have another...

Hi there, How do i accomplish a count of visits by the date "XXX" was visited using a query? regards Norman

I currently run w2000 professional on my other pc. When I shutdown my pc is won't shutdown automatically, I now have to manually press the on off button. Any...

I have a query by form whereby the form has a Command Button to run a module which checks to see if the query has records. If the record count is 0 it opens...

I have been attempting to total some fields from individual records in a table and then display the result in a text box but have been unable to do so. I...

Hi, group. I need your help. I have two tables, one is tblTutor with the names and their available times, the other one is tblTutee with the names and the...

Hi All, I have a database with 3 tables: TBL_Persons; TBL_Absence; TBL_AbsenceReasons. When a person is absent I put a record in the TBL_Absence with the...