reports

  • Thread starter Thread starter Craig23
  • Start date Start date
C

Craig23

Hi I am trying to create a report for invoicing, but I not having any look
finding the expression so that if I have data plus date for instance I can
not get a long date, or is I null my expressions for curreny it takes out the
£ sign and the 0's, ( I hope I have explained it properly!)
Thanks
 
If the currency value is the only thing in the text box, set the control's
Format property to Currency or Short Date or whatever.

If the expression is more complex, use the Format() function in the
expression, e.g.:
="Please pay " & Format([Amount], "Currency") & " by " &
Format([DueDate], "Medium Date")
 
Thank you for your reply, please read on and see the following 2 examples, on
the first example you'll notice that although I want the long date it doesn't
show it, second one I can not get the £ sign to show in the report or the 0s,
maybe i might have to charge some thing in either tables, quary or report

="on the " & [date of birth]

=IIf(Len(nz([Charges1]))=0,Null,[Charges1] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges2]))=0,Null,[Charges2] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges3]))=0,Null,[Charges3] & Chr(13) & Chr(10))

Thank you very much

Allen Browne said:
If the currency value is the only thing in the text box, set the control's
Format property to Currency or Short Date or whatever.

If the expression is more complex, use the Format() function in the
expression, e.g.:
="Please pay " & Format([Amount], "Currency") & " by " &
Format([DueDate], "Medium Date")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Craig23 said:
Hi I am trying to create a report for invoicing, but I not having any look
finding the expression so that if I have data plus date for instance I can
not get a long date, or is I null my expressions for curreny it takes out
the
£ sign and the 0's, ( I hope I have explained it properly!)
Thanks
Click to expand...
Click to expand...
 
I don't think you read the previous reply.

I fail to see where you used the Format() function as shown.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Craig23 said:
Thank you for your reply, please read on and see the following 2 examples,
on
the first example you'll notice that although I want the long date it
doesn't
show it, second one I can not get the £ sign to show in the report or the
0s,
maybe i might have to charge some thing in either tables, quary or report

="on the " & [date of birth]

=IIf(Len(nz([Charges1]))=0,Null,[Charges1] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges2]))=0,Null,[Charges2] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges3]))=0,Null,[Charges3] & Chr(13) & Chr(10))

Thank you very much

Allen Browne said:
If the currency value is the only thing in the text box, set the
control's
Format property to Currency or Short Date or whatever.

If the expression is more complex, use the Format() function in the
expression, e.g.:
="Please pay " & Format([Amount], "Currency") & " by " &
Format([DueDate], "Medium Date")

Craig23 said:
Hi I am trying to create a report for invoicing, but I not having any
look
finding the expression so that if I have data plus date for instance I
can
not get a long date, or is I null my expressions for curreny it takes
out
the
£ sign and the 0's, ( I hope I have explained it properly!)
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Allen I do hope you read this, thank you ever so much for your help after
digesting what you told me to do and I stopped being such a defeatist I did
it after god knows how long and no hair left HAHA.

Again thank you
Craig

Allen Browne said:
I don't think you read the previous reply.

I fail to see where you used the Format() function as shown.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Craig23 said:
Thank you for your reply, please read on and see the following 2 examples,
on
the first example you'll notice that although I want the long date it
doesn't
show it, second one I can not get the £ sign to show in the report or the
0s,
maybe i might have to charge some thing in either tables, quary or report

="on the " & [date of birth]

=IIf(Len(nz([Charges1]))=0,Null,[Charges1] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges2]))=0,Null,[Charges2] & Chr(13) & Chr(10)) &
IIf(Len(nz([Charges3]))=0,Null,[Charges3] & Chr(13) & Chr(10))

Thank you very much

Allen Browne said:
If the currency value is the only thing in the text box, set the
control's
Format property to Currency or Short Date or whatever.

If the expression is more complex, use the Format() function in the
expression, e.g.:
="Please pay " & Format([Amount], "Currency") & " by " &
Format([DueDate], "Medium Date")

Hi I am trying to create a report for invoicing, but I not having any
look
finding the expression so that if I have data plus date for instance I
can
not get a long date, or is I null my expressions for curreny it takes
out
the
£ sign and the 0's, ( I hope I have explained it properly!)
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top