query from table to form

[peterjb44]

Hi All,

I've done a query with my equipment table for duplicates company names to get a number for my customer form for total number of equipment.

how can I get the number of duplicates for each company to be put into total number of equipment in my customer form?

thanks

peter

 

[John Big Booty]

You could use the DLookUp() function, our even bind you form to the query.

 

[peterjb44]

Hi John,

thanks for the reply,

I tried using dlookup but all I get is #name? in the field on the form

any ideas

thanks

peter

 

[jdraw]

Peterjb44,
Perhaps you could tell us more about your database and tables. Have you seen the FindDuplicates query?? see attached

 

[peterjb44]

Hi jdraw,

yes, I used that findduplicates query to get a number from my EquipmentT table for CompanyID (changing the criteria of the dups from >1 to >=1 so it showed all records)

I then wanted that number (number of dups) to go into my CustomerT table in my field named TotalNumberOfEquipment

I have a Company field in my CustomerT which is related (1 to many) to CompanyID in my EquipmentT

I made another form for ActiveCustomerF where TotalNumerOfEquipment is and I want number of dups to show

I have no idea how to do this

thanks

peter

 

[peterjb44]

Hi All

I still need help with this

thanks

peter

 

[peterjb44]

Hi all

i'm still stuck with this :banghead:

this is my query in sql view

how can I get NumberOfDups to go into NumberOfScales

SELECT First(EquipmentT.CompanyID) AS [CompanyID Field], Count(EquipmentT.CompanyID) AS NumberOfDups, CustomerT.NumberOfScales
FROM CustomerT INNER JOIN EquipmentT ON CustomerT.Company = EquipmentT.CompanyID
GROUP BY EquipmentT.CompanyID, CustomerT.NumberOfScales
HAVING (((Count(EquipmentT.CompanyID))>=1));

thanks

peter