Search results

Hello aqif Very kind of you to take the trouble to sort me out. At the moment I have a query with ther following two fields. The first field is: TypeOfMedia: Left([MediaID],1) Groupd By The second field is: CountOfmediaid: Count(*) Expression This works OK and give me the following result...

I am trying to place three fields on a form that will give me a running total of the three type of product, namely: D3456 C6457 G2345 Where D stands for DVD; C stands for CD and G stands for Game. I can get the correct count using only the two fields I have mentioned before, but when I add...

I have a query with 2 fields. The first is called:TypeOfMedia: Left([MediaID],1) Grouped BY Result C D G The second is called: CountOfProducts: Count(*) Expression Result: 1 15 1 This query has counted the number of CDs, DVDs and Games entered. The first letter of the MediaID fields...

You sir, are a gentleman. I have added the following code so that the same rationale applies when a user leaves out the first name. trim([ctitle] & " " & trim([cfame] & " " & [clname])) Can't thank you enough for your help, and may I wish you a peaceful and Access free Easter!!!

Many thanks for taking the trouble over my problem. I forgot to mention that the text is populated into a List Box. I had already tried the Nz() and Trin() functions. None of them work. Were you able to see the zipped file I sent. This has been extracted from the main db because of Data...

Hello All I have a form that allows the user to enter the following data about a teacher. These are the fields: CTitle Cfname Clname Some users wish to leave out the title, but when they do so, there is a gap where the title would reside. How do you close up that gap? Also applies to the...