I have a table that contains just 4 fields and an ID - autonumber. tblHIST itemno actdate actqty actcost id 123 1020501 ...

I have a field in a SQL Sever table of data type datetime. I enter a time in this field by keying 8AM and tabing to the next field. When I try to query the...

I have several thousand SKU's that change up to a new SKU. Example Sku 12345 changes up to SKU 98765. My problem, is that I have an on-hand quantity of SKU...

Hi, I am opening a subform which basically writes to the same table as the form. What I want is I have a field in the form called DtRecd and one in...

Is there a way to have the captions of the field properties of a query to be blank? I am using access 97. Thanks, Tom

I have a query shown below: Date OpenedItems Feb '05 45 March '05 21 I want to make it read: Date OpenedItems Cum Feb '05 45...

I have an existing notes field that I want to add more information to it but when I use the update query it erases the information that is already in there and...

Help! I posted this two days ago and unfortunately received no response. I did modify it slightly based on my expected lookup results - sorry if that caused...

What do you mean by subquery? Read only results would be fine in this scenerio. I would like to create a chart (preferably a Pivot Chart) with the results of...

My corporate environment is Access 2000. I have established ODBC links to SQL Server 2000 views in Access. Occasionally my users are having issues with...

I have a simple Access 2003 subform, as a datasheet view, I simply want to display some of the details within the same cell but with line breaks...

I want to be able to put in a date range for my querie. Is that possible. Thanks David

I'm trying to execute a batch of T-SQL statements in an Access pass-through query. In short, the batch creates and populates a temporary table and ends with a...

I have 4 tables that I'm querying, and have the basic data that I need, I just can't figure out how to 'fine tune' to get the exact info into a report. I...

This is a simplified example of what is probably a simple SQL query, but my SQL skills are too weak... Customer table: CustomerID EmailAddress Orders...

I work for an engineering firm. Each engineer works on different projects each month. However, not all projects will have time spent on everymonth. Sometime,...

Need Help. How do I tie a macro executed from a button on a form to the current record I am looking at in that form? I have a form that shows all the fields...

I'm using Access 2000. This is a simplified version of what I have. Student Table Student ID Name Grade . . . . and so much more 1 Cindy ...

i did a iff ( if x value = x value,Y,N) then i tray to use"Y" like a criteria in the colum. When i run the qry i get the message "enter parameter value"