Search results

Hi guys, I'm in need of some help!!! I have two tables: Table 1 holds information about a experiments, i.e. 1A, date started, equipment used etc. There are 24 parts to an experiment, i.e. 1A1, 1A2, 1A3 - 1A24 Table 2 holds information about each part. i.e. 1A1, used 5 people, 8 cars etc. I...

yes that's what I want. I can sort out the printing afterwards. I just need a way of putting in the criteria without putting in a new report and query. Any ideas?

They'll be getting the numbers they need from another source, so then they can just put them in the form and have the reports return the pages to be emailed. Is that what you meant?

Hi, I have a report 'Cards' based on a table 'Pimbook'. I'm trying to find a way to set criteria so that I can have specific pages printed without having to sort through them manually, there is over 900 pages. I would like a form that allows the user to put in a start number and an end number...

Now you know it's only cos they're jealous?!

Oh you're a little treasure - I knew I was near the answer but I was :confused: ! thanks Sue

Hi, I've looked through all the past entries on this but can't find exaclty what I need! I have a query which I want to sort via a form. For example, my query holds a range of records such as 295A-1H/2, 284A-1L/23...

We seem to have done okay so far!

Hi, I have code to convert the date to conventional date but don't know how to use it with Date diff.... Function CJulian2Date(JulDay As Integer, Optional YYYY) As Date If IsMissing(YYYY) Then YYYY = Year(Date) If Not IsNumeric(YYYY) Or YYYY \ 1 <> YYYY Or YYYY < 100 Or YYYY >...

I have two fields with julian dates in DOB 193.02 DOD 200.03 I have the calculations to find the amount of days inbetween basedon 365 days. However if DOB is 193.02 and DOD is 11.05 I'll need to add 1. Day diff : ([DaysYOB]+[DayDOD])+([TotalYears]*365)) You're making me wonder if this is...

mm, well yes that was my next hurdle really! Leap years? I thought I could just add one using an If statement? WOuld that work?

I thought it would be something simple - I@m a bit new at this you see!!! thanks Sue

Can anyone help? I'm trying to write an IIf statement but am getting a bit confused. I have several columns in a query. Two columns have a number in them, either 0 or 1. If these two columns are less than 2, (i.e. 1 and 0, or 0 and 0) then I wanted a calculation. I.e. Field = IIf ([Field1]...

Hi Bob, I don't think it's been too painful! I've had worse..tee hee.. anyway, as to your questions...I'm using the Julian dates as it really is easier this way. That's what we use to work with and so putting in 'normal' dates just to then get them calculated into Julian dates is a bit...

Hi, I've managed to do that which is great! Can I get rid of the Error message that appears before the info is entered? Can I then store this calculated field? I've seen loads of sites where people don't think you should store them...why? thanks Sue

I'll give the help files a go I think - my programming is very very basic!! thanks Sue

Hi, sorry just one more question! Now that I have managed that I can update it to my table but is there a way to do this automatically so it updates as soon as you enter the date or when you open the table? thanks again Sue

oooooooo that's a bit clearer- thank you so much! I knew it should be easier! you've saved me some time! thanks Sue

Hi I've tried that but it won't work. I don't really know how to adapt it. I followed exactly what you said. If I enter code into an empty query field it won't work since the field is not entered? how can I get round that? If I choose an empty field from the same table the code still doesn't...

The field is on a table with autonumber but it isn't autonumbered itself...I hope that's what you meant.