Replies

I think that your problem may be caused by using Left and Right on a numeric field.
Try the following functions
LEFT(FORMAT(Score,”00″),1)
RIGHT(FORMAT(Score,”00″),1)

I think that the format and input mask effect the way the number is displayed and edited on entry, but not the internal storage, which is why you get strange results

Hope that helps

Palm OS does not support a multi-day event.
What I do to get round this is to create the event as a daily recurring event in Outlook. You can then attach the note to the series and they should then be kept when syncing with the Palm.
I admit that I use DeskTopToGo to sync with Outlook rather than Palm’s own software, but I encountered the problem you mention and this fixed it

David

The only way that I know if is to have the calendar open in a second window
(Right click on the Calendar folder and select Open in a New Window)
Minimise all other windows and then right click on task bar and select Tile Windows Vertically

David

The two queries are as follows
SELECT tblJobs.Job, tblJobs.Customer
FROM tblJobs
WHERE (((tblJobs.Status)”5″));

and
SELECT tblCustomers.[Customer No], qryActiveJobs.Job
FROM tblCustomers LEFT JOIN qryActiveJobs ON tblCustomers.[Customer No] = qryActiveJobs.Customer
WHERE (((qryActiveJobs.Job) Is Null));

The Is Null will show only those records where the job number is missing, i.e. where there is a customer from the first table without any corresponding row in the table of active jobs.

I assume that you have a table of customers and a table of jobs, with the table of jobs having the customer number as one of the fields.
If that is the case you can create two queries
First query lists all jobs that are not complete (Status 5)
Create the second query that links the table of customers to this query of active jobs.
Set the link so that it includes all records from the Customer table and only those records from the Active Jobs Query where joined fields are equal.
Then set a criteria on the Job field of IS NULL, this will then list all Customers who do not appear in the list of customers with active jobs.
I hope that is clear

David

I would tackle this problem by creating the following
a) Query that listed all people who speak Dutch
Query that listed all people who speak English
Then create a query based on these two queries. Access will, by default, connect the two queries so that only those rows where the two entries are equal, ie people who speak both Dutch and English.
I have attached a modified version of Steve’s database.
I hope this is what you need

David

I think that a little more information is needed before I could offer any advice.
Can you outline the structure of the tables and the query he is using?

David