Search results for query: *

Hurrahhh! It worked. Thanks for saving me a bunch of work. accessgoat [ponytails2]

Thanks much. I tried it and it works. My next question is I need to do 4 types of update calculation queries like that. For example one type of update query will calculate the timings for 40 fields. I was wondering if there is an easier way to do this instead of writing 40 queries, one for...

Hi I have 3 tables linked by ID. I need to update Table 3 with the calculated value from Table 2. When I run the query though it asks me to enter parameter value for the fields in Table 2. This is my query: UPDATE tbl3 SET tbl3.[Ab1Days] = ((tbl2.SurgStDt)-(tbl2.Ab1Dt)) WHERE (tbl2.SurgStDt...

Hi Thanks for the response. Has anyone had conflicts with Access applications built on Windows XP, running on Windows 2000? Thanks svenk.

Thank you so much. Your answer just cleared a big hurdle for me. svenk.

Hi I have an Access 2000 application created on Windows XP. I need to distribute this to clients running different versions of Windows from 98 to XP. Do this raise any version compatibility issues? Are Access XP applications compatible with Windows 98 or 2000 or NT? Thank you svenk.

HI Both tables have identical fields. However only four of the fields from tblA2 (OrgID, MemberID, AdmitDate, PayDate) are displayed on the form. This is to help the user enter records into tblA2 with matching OrgID number from tblA2. The tblA1Data is empty and will be filled by the user. I...

Thanks. This is the query which forms the source for the form I am creating. SELECT tblA1Data.*, tblA2.OrgID, tblA2.MemberID, tblA2.AdmtDte, tblA2.PayDate FROM tblA1Data LEFT JOIN tblA2 ON tblA1Data.OrgID = tblA2.OrgID; I need to have the OrgID, MemberID, AdmitDate, PayDate displayed on the...

HI I have a form based on a query combining two tables with similar fields. The information from one table is displayed through uneditable textboxes to the user while another set of textboxes are provided for data entry to the user for entering data into the 2nd table. My problem is when I...

Hi! Thanks for the tip. Actually I already tried the Union query but it merges the Drugs 1 and 2 together in one column and the Drugtimings 1 and 2 together in one column whereas i want it to be in separate columns. I have tried different left and right join combinations but no luck...

Hi guys! I have been trying to combine 2 tables with one common field name ID# although some of the values in those field may not be common for both tables. Table 1 contains also Drug1, Drugtiming1. Table 2 contains Drug2 and Drugtiming2 inaddition to the ID#. Can anyone suggest a way to join...

I have received the same error message but when I tried to do a union query. The reason is that Access limits the number of columns to 255. I checked out the MSDN Knowledge Base and found a couple of articles on it (but it didnt help me). Anyway myysolution was to do an append query instead...

Sorry I wasnt more clear. The user can pick upto 10 Dates and Times corresponding to 10 Items on the form. I need to verify that these dates and times are valid dates and times. I dont have any table for this purpose since these dates and times can fall anywhere in a calendar year and even...

Hi! I need to check the validity of Start date and times entered by the user before I use them for calculation. There are a maximum of 10 fields for each (Start Date and Start Time). I dont want to write 20 queries for this purpose. Is there an easier way to do this? I would appreciate any...

Hi! I need to check the validity of Start date and times entered by the user before I use them for calculation. There are a maximum of 10 fields for each (Start Date and Start Time). I dont want to write 20 queries for this purpose. Is there an easier way to do this? I would appreciate any...