Recent content by melonye

I have not yet done fields/rows for individual months as I don't know how I will populate them further. Right now I have row Duration which I populate with lookup wizard in the design view with monthly, weekly, quarterly, etc. I don't know what to do after that. Duration: Monthly Monthly...

Also, if month selected they will always be Jan,Feb,Mar. If quarterly then Apr, and so on. This does not change if two clients have duration as quarterly they both will show Apr,Jul etc and whether it is filed or paid. I figured if I understand monthly, then I can work on others. Don't want...

Oh dear ! Sorry about the confusion.:D I have a table client and another table with list of services then these services have their own tables like payroll, vat returns and so on. Each service like payroll table or vat returns and so on have a column callled duration which I can either make a...

I don't want to just display the data. That did not work for me or I don't know how to do it I have a table client with company name, tax no etc and another table vatreturns .I have drop box with options monthly In vat returns and when it is selected, rows with jan to dec is to be displayed so...

Oh, Thanks I will try that.

Hi all, I have forgotten quite a bit of Access. I am creating a DB for a practice where they only want to track file status and fee status of all their services. Suppose, they have a payroll table- fields are payroll duration, file status and fee status. Now, payroll duration has look up...

Hi, My name is Melonye and I am residing in Dublin. I am doing my HD in computing and we are learning MS Access. I would not say I am a pro but would not call myself a beginner either :cool: I had done access long back and I have mostly worked on Oracle then sql in college, I have never worked...