Recent content by ciskid

Hi Guys n Gals I was hopin for some code help on a database that I have ? I have a simple database where I have a field called information_log (see attached) This filed is a memo type of field and it basically is a log of information about a specific fault. So every day someone puts new...

Still didnt work Hi Matt Just tried And it made no difference.....arrghhhhhhhhhh :D Any other ideas ? Cheers Jimmy

Hi Folks I am having some issues with the dcount function on calculated fields within a query. I have a report where I have some custom expressions which dcount certain values from a query. But when I preview the report the expressions show "Error" See below which is the report in design...

Hio Adeptus Ive been away for a bit and Ive just cheecked out your post. Brilliant , all sorted now. can I ask you another question ? I have an expression and Im trying to find a value that is greater than 1 but less than 2 I cant seem to get it right ? Can you help me out ? Cheers Jimmy

Hi Folks I have been with a calulated filed in my querie. I have Expr1: ([dateopen]-[dateclosed]) Please remember that my dateopen and dateclosed are formatted as ddmmyy hhmm Its not as simlistic as I thought for instance here is a snapshot of my table So the 1st call was closed in...

Just thought I would let you know i did the following This gives me values in days 1.1 2.36 etc But at least now I can do a Dcount on all calls <=1 and may calls >1 >2 etc Watch this space. Still looking for amy good tips from you guys :-) Cheers Jimmy

Hi Folks Im in the realms of calculated filelds within queries :eek: Im now at a stage where I want another calucating field. I log fauts/problems/issues to a simple database This has a field called opendate When the case is closed, which it updates a filed called closedate The format is...

Hey Guys Many thanks, manage to sort it all out ! Now know how to use calculating fields in a query ;) Many thanks Cheers Jinmmy ;)

Hi Folks I have a simple table that has a date field. This is called dateopened and is in the format ddmmyy hh:m I have a query based on this table. What I'm trying to do is workout the day that a case was opened from the date entered. i.e I have an entry that was opened on 10/08/06 My...

Hi Ghudson Im using AC97. My DB was ok this morning , i.e I could see all the data. I then had a systrem crash, after that I have al the records in form view, i just cant see the tables etc Ive tried the shift key , and it doesnt work Its also not not behind my form ? Any ideas

Hi Folks This is driving me mad. I cant see the tables , queries etc , forms, reports when I click the Database window icon on the toolbar. I need to add some more fileds to my tables etc I have form that shows via startup. Here is a screenshot of my problem :-...

Anotehr question on querie expressions ? Hi RV I need some more advice =DCount("[Ref number]","main","[casestatus] = 'open'") The above does a dcount on the table main to find all open cases Imagine I have a query called test which is based on all records of the table main. I would like to...

ok all sorted I took ur advice and changed some of my fileds to no spaces and my expressions worked ok :D But thanks again :-)

More help needed Hi RV Another question ? =DCount("[Ref number]","main","[casestatus] = 'open' AND monthopen like '**/07/**'") I can make a query with has the criteria set too **/07/** and also where the status is open I can then do a DCOUNT on this query whcih would give me a count of all...

Thanks M8 Hi RV Many thanks for the reply. All sorted now ;) cheers Jimmy