Recent content by New2Access_and_VBA

Thanks Brian thank you so much :)

Thanks Brian but can you please elaborate a little more?

Hi everyone, I have a question, my data and required results are clearly shown in attached excel file: what I want to do is to count "ABISTS__BANDWIDTH_16K" corresponding to PortNo "0" for PORTSITEINDEX "123" and then count "ABISTS__BANDWIDTH_64K" corresponding to PortNo "0" for PORTSITEINDEX...

Hi Poppa, You are awesome man! your suggestion worked perfectly, I am very grateful to you. You and dbDemo are the real Kings of Access. Gratitude:)

Hi, I am creating a union query and faced an error "Query must have atleast one destination field" I am writing this code SELECT FIELD6 FROM ImT2 UNION ALL SELECT FIELD7,FIELD8,FIELD9,FIELD10,FIELD11,FIELD12,FIELD13,FIELD14,FIELD15,FIELD16 FROM ImT3 ImT2 & ImT3 are two tables. I want to union...

the formula i wrote in the design view of query was Maximum([field6],[field7],[field8],[field9],[field10],[field11],[field12],[field13],[field14],[field15])

Hi, your given code is not working for my database. I have 11 fields(field6,field7,field8........,field16) in it, at some places it is working but not at all places. I have pasted the code in the module and saved it then went to design view of query and enter all 11 fields and wrote the formula...