Recent content by jlundbe2

Anyone have any ideas? I am stumped.

Yes, in laymans terms that is correct. I am trying to pull all contracts whose greatest advertising date is less than today and do not have a billing date. The payment terms are the same for all contract - once all advertisements are ran and confirmed, there is a yes/no check box on each line...

Hello everyone! I am currently building a system to track advertising in a newspaper. I have the following tables (that relate to this question): tblContracts, tblOrder. There are related by ContractID. The order has an advertising date for each line item... as such, one contract can have an...

Hello! I am working on an invoicing and receivables system and have one invoice report that is generated from one query (qryInvoiceMain). Now, the query is generated based on a control on a form. The issue arises as the criteria can be either from one form or another, only one of which is open...

Hey! Looks like I figured it out. The combobox format did not match the query format for that field (short date), Live and learn I guess.

So, I went ahead and changed the fields with identical names so that they are no longer the same and get the same issue. This database is very driven off of this date so I am not really sure where to start to resolve this issue. I will try remaking the query and seeing if that does the trick...

Thanks for the response. I can also provide additional code if necessary. SELECT tblCustomers.ClientName, tblContracts.ContractID, tblContracts.ContractDescription, tblOrder.ContractedIssueDate, tblItems.ItemDescription, tblOrder.AdRunConfirmation, tblContracts.TearsheetsRequired...

Hey everyone! I am stuck on an issue with my db. I am trying to run a query with data from multiple tables based on a date selection in a combobox. When entering the date on the criteria design (#9/16/2008# for example) the query runs fine. However when trying to run the same query with the...

Mailman, Thanks for the prompt reply. I have to run off to a quick meeting but wanted to let you know that your solution for the status worked. I will take a look at the where clauses this afternoon! Jason Thanks for the code suggestion as well. I am new to the forum.

Hey! So, I am having an issue getting a sub form to filter based on selections in a few combo boxes. The issue I run into is when trying to sort by a defined value for "year" and one of the multiple items of status, i.e. "<All Open>". The filter for "<All Open>" returns the incorrect values...