Recent content by chriscwilson

Hi Mike I hope things are improving for your family. Yes, you can achieve the same results in SQL. You can create a table of reference invoice numbers as described above, use a SQL query to populate it and then create a view using the SQL above. Crystal should be able to report on the view as...

One way of getting to the answer would be to put a message box displaying the text in strSQL as the next line after the assignment (i.e. after strSQL=) MsgBox "strSQL is " & strSQL You may see that the SQL statement is not properly formed because there are no quotes around the company name...

Hey, great idea - best beer in the UK here!! :D

Thanks Paul, it is a lovely area, I sometimes work in London but live in the country. Best of both worlds! Good to know you have a connection with Bury St Edmunds.

Try var=Me.rating.Value or var=Me.rating.Text ? Chris

Thanks Bob, I hope I can help. I run my own business and I pick up most of my work through referrals.

Hi You can generate some data using a query in Access that will show missing invoices and then report on it from Crystal. I created a sequence of invoice numbers in a table 'InvoiceNumbers' in the same format as you describe. I then created a database of dummy invoice data in a table...

Hi I'm Chris Wilson and I was directed to this forum by someone I helped with an MS Access application recently. I'm an IT Consultant with 25 years experience in the database world and I have worked with MS Access in many situations. I aim to contribute what I can to the forums but, to be...