Hello, I would like some help please building a query that will return the numbers only contained in a field: Table "PurchaseOrder" has a "Memo" field that...

Hello, I am trying to create a query to calculate the flow time for each order, but not sure what the formula to use. The flow time is the difference between...

Hi. I am newish to Access and have a question. My friends familiar with Access don't know the answer to this one either. I feel like it is just on the tip...

Repeating my post to the Access Multiuser group in the hopes of eliciting a few more responses to this issue All, I recently split my first database...

I have a table with 4 fields and some duplicate values in Field1. Field2 has values, but no duplicates. Field3 and Field4 are null at this time. I want to...

I have some custom append queries wrapped inside a transaction. They execute just fine using the db.Execute, strSQL, dbFailOnError method. Problem is, after...

I need to make a crosstab query that has, as a column heading, the date of the beginning of the week in which the date value in the record falls. I know how...

I would like to set-up a query that will extract the date for January based on the Date field being between 1/1/2008 and 1/31/2008. This should be a...

I have text data in my table formated 11-11-11. I want to change the "-" to ":" so the result will be 11:11:11.

Hi, I try to converet this simple If...Then to a Case...When but get error mesaages. Anyone can help me to pinpoit my error? IF...THEN (which works) select...

All right. So i have several fields in this query. Here's my problem: if i remove the part about "alba" "natasha" and "yohannes" it includes everything. ...

When I run this query I get one nember for cases shipped. SELECT tblInvoiceHistALL., tblInvoiceHistALL. FROM tblInvoiceHistALL WHERE (((tblInvoiceHistALL.)...

woI am comparing amounts in tow fields:Billing Difference: IIf(,-), which gave a lots of empty fields and one field shows 0.00. My second step is to show...

I hae searched the forum tono avail, so I'll ask for help. I have a table which records events with status changes. The table uses an auto numbered primary...

if field1 is greater than zero and less than 1 than 1 otherwise 0 Whats the right way to write that expression?

Hello, MS ACCESS 2003 XPPro So I have this form with some fields that the user fills in by hand. They don't link back to a table or anything but some VBA...

I'm not even sure how to title this question... Table_1 holds values for DATE, PLACE, TYPE_ID, SIZE_ID, SHAPE_ID, and QUANTITY. Table_2 (lookup) holds...

Ok. I am working with a select queury and all I am trying to do is sum two numbers in a column together that share the same 'queue'. For some reason it's...

I have a column named PlannedStartDate that contains a date/time field (ex:2/29/2008 3:15:08 PM) in another column i want to to show what the date/time would...