Recent content by ThomasJF

Hi again I am doing three Crosstab Querys that is supposed to show how many sales a person has weekly, monthly and Quarterly. I used this function to fix the quarterly: Quarter: "Qtr " & DatePart("q";[TBL_Day].[Date];1;0) My question is: How do I alter it so it sorts by...

Thank you for the answer, but I am a bit slow, so could you please explain the following:<br>1. Do I use the expression builder or the code builder? Is there any difference?<br>2. the &quot;Me.Date&quot; is that where you put [table].[field]?<br><br>Thanks again :)<br><br>-Thomas Fyhn

Hello!<br>I have a problem doing the following:<br>In a table, I would like to set the default value in a field equal to an other field in the same table (date). <br>Is there any way i can do this? <br><br>Thanks for any help<br><br>Best regards,<br>Thomas Fyhn<br>

No, I did it exactly as you told me, but it still deletes...strange.<br><br>But I wonder if this is a method I can use:<br>In my member query i added the following:<br>10-year-distinction: DateAdd(&quot;yyyy&quot;;10;[TBL_member].[enrolled])<br>Then I have the date, but how can I hide the fields...

Ok, thank you for the answer. It worked. Sort of.<br>The only problem is that it deleeted all the posts that <br>not yet has got a distinction. Can this be done so that only the &quot;distinction&quot; field becomes blank?<br><br>Best Regards,<br>Thomas Fyhn<br>

Hello!<br>I have run into a problem when trying to create a database in MS Access.<br>The database is a register for members in a organization.<br>When a person has been a member for 10 years , he or she gets a distinction.<br><br>My &quot;TBL_member&quot; table looks like this: (in addition to...