Recent content by Pmetro

FANTASTIC.....thanks so much for your assistance. I went through your queries and I found what I was missing. I created a relationship...then added the description to the query and it worked like a charm.

The tables in my db are linked tables from another db.....is that a concern when creating relationships?

I opened up to review your relationships. I don't have the MSys relationship stuff.....what is that? I created the relationship around the DataEntry only.

I would like to thank everyone again for their assistance with this. The db is up and running without MVFs. My manager asked why didn't I allow for them and I then explained the difficulties of queries. I followed Arnelgp simple design and created other queries and reports. My lastest question...

Thanks for the article. I wish I had read that a few days prior. It would have prevented a lot of frustration during my query testing.

Thanks for the db. I used it as a template and created one similar.

Thanks to everyone for their advice. I agree, the MVF is simple to use ....just plug in 01-02-03,05-08-35,19-10-35 etc... But when it came to a query to identify for example how my ##-05-## defects there were....I couldn't make it work easily. Correct me if I misinterpreted, so each defect code...

Good day all. I am wanting to create a db and I have had difficulties with the queries, because of the MVF in my test db. This is the scenario: I am to evaluate the condition of a piece of equipment, if it is good, no problem. But, if it is bad, I am to assign defect codes for each defect. Each...

Good morning or afternoon, depending on your location. I am new to this site and very new to MS Access. I joined this site as a resource of information and to improve my capabilities with MS Access.