Search results

Try putting the memo field on a second page. Make a page break between all your fields on first page and memo field. hth Michael

Thanks for the help :D Michael

Sorry, I would like to have it as a rank. My field names are Car Make and TotalTheft from tblStolen Thanks, Michael

I have a query that gives me top stolen vehicles (descending order). I would like to add a field that will give the numerical numbers. For example HondaCivic 63 HondaAccord 26 JeepCherokee 25 I would like my query to look like this with a new field 1 HondaCivic 63 2 HondaAccord 26...

Glad I can help ;) and good luck. Michael

Set your field to general date. Take a look at the attachment Look at the query I made and you can run through a report. hth, Michael

Ignore my last post Try this DateDiff("h",[TimeOff],[TimeOn]) hth, Michael

Are you trying to subtract anything that is over 24 hours. For example if you have 31 hours - 24 hours. You only want the field to show 6 hours? If so, try this DateDiff("h",[TimeOff],[TimeOn])-24 Be sure to set you field for TimeOff and TimeOn to General Date. hth, Michael

Take a look at the attachment I made for crosstab query. I'm sorry I don't have time to make some adjustment, but I managed to get a crosstab query (tbl_AMROTABLE_Crosstab) of what you looking for. Maybe you can play around with it. Good Luck, Michael

From what I'm getting is that you want to break it down by the amount? Test 1 = 500$ Test 1 = 600$ If you get another 500$ that will be Test 2 = 1000$ If you get another 600$ that will be Test 2 = 1200$ Right? Take a look at the attachment. If you look at the client/contract report you will...

Take a look at the attachment I posted on this link. http://www.access-programmers.co.uk/forums/showthread.php?t=77547 hth, Michael

Glad I can help ;) Michael

Take a look at the sample. Open the report called client/contract. hth, Michael

Take a look at the sample file. hth, Michael

You can try setting up a password for any form that you wish to open. If so, search the forums on Form Password. You will find plenty of database samples. hth, Michael

Another way you can try is make a security folder on your hard drive. This will be prevent users from making changes to a folder and your database. (Setting up a password in a database can easily be erased.) hth, Michael

No Problem ;) Michael

Try pasting the code below either on Form_Current or Command Button. It will lock the fields after it been typed and/or leave the blank fields open for data entry. Dim Ctl As Control 'create a variable for the forms controls Dim Frm As Form ' create a variable for the form Set Frm = Me ' Sets...

Why do you have 8 queries in a report? Make 1 query for all fields and run it a report. hth, Michael

Rich, I've been told is not a good idea to place a crosstab query in report(subreport). That what I learned in class. Michael