I have a memo field with long text, but when queried it cuts it off and ruins my report. How can I get this to stop? I'm using Access 2003 Any help would be...

I have a Query set up to calculate a rating using 2 different columns ie:- Tbeaten Rating 0.5 120 6.75 93 10.0 80 15.0 60 Is there anyway that...

Hi! Im having trouble formulating and SQL Query, basically cause Im not very good at it.. I think it should be a standard, simple bit of SQL for someone who...

Thank You and I hope You Enjoy answer this Difficult Question I have form (Continuous) and I’m using filter to filter data : The date is like this: Dates ...

Hi, I have an Access 2003 database on a LAN shared network drive containing simple queries created using the design view. The problem is, they are SOOO slow!...

I am importing a text file from an external source where the customer name and ID appears in the same field, like "Premium Transport (99879)". Is there any way...

Hello, I've designed a select query which uses a parameter as matching criteria. This way the query will filter whatever parameter the user keys in. The...

I have a query that I used to see which orders are 7, 10 and 15 days old. What I need is to use business days I think I would use the DateAdd function but not...

I have a query that prompts for . On my form is a txb_Name textbox. and a cmdbutton that sets the forms recordsource to the query. When I click the command...

when i try to copy one access table's records to another table w/ the same format, i keep getting an error message: data entered is not compatible w/ the...

I created a query that was to use a sub forms value to update a field. When I open the sub form alone the query works correctly if I don't reference the main...

How do you go about adding or summing columns were some columns are empty (Null?)?

Hello, I am creating a crosstab query. The query works fine, however my value is coming up with too many ending zeros. For example, what i want is to see the...

I have 3 tables: 1. tblPatient (PatientID) as primary key 2. tblTherapy (PatientID) as foreign key 3. tblDays (numbered 1-100) PatientID as foreign key I have...

I removed the ExpenseAmount fields from all tables, forms, subforms and reports. I've replaced it with two fields: ExpenseQty and ExpenseUnitCost to be...

Hello all! In a form, i'm using DCount("","query1") to count the number of items in a query. Of course, it does not check for unique ID numbers, and will...

In a query I have to sum shipping weights for different items. customer | Item_1 | Item_2 |Item_n | Total_1-n | How can I get this done? Thanks!

No one answered my previous question. Probably I did not explain clearly what I need to do. I did a pilot study for an assessment survey and created query...

I need to sort a date field by month instead of the year. Basically, the year is a "don't care". I am trying to use the criteria in the query design for the...