Search results

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.

Hi What does the field "Regi No" relate to? Is this the Truck registration Number?

Hi Lauren Can you upload a zipped copy of your database?

Hi The Forms you need to create based on the suggested Relationship diagram are as follows. The Main Form based on PersonDetails with a Subform based on the Associations table.

I can say that there is a 1 to Many relationship between tblAgencyNames and tblPayroll and both PK and FK are set as ShortText which does not conform to normal practice. The relationship between tblPayroll and tblEmployeeNames is 1 to 1 and yet again the Keys are set as Short text. It is very...

If you are not willing to give us a copy of the assignment set by your Tutor then we are just stabbing in the dark.

Are you able to upload a PDF of the actual assignment?

Hi You can have the following relationship between these tables, but we do not know what your business process is. With this relationship you can create a Form as shown in the attached screenshot. I had to run a few update queries to get the correct values in the Payroll table for Employee...

Hi Welcome to the Forum Can you upload a copy of the database?

Hi Karmvir Your table design should be on the lines of that shown in the attached screenshot.

Hi Do Farmers call you to place Orders for Items which you then Dispatch Please explain your process in more detail.

Hi Are you able to upload a copy of the database?