Search results

Okay, thanks for the help! I'll focus on reading that site and looking up more information on parameter queries.

So, not good? If that's not what you meant I can try again.. I can pull the total data together, I just don't know how to structure the parameters/criteria to get specific Evaluated Samples based off of user input. Thank you for the link to that site, I'll look over all of that information...

I attached a small excel spreadsheet showing how the data is compiled and how I'd like it to be grouped in a summary report. I hope this is what you're asking for, if not, I'll try again!

When adding ancillary fields do you just add the FK from that table, or do you need the PK from the original table to be included as well?

As in just give you examples of what the data might be or a picture or a form? Or something else entirely?

Thank you, I should have clarified a bit more in my original post because my data is more spread out than just a master table and a secondary test table. Here are my tables and the fields from those tables I'd want to include in a summary report: Table / Fields tblEvaluatedSample /...

Hi everyone, I'm having difficulty coming up with a way to create a summary report for a specific criteria. My database tracks test samples that a lab evaluates at different time intervals which are not always the same; some samples could be evaluated at different weeks or some can be evaluated...

Thank you for all of that information! I will definitely be taking a look through all of that!

It's starting to make more sense, so thank you very much for that! I think the biggest thing I got hung up on was the particular use of the lookup fields. Before, I didn't realize it was incorrect to have the lookup in the actual table, but your comment about it being encouraged for forms has me...

No, thank you. That's exactly what I was thinking as well. I am trying to normalize the best I can but I have had zero formal training on the subject. I've been trying to do my research and it sounds like I need to re-structure everything, exactly like you said. I just get hung up when thinking...

This is sort of a cross-post to an original problem of mine here: http://www.access-programmers.co.uk/forums/showthread.php?t=276943 plog was helpful and showed me what was going wrong in the database but I am unsure of how to really correct that (and I don't like to pester anyone with question...

Thank you. A few more questions though - when I'm looking at tblSample and at the panelist values in that table, do you mean that it is displaying a record based on every single panelist selected for each record? As in, since there were 5 selected for Request Number 1, and 5 selected for Request...

Would you mind elaborating a bit further? I know my greenness to this program is showing, but I didn't realize I had based the form off of a query? When I first created the form I thought that just adding existing fields from the field list to the form would mean that any data entered into that...

Ah! Sorry about that! Hope it works this time!

Here's the database. I have several tables that use each other but the central (main) table that stores the new information is tblSample. The one and only form I have is frmCaseOverview and that is where it is showing that I have 90 records, while when I check tblSample it isn't anywhere near...

Yes I can, I'll try to strip it and zip it shortly. Thank you for taking the time to check it out.

The record source is from the table. I don't have any queries just yet (still working and learning about that part).

Hi everyone, I'm still quite new to using Access but I have a small database that I manage and the other day I realized that I have 90 records for my one and only form; however, there are only 19 records when I check the table. I really have no idea how or where to check to correct this error...

Thanks, that looks like it should do the trick!

I guess I misspoke. It's not so much a "random" number as it's assigned to the person's initials. For example, Person A is always 487, while Person B is always 928. Sorry for the confusion, but thanks for the input!