SQL-Mathematical function

[fdtoo]

Hi - hopefully this is an easy query for any experts out there!
Suppose I want to know the cust_name & order_no with invoice date > 30 days
& 60 days old from the date of invoice, how do I query against a Microsoft Access
table via vb6.0 shown on a data report.

Table:


The result should show as below:

Customer name Order No > 30 DYS > 60 DYS Total

A A0001 4000 4000
B B0001 5000 5000
-----------------------------------
4000 5000 9000
===================================
SQL-Date function

Hi - hopefully this is an easy query for any experts out there!
I need to extract a weekly sales report from a table with 2 fields

Sales(field1)
Cost(field2)

The query result should be like:

Sales Cost GP GP%
400 200 200 A%
200 100 100 B%

GP% = GP/Sales X 100%

Can I extract such info via SQL from Microsoft Access table using vb6.0 with
Data report platform?

can anyone help? Thanks
Fromebbie