Tee Time Report (1 Viewer)

K

Keith166

Registered User.

Local time

Today, 22:23

Joined

Nov 4, 2007

Messages

43

• Nov 29, 2018

• #1

I'm having trouble duplicating in Access a report (Spreadsheet) that I've produced in Excel. The report is a list of golf player tee times for a particular day. You can vie the spreadsheet in Dropbox - see below.

I simply need 3 sub-forms each containing 3 columns of data (Times, Names, type) ending at a certain number of rows and then continuing in the next column etc.

Hope someone can assist with this.

Regards

Keith

 

June7

AWF VIP

Local time

Today, 04:23

Joined

Mar 9, 2014

Messages

5,470

• Nov 29, 2018

• #2

Image link is not working for me. Try embedding image in the post.

Show raw data source.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

K

Keith166

Registered User.

Local time

Today, 22:23

Joined

Nov 4, 2007

Messages

43

• Nov 29, 2018

• #3

 

K

Keith166

Registered User.

Local time

Today, 22:23

Joined

Nov 4, 2007

Messages

43

• Nov 29, 2018

• #4

I sent you the link.
Here it is again:

https://www.dropbox.com/s/jxbcdkf5yt7un08/2018-11-29_14-29-25.png?dl=0

Hope you can open it.

Keith

 

June7

AWF VIP

Local time

Today, 04:23

Joined

Mar 9, 2014

Messages

5,470

• Nov 29, 2018

• #5

Okay, third time a charm.

Reproducing this with data in Access won't be simple. Probably require a bunch of code.

 

Last edited: Nov 29, 2018

K

Keith166

Registered User.

Local time

Today, 22:23

Joined

Nov 4, 2007

Messages

43

• Nov 29, 2018

• #6

Great!
Would you like to see the actual excel spreadsheet - I can link you to it?
If you think it can be done in Access97 then we'll need to discuss how you can view or give you access to our Database.
Cheers
Keith

 

June7

AWF VIP

Local time

Today, 04:23

Joined

Mar 9, 2014

Messages

5,470

• Nov 29, 2018

• #7

Not saying I want to develop for you. I have seen Access used for calendaring (appointment schedules) and they are complicated.

Review these discussions
http://www.accessforums.net/showthread.php?t=45047
http://www.accessforums.net/showthread.php?t=45375

 

K

Keith166

Registered User.

Local time

Today, 22:23

Joined

Nov 4, 2007

Messages

43

• Nov 29, 2018

• #8

Hi June7
I'm not an Access programmer but have a good idea of the basics. Can you tell me if what I'm trying achieve is possible and are you in a position to quote me a price.
Are you in Australia?
Cheers
Keith

 

June7

AWF VIP

Local time

Today, 04:23

Joined

Mar 9, 2014

Messages

5,470

• Nov 29, 2018

• #9

I am sure it would be possible. Not a professional programmer. Not in Australia.