Search results

Dear Kenhigg, Unfortunately it didn’t work. I would like to specify that CDCount_Per_Artist is the Query Name and CountOfCDs is the field from the query that gives me the result. So, what I want is to connect this field “CountOfCDs “ with an edit box on a form called Artists. Thank you...

Hello everybody, I created a query where it counts some rows and the WHERE Clause comes from an edit box on a form. I count the number of the Cd’s in a Table “TableA” Where Artist = Forms!FormA!Textbox_Artist. The Good News: The query works !! Every time the Form is active and I run...

I tried the solution with the functions (DCount, Dsum) and it worked perfectly. Thank you. :D

Thanx a lot, That was something I didn’t know. And it seems less complex than writing VBA. So for every edit box I have to write a different expression using these built in functions. Now I would like to ask you something else but relative with my previous question… In which...

Hello everybody, All is about a Music Database with CD Titles and Artists. I have one table with the name CDTitles. From this particular Table I produce several queries. Like, “Total CD Titles”, “Total money paid”, “Total Tracks”, etc. I intent to create a big number of queries and to...