Search results

Joe, I don't suppose you are just able to attach a zipped copy of your table? That way, we might have a clearer understanding of what could be happening.

I haven't tried this, but perhaps you could use your first query inside a new query to count the results of your first query? i.e. query 1 shows 1000 records, but counts 3000. However, query 1 is now in query 2, and therefore, in theory, count should now be 1000 in query 2's output. Edit: What...

It doesn't look like there are any new records added. Rather, it looks like that your query results just isn't showing what you want. If you mean something like this; Location P1 P2 P3 Status PN Group Name PrimaryKey1 GA A5568Z A7565 A1236 Out A1236 Alpha 3 GA A5568Z A7565 A1236 Out A7565...

Hello, I am not too sure if this is what you want (most likely it isn't...) but I'll give this a shot anyhows. From what it sounds like, you want to display the results of a query in the the order of which VendorNumber your form is currently on, and then, move onto the end (and then back to the...

lagbolt, thank you for your reply, and sorry for the delay in replying back. Indeed, as opposed to maybe using multiple queries to try and do what I initially seeked, having another table seems be make things a lot easier. All the data is just in one column/field as opposed to spread out over 10...

Hi all, sorry to bother you all, especially if this has already been answered, but I can't seem to find the solution to it. Assuming that what I've been doing has been correct that is. I have three (3) tables with the following fields (where PK is primary key); [tbl Ingred]: IngredID (PK)...