As the subject says, I am trying to measure the distance in miles between two lattitude and longitute points. Anyone have a sample of the formula for this. I...

I have looked through the posts thoroughly, and couldn't find one that would help me to do what I want. If someone has answered this previously, my...

We have three nursing shifts a ward secretary unit assistant RN LPN Intern Extern This involves four different shifts 0700-1530 0900-1730 1500-2330 2300-0700

I have a number of check boxes in a query, I would like to dynamically alter which check box will be displayed by using a combo box in a form. I am having a...

I have been given a solution to an earlier post that I understand but can't get to work. Is the Select * From function used in Query Criteria box or elsewhere?...

With respect to my earlier post, I am trying to find the best way to dynamically alter the select list of a query. Any suggestions!! Cheers -- Regards Ashley...

How do I use criteria to show or not show a fiel, for example, I have an IIf function: IIf(!!="Text",(.)=True) I would only like to show this field when the...

In my query there are a number of Check Box Fields. I would like to be able to filter out all the other check boxes when a check box is selected from a combo...

I am looking to use a value entered into a form in a text box by the user, that uses that value for query Criteria (Enter Parameter Value:). This query will...

Can't help but try posting in Report forum aswell. -- Regards Ashley Smart "Raj" wrote: Dear ALL,

In the attached database i need aquery to list products suplied by suplier s1 and suplier s2 . The list should contain p3 , p4 only. I tried but get p1 , p3...

I have a 'fair' amount of experience with access, very little with SQL Here's my challenge: I want to enter in a StartDate and EndDate for an order, Say...

Is there a way to store groups of queries in a folder. If I have 50 queries, it is hard to find certain ones even if I name them as specific as...

Hi all, I have this long query that extract datas from 12 tables, in that main query there are 8 subqueries, it work fine with pass-thru, but now this query...

I've been trying the examples discussed in this forum, but no success. There are two tables: table (tbl_Expense) - ExpensePayee, CheckStatus, Submit Date...

Hi How do I insert a string/integer into a table using a value obtained from a form. I seem to get a type conversion failure for some reason. I've checked the...

Hi All! I have seen lots of posts here on Julian Dates, but it would take me days looking through everything to potentially find my issue. I need to convert a...

getting error "compile error . in query expression" on a simple query using a linked table from db2. Funny thing is the query works in another mdb. Also...

table: users columns: owner, admin, user Query: create a fourth column called type when, admin = 'y' insert a "3" owner = 'y' insert a "2" neither owner or...

Is there a way to query a table like this and get a return of only the latest date for all distinct names in column A? Column A ...