JPR's latest activity
-
JJPR replied to the thread Date format mm/yyyy.Absolutely!!! No worries. It just made me have a good laugh!!
-
JJPR replied to the thread Date format mm/yyyy.Actually year is Anno. Ano ........totally different meaning.....:)
-
JJPR replied to the thread Date format mm/yyyy.Finally got it to work. Not sure if it's because I use an Italian language of Access. This is how I changed it. Expr1...
-
JJPR replied to the thread Date format mm/yyyy.The query has its record source to table1 and has the following fields: - DateCost - Amount Date cost has the format dd/mm/yyyy This...
-
JJPR replied to the thread Date format mm/yyyy.Thank you. Yes, the format is only to display data. I have copied the code in a new column of the query but I am getting a sintax or...
-
JHello, Is there a way a can show a date field in a query as mm/yyyy format? The query has its recods source to a table with a regular...
-
JJPR replied to the thread Print Report based on lstbox rowsource.Thank you. Just realized that I had referred to a different query. Correct. I had to walk my code first!!!!
-
JHello, I have a listbox on a form which is used to view data from different table. The listbox is populated by a combox and each query...
-
JJPR replied to the thread Sum Query and text box.Great. Just what I was looking for. Thank you
-
JJPR replied to the thread Sum Query and text box.Hello, appreciate your help. Unfortunately I am getting a character or syntax error code when copying the code in the textboxes. I am...
-
JJPR replied to the thread Sum Query and text box.
-
JJPR replied to the thread Sum Query and text box.Thank you for your help and time. I will give it a try.
-
JJPR replied to the thread Sum Query and text box.Works great. Is there also a way I could use a text box to display the result of these two different queries? Thank you
-
JHello, I am having some problems in creating Sum queries for my db. My db has a table named Clients with 3 fields: - Clients -...