I have some fields in a table which store calculation results. I use update query to update the fields. The calculation formula likes this: A*B/C. The problem...

Hi Marco, I have tried this and cannot get it to replicate what is happening with yours. I am using Access 2003. Maybe someone else will be able to help...

1. Set everything to lower case. 2. Use the Left function to find the first character in the string and then use StrConv on it. 3. Use InStr to find periods...

I used the wizard to try and find if there are any duplicates of a combination of two fields in a table. The table is "tbl BFS1" and the two fields are...

I have a table which has different types of unit visits numbered 1 thru 9 but I only want types 3 or 4 which I can do. But when I want it to only show the...

Hi I have a query to return only last ten records added, made with wizard: SELECT TOP 10 Tbl_Sponsors.SponsorID, Tbl_Sponsors.Title, Tbl_Sponsors.FirstName,...

Hi all I want to print 1,000 A5 vouchers (only one of each record) two too view on an A4 sheet. When I guillotine the A4 in half and place the right stack...

Hi, I was able to occupy myself for a couple weeks without posting a question (yay!). But I am back again with a doozie. Hope someone can give me some...

Hi. At the moment that i'm inserting this #,##0 in the format my Access converts into this #,000 why it does these? Regards, Marco

Oops sorry, you could use FIELDNAME: Format(YOURFORMULA,"#,##0") & "€" Stu "Marco" wrote: Hi. It didn't work as I expected it returns me this:...

I'm trying to write a routine to 'clean out' various records from their source tables after I've copied that data to an 'archive' table. The application is to...

Hi. It didn't work as I expected it returns me this: 10.320,00€ Do you have any idea? Marco "stumac" wrote: Hi Marco, I am not sure that this is the...

Hi Marco, I am not sure that this is the most efficient way of doing this but I certainly got it to work: FIELDNAME: Format(YOURFORMULA,"Standard") &...

Hello. I need to transformas a value that is a result from a formula in a querie to appear as currecny. I've got this result from a formula: 10320 and I need...

My question is can wildcards be used in the parameter of a query. I have tried using wildcards but have had no luck. I have a form which uses queries to...

Database background: I have a reconciliation database that essentially loads 2 stock files and checks that the two reflect equal holdings. The files are...

I have field with Participants ages. I need to get the correct LE_VALUE from a fieled in my query. To do this I must subtract 10 from the age of my...

I have two tables that are the same, no validation rules all field names are equal. Now when I go to append them I get a type conversion failure, key...

I might be running in to a larger update query statement. Has anyone else dealt with this? If you have do you recall how you worked around...

Good evening all, I need to reference a column from a query in another column and I don't know how, or even if it is possible. Basically, say a field in the...