Recent content by mkb69

Thanks Brian. I do have the rights to do anything I need to do to get them the data they need. Craig's solution got us close enough to what they wanted to see and I was able to weed out what they didnt want to see after the query was run. I have however thrown your idea at them as an...

Thanks Craig! I think that will get me past the deadline. Brian I will work with your suggestion later this afternoon so as to give a more accurate report. They have told me close is good for what they want to see today. Obviously I will need to fix it so as I dont have this problem next time...

i looked at DateValue that but cannot figure out how to write the expression as to convert all of the different dates. Code is not my strong point obviously. Can you walk me through it? Thanks for the help! Wow Craig what you said makes sense which is what I suggested they enter in the first...

I have a database with fields for dates but formatted in "text" so as to allow for partial input of a date. (ie. 12/00/1990 or 00/00/2001) I now need to extract data prior to an exact date and after an exact date. Due to the text format, I am assuming, I cannot create a query to do this. I have...

No it does not show at all if no data has been entered. If there is data then it will show the subform.

any other ideas? Nexshark is my boss (just so you know I haven't hijacked his thread);) Changing from checkbox to text does not take care of my problem since I am still not entreing data to that table until later. What I want to do is print the report with the subreport (whether data is null...

Still can't get the sub-report to show. I am still in need of some guidance as to how I can get the sub-report to display even without data. I am pretty sure my problem probably lies in my subform and that if I could get the "ContractID" to write itself to my checklist table this report would...

It sounds like you might have it in your report header. Move it to your page header.

I am trying to create a report from 5 tables. 3 of those tables will have data initially entered with the other 2 tables (checklists) will be entered at a later time. I created 2 different queries 1 from the 3 tables with data and then the other from the 2 checklists. My main report is from the...

I have 5 tables for which I am trying to create one data entry form. Table 1 (client info) is set up with ClientID as primary key with relationship one-to-many with tables 2 & 3. Tables 2 (rental info) & 3 (invoice info) are related thru ContractID as primary key one-to-one but also have a...

Thanks for the responses and I have convinced my boss I do not need to store if I calculate it to a query or report. I also had a revelation last night that once all data is entered I could run a "make table" to store the calculated fields. At some point I do want to store it (even though as a...

Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek: I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table...