Search results

Hi This webpage might help. Andrew

Ah yes - that piece of information might have been useful a few days ago ... ;) Anyway, in your report design, select the field in question, and try something like this for the format : $#,##0.00 ; [Red]-$#,##0.00 Or 0.00 ; [Red]-0.00 if you don't want the $ sign Or 0 ; [Red] -0 if you...

Can you edit any of the fields in the underlying query? Andrew :)

What have you done so far? What are the fields in your table of products? And what are the fields in your invoice items table? What you want to do can definitely be done - let us know what you have done so far so that we dont go over things you have covered already. Andrew :)

Hi Assuming there is a field common to the 2 tables, include both tables in your query, and change the join between the tables to include all records from Table A and only matching records from Table B (double click on the link between the tables to access this option). Include the job title...

Hi You could set your field format to something like this: $#,##0.00 ; [Red]-$#,##0.00 ; - ; - It will give a dash for zero values, and I believe it gives a dash for null values too (albeit slightly out of alignment?) HTH, Andrew :)

Hi Ricky Can you post the SQL for both queries and indicate which is the field you want at the top of the report? Andrew

Hi Brad If you wrap the Weekday() function around your date field in a query (e.g. Weekday([AbsentDate]), this will give you the day number of the week (from memory 1 = Sunday). You can then use this in a crosstab query to get a count of absences by employee by day of the week. Any totals...

I haven't read your post in detail (maybe I should?) but the 'dlookup' function comes to mind - it can look up values from another 'domain' (e.g. query) using criteria. If you look it up in your VB help file (via Alt-F11) then it might answer your question. Andrew :)

Apologies for what appears to be a really lame post compared to 'Jon K' - I replied to a post in the 'forms' forum that was subsequently locked (for being a double post) and my post ended up in this thread....... :cool:

Hi Brad While in your report design, click the field in question and on your menu click Format -> Conditional Formatting -> the rest should be easy. Andrew :)

Hi Charley I'm not sure if this will help but assuming the difference between the arrival time and departure time can not exceed 24 hours, and assuming the arrival time occurs before the departure time (e.g. like in an airport transit lounge), then use the following in your query to work out...

Hi If I understand your question correctly, there is no formula required. You can do this by creating a new query, click View -> Totals, group By the date and change the 'Group By' to 'Count' for whatever field it is that you want to count. HTH, Andrew :)

Hi Chad The 'Case' statement comes to mind but I'm not sure if that is what you are after. Can you explain what you are trying to do (i.e. why the differing lengths) and why there are 200 different cases? Andrew

Hi Greg I'm not sure what you mean by 'multiple field index' but one way of preventing duplicate entries is in your table design - select multiple fields and click the 'key' symbol. This might be what you mean when you refer to a 'multiple field index' - I have also seen it referred to as a...

Depending on your version of Access, there is a MS webpage here that might help for Acc2003. Personally I prefer to create menu bars using macros, using the "Addmenu" command - you can have line breaks, underlined characters & submenus using this method. I then link the form to the menu by...

Hi Chad How about a small function like this in the 'AfterUpdate' property of both the combo box and text box on the form? Private Sub cboBox1 _AfterUpdate() On Error GoTo Err_cboBox1 If Me.cboBox1 = 840 And Len(Me.txtBox2) > 6 Then Me.txtBox2 = Left(Me.txtBox2, 3) Else If Me.cboBox1...

Hi Mike Go into the form design, click Edit -> Select Form, click View -> Properties -> Data Tab -> Record Source -> this is the table (or query) that the form is linked to. It often helps to prefix your table names with "tbl" or "T_" and queries with something like "qry" or "Q_" so that you...

Hi Rajput You are correct - you need to base your form on a query. Create a new query, including all of the pieces of information that you want to see on the form. Make sure you include the date field. Use the query wizard to help you set up the query. Once you have a query showing all of...

Hi Can you confirm you want the one business type per business? Also, does each business have only one category or many categories? Lastly, are the categories restricted by the choice of business type? Andrew :)