Search results

OK thanks for the explanation. To address the multiple checkbox's I would suggest that your relationships and Data Input Form would look something like that shown in the attached. Not knowing enough about your process I have just made a guess at some field names.

Hi Can you explain the purpose of your database? The multiple checkbox's is not the normal way of doing things.

Hi Your CustomerT table has a field called "ID" and is an Autonumerber but you have not set this as the PK? The "ID" field should be renamed to CustomerID You should then add a new field named "CustomerID" to the table "OrderT" and this should be a Number data Type - Long Integer. You should...

I must agree with Gasman's suggested method.

One table for your process is pointless. Why did you not continue with the example of the normalised tables given?

Hi Well for a start you cannot have "one table containing approximately 540 fields". The limit is 255 fields for each Table. Can you give us an example of the data for each of the 4 suggested tables?

Are you trying to Export just the records that contain the text "Watch" ? Please explain.

The following process's look OK:- 1. PurchasesT, PurchasedetailsT, Suppliers 2. CustomersT, OrdersT, OrderdetailsT Not really understanding your process using all of the other tables. Can you explain?

Can you upload your latest version?

1 Person can have 1 or more Associates. Your query will show repeating Person details for every Associate. When you create a Report based on the query you have an option to Group by. In this case Group by Person. The Person details are placed in the GroupBy Header and the Associate details...

The query was used to create the Report

Hi I think it should be as follows:- =DCount("[IDDuty]","[tblDuties]","[DutyDate] = #" & Format([DutyDate].[Value],"mm/dd/yyyy") & "#")

The idea is that you make an effort to create the Forms as shown in the example screenshots.

OK so instead of having to manually enter the freight charge you can automate this by using an IIf statement.

Hi You do not use a query to display data that has field repetition. See the Report in the attached.

Hi Adam If you have a field in the related table with the Memo Fields which Uniquely identifies your Customer, then you can run 1 Update Query to insert CustomerID's for all records.

Hi You should have your Relationships between tables set out as shown below. This might need changing depending on further details of your process. Also, when you do your data input you would use a Main Form for your Customer, a Subform for the related Order Date details and a further related...

Hi Your Freight Charges are as shown below/ How do you determine how much to charge for Freight Charges? Freight Charges ₹ 3,000.00 ₹ 6,500.00 ₹ 7,000.00 ₹ 8,500.00 ₹ 9,000.00 ₹ 10,000.00 ₹ 10,500.00 ₹ 11,500.00 ₹ 12,500.00 ₹ 12,000.00

Hi You need to study the following example by Allen Browne. Stock On Hand

Looks like we may be flogging a dead horse with this one Larry.