Second Set Of Eyes Please?
May 10, 2006
good morning all,
I am currently going buggy :eek: in trying to get a piece of SQL code to work.
To me this seems pretty straight forward but no matter how I code this, I am getting no results. The date range on the form is #1/1/1900# and Now(). I've also substituted #5/10/2006# for Now() with no luck. There is valid data so I know that's not it. The problem seems to be with the criteria because once I remove that I get results, but I'll be darned if I can see what I'm doing wrong.
SELECT tblUTD.[Event Id]
FROM tblUTD
WHERE (((tblUTD.[Start Occurrence]) Between [Forms]![filter_form]![Txt_OccurenceDate_Start] And [Forms]![filter_form]![Txt_OccurenceDate_end]));
the tblUTD.[Start Occurrence]) field is defined as a date in the table.
The two form input fields are defined as short dates. Anyone see anything
wrong here??
TIA,
Tim
View Replies
Oct 17, 2007
I have been working on this database for several months now - in between all of the other jobs I am responsible for - using what I've learned from this forum, from the 'Access 2002 Bible', and lots of hit-and-miss, restarts and frustration. I may have OVER normalized . . .
I'm running into trouble creating the reports I want, and have now learned enough to think I may need to create a 'fresh' database with what I know now. Before I do, I would appreciate some experienced eyes that will see what mistakes I have made and how I can improve this database before copying mistakes and taking it further.
Background: I was asked to create a database to replace an outdated and undocumented dBase program to keep track of our cost of goods and recipe base. We manufacture waste water treatment chemicals, primarily for municipalities. Each of our products is a recipe containing various raw materials in differing amounts. One concern I have is that some of our end-product recipes are also raw materials used to create other products. I may be able to enter each one as both an ingredient and a finished product as each will be assigned a different primary key.
We need to be able to create reports that tell us how much a specific recipe costs to make in various quantities, a printed 'recipe' listing each ingredient, amount, product type, etc. as well report groups on each product type. I plan to change the raw materials cost every time a new shipment of raw materials comes in using an update query.
Thank you in advance for any direction you can give. I am an Access newbie, but I am willing to do the homework!
And if I am very lucky, maybe Doc will give it a look?!
Pam
View 8 Replies
View Related
